Re: FW: 2 instances
| От | Andy Shellam |
|---|---|
| Тема | Re: FW: 2 instances |
| Дата | |
| Msg-id | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAAC4AAAAAAAAAt+qV6pqKPEmXG74TlFgX5gEAlpDSN+DrMEWnumhoRHpQKQAAAbLc9wAAEAAAAPbkNl9akWdCjmQER9jKdGIBAAAAAA==@andycc.net обсуждение исходный текст |
| Ответ на | FW: 2 instances ("H.J. Sanders" <hjs@rmax.nl>) |
| Список | pgsql-admin |
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@rmax.nl]
Sent: 04 July 2006 1:54 pm
To: andy@andycc.net
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@andycc.net]
Verzonden: dinsdag 4 juli 2006 13:28
Aan: 'H.J. Sanders'
CC: pgsql-admin@postgresql.org
Onderwerp: RE: [ADMIN] FW: 2 instancesHow 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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of H.J. Sanders
Sent: 04 July 2006 12:22 pm
To: pgsql-admin@postgresql.org
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!
В списке pgsql-admin по дате отправления: