Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 3A0F52DF893 for ; Tue, 13 Dec 2011 11:32:32 -0400 (AST) Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RaULF-0005Oi-Ln for pgsql-admin@postgresql.org; Tue, 13 Dec 2011 15:32:31 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id pBDFWERG027891; Tue, 13 Dec 2011 10:32:15 -0500 (EST) To: Thomas Markus cc: pgsql-admin@postgresql.org, Selva manickaraja Subject: Re: Creating Multiple Instance In-reply-to: <4EE73AB1.1050904@proventis.net> References: <4EE73AB1.1050904@proventis.net> Comments: In-reply-to Thomas Markus message dated "Tue, 13 Dec 2011 12:44:49 +0100" Date: Tue, 13 Dec 2011 10:32:14 -0500 Message-ID: <27890.1323790334@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201112/68 X-Sequence-Number: 38826 Thomas Markus writes: > thats possible. Dont forget so set another port in your postgresql.conf I think actually the reason pg_ctl is complaining is that it doesn't know how to read postgresql.conf, so it's unaware that the second server is supposed to be on 5433. (IIRC, this is fixed in 9.1, but not 9.0.) It is starting the postmaster correctly, but the -w switch likely doesn't work as expected. What I'd suggest is setting the nondefault port number both in postgresql.conf and on the server command line --- ie, if you're using pg_ctl, include -o '-p 6433' in its arguments. That tells pg_ctl what's going on, and it has another benefit that you'll soon recognize: you'll be able to tell which postmaster is which in ps listings. The postgresql.conf entry is then redundant, but a good thing to have as a backstop in case you forget the command line switch one day. regards, tom lane