- publishing free software manuals
The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 274 pages
ISBN 9781906966072
RRP £9.95 ($14.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

10.4.2 Other data migration methods

The ‘contrib’ program pg_upgrade (pg_upgrade) allows an installation to be migrated in-place from one major PostgreSQL version to the next. Keep in mind that this method does not provide any scope for running old and new versions concurrently. Also, pg_upgrade is much less battle-tested than pg_dump, so having an up-to-date backup is strongly recommended in case something goes wrong.

It is also possible to use certain replication methods, such as Slony, to create a standby server with the updated version of PostgreSQL. The standby can be on the same computer or a different computer. Once it has synced up with the master server (running the older version of PostgreSQL), you can switch masters and make the standby the master and shut down the older database instance. Such a switch-over results in only several seconds of downtime for an upgrade.

ISBN 9781906966072The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration GuideSee the print edition