Re: Run 4 postgresql session on ONE server?

On Fri, 13 Jun 2003, Tom Lane wrote:

> "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> > Yes, you can do it. All you have to do is create four seperate accounts
> > for it to run under (pgsql1, pgsql2, pgsql3, pgsql4) and then in each of
> > those accounts, set up a different PGDATA value and initdb as that user.
> > Then edit each account's postgresql.conf to have a different port number
> > (I just incremented from 5432 to 5433 etc...) and start them up.
>
> You don't really need N users, unless you have more protection concerns
> than you mentioned (like you want each database to have its own DBA with
> no access to the other ones). A single "postgres" Unix userid can serve
> for all the postmasters in typical cases. All you really need are a
> separate data directory and a separate port number for each postmaster.

The reason I always setup multiple users is so things like pg_ctl and all
still work the same, plus it lets you pawn off maintenance of the
"secondary" databases to other folks while keeping the main user account
for the real DBA.