From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Frank Bax <fbax(at)sympatico(dot)ca> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: pg_ctl -o options |
Date: | 2011-06-11 03:39:13 |
Message-ID: | 201106110339.p5B3dDb22443@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Yves F. Barbier | 2011-06-12 05:05:12 | how to recover a domain types and constraints? |
Previous Message | Merlin Moncure | 2011-06-10 20:49:03 | Re: Array Contained By Array Question |