Обсуждение: Me again..nOOb alert

Where in all of the options does one set the -y option for postmaster?

--Herbie

On Sunday 01 June 2003 05:16, Herbie McDuck wrote:
> Where in all of the options does one set the -y option for postmaster?
>

GAWD..can't type either..that should be the -i option..:(

--Herbie

At 05:36 AM 6/1/03, Herbie McDuck wrote:

>On Sunday 01 June 2003 05:16, Herbie McDuck wrote:
> > Where in all of the options does one set the -y option for postmaster?
> >
>
>GAWD..can't type either..that should be the -i option..:(


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'
fi

Frank

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