From: Thomas Markus <t.markus@proventis.net>
To: pgsql-admin@postgresql.org
Subject: Re: Creating Multiple Instance
Date: Tue, 13 Dec 2011 12:44:49 +0100
Message-ID: <4EE73AB1.1050904@proventis.net> (raw)
In-Reply-To: <CABqgbwc8zTUFDQBd6ouKW1Anma79Z5aSXVWrtB5zW5M3RkPu_A@mail.gmail.com>
References: <CABqgbwc8zTUFDQBd6ouKW1Anma79Z5aSXVWrtB5zW5M3RkPu_A@mail.gmail.com>
Hi,
thats possible. Dont forget so set another port in your postgresql.conf
Thomas
Am 13.12.2011 09:23, schrieb Selva manickaraja:
> Hi All,
>
> We are planning to create a 2nd instance of postgres db in the same
> server. The reason is simple. After we added another application, the
> number of WAL(s) created is too much. So we want to separate the db by
> moving it out to another instance of postgres in the same machine. We
> want to study that new application the new db independently to
> understand what could go wrong. Meanwhile we want the operations and
> backups on our existing db running on 5432 port to be going on as usual.
>
> Steps we took:
>
> 1.Create a new cluster "/pgs/903/data_5433"
> 2. Start the db instance using new parameters i.e. - (su - postgres -c
> "/opt/pgs/903/bin/pg_ctl -w start -D \"/pgs/903/data_5433\" -l
> \"/pgs/903/data_5433/pg_log/startup.log\"")
>
> Unfortunately we got the following error.
>
> pg_ctl: another server might be running; trying to start server anyway
> waiting for server to start... done
> server started
>
> First of all, we want to know if at all it is possible to do this in
> PostgreSQL, or whether we missed out any important steps.
>
> Please help.
>
> Thank you.
>
> Regards,
>
> Selvam
>
>
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: t.markus@proventis.net
Subject: Re: Creating Multiple Instance
In-Reply-To: <4EE73AB1.1050904@proventis.net>
* 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