Ian Barwick <[EMAIL PROTECTED]> writes:
> You only need to compile PostgreSQL once (e.g. with
> --prefix=/usr/local/pgsql-733); by supplying different data directories and
> logfiles etc. on server start you can run multiple instances simultaneously
> under the same system user.
Or different users --- there was a thread on this topic just a couple
days ago wherein someone (Scott Marlowe I think) pointed out the safety
advantages of using different OS userids for the different postmasters.
You need a separate port number for each instance as well as a data
directory. Depending on how you work, it might be worth your trouble
to make a separate Postgres build for each instance, because then you
can wire in the correct port number as default for each build, using
configure's --with-pgport option. I do this because I like to have
several back versions of Postgres running on my development machine.
When I want to talk to the 7.2 server, for instance, I just have to
launch the 7.2 version of psql, and everything works. But if all your
installations will be the same version, you only need one copy of psql,
and it's probably easier to fool with PGPORT settings on the client side
than to make customized builds.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
