Re: starting postgres with several Data directories

On Mon, Dec 21, 2009 at 2:26 PM, Scott Mead
<scott(dot)lists(at)enterprisedb(dot)com> wrote:
>
> On Mon, Dec 21, 2009 at 4:17 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> 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.