How are you connecting to Postgres?
Note that you’ll always need to give
the port 5433 to connect to the second instance in any tool you use (psql,
pg_dump, other management utilities etc), otherwise you’ll always connect
to the “default” instance on 5432.
Andy
From: pgsql-admin-owner@xxxxxxxxxxxxxx
[mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On
Behalf Of H.J. Sanders
Sent: 04 July 2006 12:22 pm
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: [ADMIN] FW: 2 instances
I would like to run 2 instances of
postgresql with 2 different data-directories: dir-a en dir-b.
Looking trough the archives I came to the
next setup:
I created this 2 different directories
and 2 users each with a different PGDATA(dir-a and dir-b) in their .profile
Using this 2 users i did twice initdb and
createdb xyz with the first user.
in postgresql.conf of the second
directory I changed the port to 5433 and also entered this port in
/etc/services and started the second
postmaster, ps -f shows it is running.
If I now want to create the same database
xyz in the second directory using the second user,
the database is already there!
!DSPAM:14,44aa4fb8256841932014477!
