Обсуждение: pg_ctl -o options
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
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. +