Re: Q re installing Pg on OS X?

Seneca Cunningham wrote:
> On Sun, Apr 15, 2007 at 06:18:18PM -0400, Kynn Jones wrote:
>
>> Still, it would be nice to have more up-to-date instructions on how to
>> install PostgreSQL on OS X. Any pointers would be much appreciated!
>>
>
> Try the main documentation
And just for the record, PostgreSQL compiles and installs smoothly from
source code when you have XCode (developer tools) installed, using the
instructions in the INSTALL file in the tar ball.

Notes:
*) Use 'make' instead of 'gmake' as indicated (OS X make is GNU make)
*) OS X doesn't have an 'adduser' command

Either use the GUI or create a postgres user on the command line using
niload, e.g.:

sudo niload group . <<EOF
postgres:*:5432:
EOF

sudo niload passwd . <<EOF
postgres:*:5432:5432::0:0:postgresql superuser:/var/empty:/usr/bin/false
EOF

where 5432 is the user id and group id you are assigning (check
availability with 'nidump group .' and 'nidump passwd .').

This assumes you are an admin user (in the admin group), so you can run
'sudo'.

The resulting postgres account is not a login account.

When you need to do things under the identity of the postgres superuser,
you can issue commands like this:

sudo -u postgres somecommand ...

It's not hard to create a suitable startup item under
/Library/StartupItems/ to make sure PG starts automatically and to make
it easy to bring it up and down when you have to.

-Kevin