Re: pg_ctl -o options - Mailing list pgsql-novice

From Bruce Momjian
Subject Re: pg_ctl -o options
Date
Msg-id 201106110339.p5B3dDb22443@momjian.us
Whole thread Raw
In response to pg_ctl -o options  (Frank Bax <fbax@sympatico.ca>)
List pgsql-novice
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. +

pgsql-novice by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Array Contained By Array Question
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: how to recover a domain types and constraints?