Multiple Postgres Instances

From: David Giffin <david(at)agent911(dot)com>
To: pgsql-general(at)hub(dot)org
Subject: Multiple Postgres Instances
Date: 1999-01-21 01:19:15
Message-ID: Pine.BSF.4.05.9901201716001.7142-100000@central.agent911.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Chalmers 1999-01-21 01:21:36 What is happening here? ODBC. r+w on one, r only on other
Previous Message James Thompson 1999-01-21 00:11:05 Max length of a field name