On Tue, Feb 10, 2004 at 10:13:42 -0200, Rodrigo Sakai <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
