Search Postgresql Archives

Re: Q re installing Pg on OS X?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux