| 19 | | 1. Create a new user, ''postgres'' in the Accounts Pane of the Mac OS X System Preferences |
| 20 | | 1. Download and unpack latest stable \PostgreSQL tarball |
| 21 | | 1. {{{./configure --prefix=/usr/local/pgsql; make; sudo make install}}} |
| 22 | | 1. Add {{{export PATH=/usr/local/pgsql/bin:$PATH}}} and {{{export MANPATH=/usr/local/pgsql/man:$MANPATH}}} to {{{~/.profile}}} |
| 23 | | 1. Add {{{export PGDATA=/usr/local/pgsql/data}}} to {{{~/.profile}}} '''NOTE: If this isn't set, ''postgres'' will complain about a missing conf file.''' |
| 24 | | 1. Open a new terminal session |
| 25 | | 1. Type {{{psql -V}}} and check that it is the version you just installed |
| 26 | | 1. Create a data directory: {{{sudo mkdir $PGDATA}}} |
| 27 | | 1. Change ownership to postgres: {{{sudo chown postgres:postgres $PGDATA}}} |
| 28 | | 1. Create the initial data area: {{{sudo -u postgres initdb -D $PGDATA}}} '''NOTE: {{{sudo}}} means ''substitute user and do'', and in this case with the initial {{{-u}}} parameter, we are telling sudo to run the command as ''postgres'' rather than ''root''.''' |
| 29 | | 1. To run the database (will not be automatically started on boot): {{{sudo -u postgres pg_ctl start}}} |
| 30 | | 1. Open a new window, and type {{{sudo -u postgres createdb test}}}. If it says {{{CREATE DATABASE}}}, it's working. :) |
| | 19 | 1. Create a new user, ''postgres'' in the Accounts Pane of the Mac OS X System Preferences |
| | 20 | 1. Download and unpack latest stable \PostgreSQL tarball |
| | 21 | 1. {{{./configure --prefix=/usr/local/pgsql; make; sudo make install}}} |
| | 22 | 1. Add {{{export PATH=/usr/local/pgsql/bin:$PATH}}} and {{{export MANPATH=/usr/local/pgsql/man:$MANPATH}}} to {{{~/.profile}}} |
| | 23 | 1. Add {{{export PGDATA=/usr/local/pgsql/data}}} to {{{~/.profile}}} '''NOTE: If this isn't set, ''postgres'' will complain about a missing conf file.''' |
| | 24 | 1. Open a new terminal session |
| | 25 | 1. Type {{{psql -V}}} and check that it is the version you just installed |
| | 26 | 1. Create a data directory: {{{sudo mkdir $PGDATA}}} |
| | 27 | 1. Change ownership to postgres: {{{sudo chown postgres:postgres $PGDATA}}} |
| | 28 | 1. Create the initial data area: {{{sudo -u postgres initdb -D $PGDATA}}} '''NOTE: {{{sudo}}} means ''substitute user and do'', and in this case with the initial {{{-u}}} parameter, we are telling sudo to run the command as ''postgres'' rather than ''root''.''' |
| | 29 | 1. To run the database (will not be automatically started on boot): {{{sudo -u postgres pg_ctl start}}} |
| | 30 | 1. Open a new window, and type {{{sudo -u postgres createdb test}}}. If it says {{{CREATE DATABASE}}}, it's working. :) |