simple question about two 'servers' on same OS
simple question about two 'servers' on same OS
От:
Gary Webster <webster@lexmark.com>
Дата:
Hello.
When running two 'separate' instances of Postgres on the same machine (diff ports), do I also have two separate installs of the binaries (prefix), or only two separate datadir ?
If the former, should I make another "postgresb" superuser, or use the same one?
If I have two separate prefix dirs, & only one "postgres" superuser, which is its home dir, or does it matter?
Thanks.
When running two 'separate' instances of Postgres on the same machine (diff ports), do I also have two separate installs of the binaries (prefix), or only two separate datadir ?
If the former, should I make another "postgresb" superuser, or use the same one?
If I have two separate prefix dirs, & only one "postgres" superuser, which is its home dir, or does it matter?
Thanks.
Re: simple question about two 'servers' on same OS
От:
"Joshua D. Drake" <jd@commandprompt.com>
Дата:
On 08/01/2012 12:44 PM, Gary Webster wrote: > Hello. > > When running two 'separate' instances of Postgres on the same machine > (diff ports), do I also have two separate installs of the binaries > (prefix), No > or only two separate datadir ? Yes > If I have two separate prefix dirs, & only one "postgres" superuser, > which is its home dir, or does it matter? Doesn't matter. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC @cmdpromptinc - 509-416-6579