X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C2D32D1B4BE for ; Tue, 10 Feb 2004 12:14:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 36228-04 for ; Tue, 10 Feb 2004 08:13:54 -0400 (AST) Received: from hm13.locaweb.com.br (hm13.locaweb.com.br [200.246.179.113]) by svr1.postgresql.org (Postfix) with SMTP id 605B8D1C967 for ; Tue, 10 Feb 2004 08:13:49 -0400 (AST) Received: (qmail 24855 invoked from network); 10 Feb 2004 12:13:38 -0000 Received: from hm10.locaweb.com.br (200.246.179.88) by hm13.locaweb.com.br with QMTP; 10 Feb 2004 12:13:38 -0000 Received: (qmail 16589 invoked by uid 41632); 10 Feb 2004 12:13:42 -0000 Message-ID: <20040210121342.16561.qmail@hm10.locaweb.com.br> From: "Rodrigo Sakai" Date: Tue, 10 Feb 2004 10:13:42 -0200 To: pgsql-admin@postgresql.org Subject: Diferent Instances References: In-Reply-To: X-Mailer: LocaMail X-IPAddress: 200.168.66.138 X-Sender: rodrigo@2bfree.com.br MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/127 X-Sequence-Number: 12301 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@2bfree.com.br http://www.2bfree.com.br Tel: (55) (11) 5083-5577 Fax: (55) (11) 5549-3598 =====================