Re: postgresql and Mac OS X

> When I do the install script in contrib it says I have no rights to
> the directory. It was in /usr/local/pgsql/data/log and I changed it
> to /usr/local/pgsql/log. It was set as root.wheel with 755
> permissions so I suspect it's mad at me because the postgres user
> was left in the cold.

Have you switched on logging in postgresql.conf?

> Now - I have what I hope is the last question related to Mac OSX and
> not so much the Postgresql. How do you start/stop services without
> rebooting the machine? I tried launchctl but it's not listed.

I installed PostgreSQL from source (configured using pgsql as system
username) and use one of:

sudo -u pgsql /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start
sudo -u pgsql /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop
sudo -u pgsql /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data
restart
sudo -u pgsql /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data
reload

(reload if i have just changed some configuration parameters).

You may have to substitute postgres for pgsql eg

sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data
start