Re: [PERFORM] Per-database warm standby?

2009-08-15 Thread Nickolay
I also have a question about warm standby replication. What'd be the best solution for the system with 2 db servers (nodes), 1 database and 10 seconds max to switch between them (ready to switch time). Currently I'm using Slony, but it's kind of slow when doing subscribe after failover on the

[PERFORM] Per-database warm standby?

2009-08-14 Thread Craig James
8.4 has vastly improved the warm-standby features, but it looks to me like this is still an installation-wide backup, not a per-database backup. That is, if you have (say) a couple hundred databases, and you only want warm-backup on one of them, you can't do it (except using other solutions

Re: [PERFORM] Per-database warm standby?

2009-08-14 Thread Tom Lane
Craig James craig_ja...@emolecules.com writes: 8.4 has vastly improved the warm-standby features, but it looks to me like this is still an installation-wide backup, not a per-database backup. That is, if you have (say) a couple hundred databases, and you only want warm-backup on one of

Re: [PERFORM] Per-database warm standby?

2009-08-14 Thread Alvaro Herrera
Tom Lane wrote: Craig James craig_ja...@emolecules.com writes: 8.4 has vastly improved the warm-standby features, but it looks to me like this is still an installation-wide backup, not a per-database backup. That is, if you have (say) a couple hundred databases, and you only want