pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Diferent Instances
2+ messages / 2 participants
[nested] [flat]

* Diferent Instances
@ 2004-02-10 12:13 Rodrigo Sakai <rodrigo@2bfree.com.br>
  2004-02-10 13:19 ` Re: Diferent Instances Bruno Wolff III <bruno@wolff.to>
  0 siblings, 1 reply; 2+ messages in thread

From: Rodrigo Sakai @ 2004-02-10 12:13 UTC (permalink / raw)
  To: 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@2bfree.com.br
http://www.2bfree.com.br
Tel:  (55) (11) 5083-5577
Fax: (55) (11) 5549-3598
=====================




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Diferent Instances
  2004-02-10 12:13 Diferent Instances Rodrigo Sakai <rodrigo@2bfree.com.br>
@ 2004-02-10 13:19 ` Bruno Wolff III <bruno@wolff.to>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruno Wolff III @ 2004-02-10 13:19 UTC (permalink / raw)
  To: Rodrigo Sakai <rodrigo@2bfree.com.br>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-02-10 13:19 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-10 12:13 Diferent Instances Rodrigo Sakai <rodrigo@2bfree.com.br>
2004-02-10 13:19 ` Bruno Wolff III <bruno@wolff.to>

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