Postgres SQL

Creating and running Postgresql on mac

I am using macports for the installation Run sudo port install postgresql92 and then sudo port install postgresql92-server Once the server has been installed, run the following To create a database instance, after install do  sudo mkdir -p /opt/local/var/db/postgresql92/defaultdb sudo chown postgres:postgres /opt/local/var/db/postgresql92/defaultdb sudo su postgres -c ‘/opt/local/lib/postgresql92/bin/initdb -D /opt/local/var/db/postgresql92/defaultdb’ The output you will see The files …