CODEWITHSUNDEEP
postgresqlpostgis
aeupinhere
aeupinhere

Reputation: 2983

Migrate Postgresql 8.4 to 9.1

I currently run Postgres 8.4 on Centos 6. I need to migrate to Postgres 9.1 on a Windows machine. I have my reasons for this...Anyway, what is the best way to move the data from one DB to another without interrupting service and losing any of the functionality particularly with PostGIS? The PostGIS version (2.0) that installs with 9.1 has some features that I want to take advantage of but at the same time I don't want to lose any of the features in 8.4. Can anyone provide some insight in to this?

Upvotes: 0

Views: 838

Answers (1)

Dondi Michael Stroma
Dondi Michael Stroma

Reputation: 4800

As far as I know, the only thing that will let you upgrade without downtime is a trigger-based replication system such as Slony-I.

Upvotes: 4

Related Questions