On Mon, Dec 21, 2009 at 2:26 PM, Scott Mead <scott.lists@xxxxxxxxxxxxxxxx> wrote: > > On Mon, Dec 21, 2009 at 4:17 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> > wrote: >> >> >> Yes, it's fine. Make a different data dir, point the postgresql.conf >> gile to a different tcp port and off ya go. I do it all the time to >> test slony setup at work. > > Agreed, I've actually used it for a couple of different reasons, including > production in a couple of different architectures, no worries about it, > other than making sure you have enough memory on the box to support them > all, along with the remembering which instance you're logged into at a given > time :) Yeah, I create a different "admin" account for each one, that has the PGPORT and stuff already set, and setup pg_hba.conf to reject the admin accounts from other instances so I don't do anything too stupid. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin