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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
