| From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Subject: | Re: Replication in main PostgreSQL codebase |
| Date: | 2004-07-17 10:07:11 |
| Message-ID: | 40F8FA4F.2060808@bigfoot.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Bruce Momjian wrote:
> OK, I reworded the replication TODO section and moved it under
> Administration:
>
> * Improve replication solutions
> o Automatic failover
The Automatic failover is already available, we use the RH cluster
solution and it works really well, we never had a failure till now
but all the our simulations ( power off, hardware failure ) are
working well. We have almost 3 year of 24/24 7/7 without macro
interruption, only fews minutes during the 7.0 -> 7.1 -> ... -> 7.4
upgrades. With the RH solution we are also able to perform the
minor upgrades ( 7.4.1 -> 7.4.2 for example ) without one single
minute of interruption:
1) Upgrade on passive node
2) Relocation service
3) Upgrade on the active node
4) Relocation service
it would be great from this point of view if the pg_upgrade could handle
also the major version upgrade without need to dump, init, reload the db.
Regards
Gaetano Mendola
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2004-07-17 10:18:21 | Re: Replication in main PostgreSQL codebase |
| Previous Message | Gaetano Mendola | 2004-07-17 09:39:07 | Re: [HACKERS] Point in Time Recovery |