Multiple Postgres Instances - Mailing list pgsql-general

From David Giffin
Subject Multiple Postgres Instances
Date
Msg-id Pine.BSF.4.05.9901201716001.7142-100000@central.agent911.com
Whole thread Raw
List pgsql-general
Hello,

I'm trying to run postgres on two different post 5432 and port 5433 with
different data directories for each instance:


[ -x /usr/local/pgsql/bin/postmaster ] && {
        su -l postgres -c '/usr/local/pgsql/bin/postmaster -S -i'
        echo -n ' pgsql'
}

[ -x /usr/local/pgsql/bin/postmaster ] && {
        su -l postgres -c '/usr/local/pgsql/bin/postmaster
-D/usr/local/pgsql/data_5433 -p5433 -S -i'
        echo -n ' pgsql'
}


But when I do a psql -p 5433 and drop a table it seems to drop in both
instances. If anyone has attempted this before I like to hear how it
worked.

David


pgsql-general by date:

Previous
From: Robert Chalmers
Date:
Subject: What is happening here? ODBC. r+w on one, r only on other
Next
From: Robert Chalmers
Date:
Subject: RE: ODBC question on R+w and +r only. solved