On 23 nov, 13:20, plk.zu...@xxxxxxxxx (Filip Rembiałkowski) wrote: > 2009/11/23 AnthonyV <avequ...@xxxxxxxxx>: > > > Hello, > > > I have a pg8.3 server (an 8.4 upgrade is scheduled) on Windows. > > I would like an other pg server in backup in case of hardware problem > > on my first server. > > > I use read/write queries and I would like the second pg become master > > without any human intervention. > > ugh. risky (see David's post) > > > > > I saw Slony, but it seems that the backup server is a read-only server > > which is not good for me. > > hmm, half-true. > with slony-I, the slave server is read only as long as the replication > is taking place. > when you detect that your master server is dead, you can issue a > FAILOVER and the slave will be fully operational (R/W). > see http://slony.info/documentation/failover.html > > > I also saw pgpool. Is it a good solution for me? Does it work alone or > > with Slony? Is a Windows version exist? > > Pgpool can work alone (in so-called replication mode), but it has some > important limitations (volatile functions). > Is it good for you? depends on your db usage patterns (what types of > queries are used) > > AFAIK, most real world postgres clustering setups use a combination of > a load balancer (eg pgpool) and replication tool (eg Slony-I) > > > > > Finally, I saw others products like pgcluster or Bucardo, but I don't > > understand the differences between all those products... > > pgcluster is (at best) and early beta. > bucardo is similar to slony but claims to be asynchronous multi master > (not sure how it's possible :-) > > did you seehttp://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connecti... > ? > > did you seehttp://www.postgresql.org/docs/8.4/static/continuous-archiving.html > ? > > cheers, > > -- > Filip Rembiałkowski > JID,mailto:filip.rembialkow...@xxxxxxxxxxxxx://filip.rembialkowski.net/ > > -- > Sent via pgsql-general mailing list (pgsql-gene...@xxxxxxxxxxxxxx) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general Thank you for your advices and your reactivity. I'll try to use Slony-I. Once again thank you. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
