Herbie,
> In your system startup script. On my OpenBSD system, I use:
> if [ -x /usr/local/bin/pg_ctl ]; then
> su -l pgsql -c "/usr/local/bin/pg_ctl start -w -o \"-i -B 512\" \
> -D /var/pgsql/data -l /var/pgsql/logfile.`date
> +\%Y\%m\%d`" echo -n ' pgsql'
I, on the other hand, find it much easier to manage Postmaster settings using
the postgresql.conf file, and do only:
pg_ctl -D /usr/local/pgsql/data -l /var/log/postgresql
using the options in the .conf file to set TCP/IP networking, buffers, and all
of the other settings.
--
Josh Berkus
Aglio Database Solutions
San Francisco