| From: | Christopher Browne <cbbrowne(at)acm(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Ways to speed up dump&reload |
| Date: | 2005-02-21 12:55:27 |
| Message-ID: | 37u41uF5e6768U1@individual.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
You might consider using Slony-I to minimize the downtime.
I haven't done an upgrade using, but know that others have, and I've
done the same using eRServer...
The idea is that you set up an 8.0.1 backend, and set up replication
well ahead of time. Replicate from the 7.4 system to the 8.0 one.
It might take several days to get replication up to date if the
databases are large enough, but once they are relatively in sync, they
should stay there pretty easily.
Switching versions is then as easy as using MOVE SET to switch the
origin from the 7.4 system to the 8.0 one. That ou
--
output = reverse("moc.liamg" "@" "enworbbc")
http://linuxdatabases.info/info/versionupgrade.html
The quickest way to a man's heart is through his chest, with an axe.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Hartmann | 2005-02-21 13:52:22 | Different execution time from psql and JDBC |
| Previous Message | Markus Wollny | 2005-02-21 12:46:33 | Re: Ways to speed up dump&reload |