X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A1EC79FA350 for ; Tue, 4 Jul 2006 08:21:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 86265-04 for ; Tue, 4 Jul 2006 08:21:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from michael.eatserver.nl (michael.eatserver.nl [212.203.14.103]) by postgresql.org (Postfix) with ESMTP id 758D09FA2F3 for ; Tue, 4 Jul 2006 08:21:52 -0300 (ADT) Received: from dvipc (82-170-251-187.dsl.ip.tiscali.nl [82.170.251.187]) (authenticated bits=0) by michael.eatserver.nl (8.12.10/8.12.10/SuSE Linux 0.7) with ESMTP id k64BLpHh032137 for ; Tue, 4 Jul 2006 13:21:51 +0200 From: "H.J. Sanders" To: Subject: FW: 2 instances Date: Tue, 4 Jul 2006 13:21:53 +0200 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000A_01C69F6C.D0F85DA0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Importance: Normal X-Virus-Scanned: by amavisd-new X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/8 X-Sequence-Number: 22254 This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C69F6C.D0F85DA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_000A_01C69F6C.D0F85DA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 

 
Hello.
 
I would like to = run 2=20 instances of postgresql with 2 different data-directories: dir-a en=20 dir-b.
 
Looking trough = the archives I=20 came to the next setup:
 
I created this 2 = different=20 directories and 2 users each with a different PGDATA(dir-a and dir-b) in their=20 .profile
Using this 2 = users i did=20 twice initdb and createdb xyz with the first user.
 
in = postgresql.conf of the=20 second directory I changed  the port to 5433 and also entered = this port=20 in /etc/services and started the second
postmaster, ps -f = shows it is=20 running.
 
If I now want to = create the=20 same database xyz in the second directory using the second=20 user,
the database is = already=20 there!
 
What am I=20 missing?
 
Many=20 thanks
 
Henk=20 Sander
 
 
 

------=_NextPart_000_000A_01C69F6C.D0F85DA0--