Обсуждение: simple question about two 'servers' on same OS

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.

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