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. :) |