Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_ctl -o options

pg_ctl -o options

From
Frank Bax
Date:
Our psql server has been upgraded several times over the years.

The start-up includes some -o options, namely:
-o '-i -B 3500 -D /var/pgsql/data'

I'm looking into replacing cli options with config file options.

-D /var/pgsql/data
It appears that startup works just fine if I drop this option

-B 3500
I don't know about all the previous upgrades; but these days we always
run initdb and then restore databases into new install.  Current docs
indicate this should have a kB or MB suffix?  What value should I
specify in postgresql.conf if replacing this option?

-i
In 'man postgres', the '-i' narrative indicates
    listen_address = *
But narrative in postgresql.conf mentions default is
    listen_address = 'localhost', '*' = all
Are these two options really equivalent? Should there be two equals?

Frank

Re: pg_ctl -o options

From
Bruce Momjian
Date:
Frank Bax wrote:
> Our psql server has been upgraded several times over the years.
>
> The start-up includes some -o options, namely:
> -o '-i -B 3500 -D /var/pgsql/data'
>
> I'm looking into replacing cli options with config file options.
>
> -D /var/pgsql/data
> It appears that startup works just fine if I drop this option
>
> -B 3500
> I don't know about all the previous upgrades; but these days we always
> run initdb and then restore databases into new install.  Current docs
> indicate this should have a kB or MB suffix?  What value should I
> specify in postgresql.conf if replacing this option?

This is currently in 8k pages.  If you want kb or MB, you have to
multiple it by 8k.

> -i
> In 'man postgres', the '-i' narrative indicates
>     listen_address = *
> But narrative in postgresql.conf mentions default is
>     listen_address = 'localhost', '*' = all
> Are these two options really equivalent? Should there be two equals?

It is confusing --- it is saying listen_address="*" is all.  That second
equals is just short-hand for "the same as".

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +