Re: FW: 2 instances

["Andy Shellam" <andy@xxxxxxxxxx>]

The problem you’ve got is that there’ll always be 2 configurations – one for your “default” instance and one for your 5433 instance.

 

I believe (I could be wrong here), that postgresql.conf is just for the server side – it’s the client tools you’re connecting with, so they need to know which port to connect to (of which 5432 is default, unless changed in your configure script.)

 

You could put:

 

PGPORT=XXXX

export PGPORT

 

in each of your user’s .profile (or .bash_profile) scripts (replacing XXXX with either 5432 or 5433 dependent on which cluster you want the user to connect to.)  Then the PG client tools will read that as the port number (to save putting “-p 5433” in the command line.)

 

Regards

 

Andy

 

---

From: H.J. Sanders [mailto:hjs@xxxxxxx]
Sent: 04 July 2006 1:54 pm
To: andy@xxxxxxxxxx
Subject: RE: [ADMIN] FW: 2 instances

 

Hello Andy.

 

This does indeed the tric  ( -p 5433).

 

I expected that this port 5433 would be taken from $PGDATA/postgresql.conf

 

Is this also possible?

 

Many thanks

 

Henk

 

-----Oorspronkelijk bericht-----
Van: Andy Shellam [mailto:andy@xxxxxxxxxx]
Verzonden: dinsdag 4 juli 2006 13:28
Aan: 'H.J. Sanders'
CC: pgsql-admin@xxxxxxxxxxxxxx
Onderwerp: RE: [ADMIN] FW: 2 instances

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

 

 

 

Hello.

 

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!

 

What am I missing?

 

Many thanks

 

Henk Sander

 

 

 

 

!DSPAM:14,44aa651c256842130418775!