Changes between Version 6 and Version 7 of SetupOnTiger


Ignore:
Timestamp:
Jan 28, 2006, 5:33:13 PM (19 years ago)
Author:
anonymous
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • SetupOnTiger

    v6 v7  
    1717=== Installing |PostgreSQL ===
    1818
    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. :)
    3131
    3232=== Installing psycopg (|PostgreSQL Bindings) ===
Back to Top