postgresql_normal_user.md

Install Postgresql as a normal user (no root)

Download generic Linux binaries

• https://www.postgresql.org/download/linux/

• https://www.enterprisedb.com/download-postgresql-binaries

• Download link for Linux x64

• Documentation

Server Configuration

Initialize data directory.

$ mkdir postgresql
$ initdb -D ./postgresql/

Start the server

$ pg_ctl -D ./postgresql/ -l postgresql.log start

Create database named example:

$ createdb example

REPL:

$ psql example

Quit REPL:

example=# \q

Connecting from Julia

using LibPQ, DataStreams, NamedTuples
conn = LibPQ.Connection("dbname=example")
result = execute(conn, "SELECT * FROM TB_TEST")
data = Data.stream!(result, NamedTuple)