Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is it possible to upgrade from PostgreSQL 8.3.x to 8.4.x without downtime? We have a warm standby configuration with WAL shipping so we have the option upgrade the standby first, but WAL shipping does not apparently work from a 8.3.x primary to a 8.4.x slave or vice versa. Any suggestions would be appreciated as we have a mission critical app.

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

A dump/restore using pg_dump is required for those wishing to migrate data from any previous release.

http://www.postgresql.org/docs/8.4/static/release-8-4.html

In general, log shipping between servers running different major PostgreSQL release levels will not be possible.

http://www.postgresql.org/docs/8.3/static/warm-standby.html

The only other option I see is http://wiki.postgresql.org/wiki/In-place_upgrade which links to: http://pgfoundry.org/projects/pg-migrator/

Other than that, I imagine you could put the database in read-only mode and perform the upgrade on the standby or another server.

I hope you well-tested this critical app on 8.4 already :)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.