Re: Is it possible to start two instances of postgresql?

[kah_hang_ang(at)toray(dot)com(dot)my]

so what is the best way to implement two databases in one machine?
implement with two postgresql instances with separate directory or
implement under one instance?

if I implement two database in one instance, if one of the database crash
will it affect the other?



                                                                                                                                                 
                      "A. Kretschmer"                                                                                                            
                      <andreas(dot)kretschmer(at)schollg        To:       pgsql-performance(at)postgresql(dot)org                                              
                      las.com>                           cc:                                                                                     
                      Sent by:                           Subject:  Re: [PERFORM]Is it possible to start two instances of postgresql?             
                      pgsql-performance-owner(at)pos                                                                                                
                      tgresql.org                                                                                                                
                                                                                                                                                 
                                                                                                                                                 
                      06/15/2006 02:07 PM                                                                                                        
                                                                                                                                                 
                                                                                                                                                 




am  15.06.2006, um 13:58:20 +0800 mailte kah_hang_ang(at)toray(dot)com(dot)my
folgendes:
>
>
>
>
> Hi,
>
> Is it possible to start two instances of postgresql with different port
and
> directory which run simultaneously?

Yes, this is possible, and this is the Debian way for updates.


> If can then will this cause any problem or performance drop down?

Of course, if you have high load in one database ... you have only one
machine.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
       message can get through to the mailing list cleanly