Diferent Instances

From: "Rodrigo Sakai" <rodrigo(at)2bfree(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Diferent Instances
Date: 2004-02-10 12:13:42
Message-ID: 20040210121342.16561.qmail@hm10.locaweb.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

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 ???

=====================
Rodrigo Sakai
Database Administrator
rodrigo(at)2bfree(dot)com(dot)br
http://www.2bfree.com.br
Tel: (55) (11) 5083-5577
Fax: (55) (11) 5549-3598
=====================

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Russell Shaw 2004-02-10 12:31:54 Debian "dump" problem
Previous Message Markus Siebeneicher 2004-02-10 09:24:20 close/kill special user-connection