PostgreSQL - npalko/npalko.github.com GitHub Wiki

/usr/local/etc/rc.d/postgresql restart

su pgsql

postgresql.conf

listen_addresses = '*' port = 5432

pg_hba.conf

host all all 0.0.0.0/0 trust

psql postgres \du - list users \l - list databases

create user npalko superuser;

os X install:

###########################################################

A startup item has been generated that will aid in

starting postgresql90-server with launchd. It is disabled

by default. Execute the following command to start it,

and to cause it to launch at startup:

sudo port load postgresql90-server

########################################################### ---> Installing postgresql90-server @9.0.3_0

To create a database instance, after install do sudo mkdir -p /opt/local/var/db/postgresql90/defaultdb sudo chown postgres:postgres /opt/local/var/db/postgresql90/defaultdb sudo su postgres -c '/opt/local/lib/postgresql90/bin/initdb -D /opt/local/var/db/postgresql90/defaultdb'

To tweak your DBMS, consider increasing kern.sysv.shmmax by adding an increased kern.sysv.shmmax .. to /etc/sysctl.conf