Search Postgresql Archives

Re: Backup Postgre server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux