From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Markus <t.markus@proventis.net>
Cc: pgsql-admin@postgresql.org, Selva manickaraja <mavles78@gmail.com>
Subject: Re: Creating Multiple Instance
Date: Tue, 13 Dec 2011 10:32:14 -0500
Message-ID: <27890.1323790334@sss.pgh.pa.us> (raw)
In-Reply-To: <4EE73AB1.1050904@proventis.net>
References: <CABqgbwc8zTUFDQBd6ouKW1Anma79Z5aSXVWrtB5zW5M3RkPu_A@mail.gmail.com>
<4EE73AB1.1050904@proventis.net>
Thomas Markus <t.markus@proventis.net> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, t.markus@proventis.net, mavles78@gmail.com
Subject: Re: Creating Multiple Instance
In-Reply-To: <27890.1323790334@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox