From: Bruno Wolff III <bruno@wolff.to>
To: Rodrigo Sakai <rodrigo@2bfree.com.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: Diferent Instances
Date: Tue, 10 Feb 2004 07:19:46 -0600
Message-ID: <20040210131946.GB24722@wolff.to> (raw)
In-Reply-To: <20040210121342.16561.qmail@hm10.locaweb.com.br>
References: <20040210121342.16561.qmail@hm10.locaweb.com.br>
On Tue, Feb 10, 2004 at 10:13:42 -0200,
Rodrigo Sakai <rodrigo@2bfree.com.br> wrote:
>
> We are using PostgreSQL for a lot of distinct databases, and so the problem is, when occurs an error on just one database and we have to restart the postmaster process, it kills all the others databases that do not have problem, because there is only one instance controling the databases. But we are making an ASP, so we should not run into this kind of problem.
> I think abut a solution, if I make initdb for each database, instaling it inside a new folder, like initdb -D /postgresql/datadb1/ ...........
> initdb -D /postgresql/datadb2/ and so on....! Then i think I can initialize each database one by one, and in the same way stop and restart them.
> Is it a good idea or not??? Is there a better way to do what I want ???
What kind of errors are occurring that require restarting postgres to clear?
You probably want to avoid running each database with a separate postmaster.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bruno@wolff.to, rodrigo@2bfree.com.br
Subject: Re: Diferent Instances
In-Reply-To: <20040210131946.GB24722@wolff.to>
References: <20040210121342.16561.qmail@hm10.locaweb.com.br> <20040210131946.GB24722@wolff.to>
* 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