Thread: Upgrading from 8.4 and 9.0 to 9.1
Hi, so I have a master-slave set of database servers that are running postgres 9.0 using streaming replication and I'd like to migrate them to 9.1. My question is, can 9.0 do streaming replication to 9.1? If not, what's the best way to upgrade a production database to 9.1 with no downtime? I also have a number of 8.4 servers that I'd like to upgrade to 9.1, can 8.4 ship WAL files to 9.1? Thanks, Scott
On Mon, 2012-05-07 at 15:10 -0400, Scott Briggs wrote: > Hi, so I have a master-slave set of database servers that are running > postgres 9.0 using streaming replication and I'd like to migrate them > to 9.1. My question is, can 9.0 do streaming replication to 9.1? No. > If > not, what's the best way to upgrade a production database to 9.1 with > no downtime? > No downtime? you'll obviously have downtime to get the new binaries. Anyway, you should try pg_upgrade to have less downtime. > I also have a number of 8.4 servers that I'd like to upgrade to 9.1, > can 8.4 ship WAL files to 9.1? > Nope. Streaming replication doesn't work between major versions. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On Mon, May 7, 2012 at 3:28 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote: > On Mon, 2012-05-07 at 15:10 -0400, Scott Briggs wrote: >> Hi, so I have a master-slave set of database servers that are running >> postgres 9.0 using streaming replication and I'd like to migrate them >> to 9.1. My question is, can 9.0 do streaming replication to 9.1? > > No. > >> If >> not, what's the best way to upgrade a production database to 9.1 with >> no downtime? >> > > No downtime? you'll obviously have downtime to get the new binaries. > Anyway, you should try pg_upgrade to have less downtime. Let me clarify, no downtime meaning I will be failing over from the current server running 9.0 to a new server running 9.1. > >> I also have a number of 8.4 servers that I'd like to upgrade to 9.1, >> can 8.4 ship WAL files to 9.1? >> > > Nope. Streaming replication doesn't work between major versions. Since 8.4 doesn't do streaming replication, I'm asking about shipping WAL files via the archive command using rsync. This is our current replication setup for most of our older postgres servers. > > > -- > Guillaume > http://blog.guillaume.lelarge.info > http://www.dalibo.com > Thanks, Scott
On 07/05/2012 20:37, Scott Briggs wrote: > > Let me clarify, no downtime meaning I will be failing over from the > current server running 9.0 to a new server running 9.1. This is one of the scenarios that Slony-I is designed to handle; it may be worth a look. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
On Mon, 2012-05-07 at 15:37 -0400, Scott Briggs wrote: > On Mon, May 7, 2012 at 3:28 PM, Guillaume Lelarge > <guillaume@lelarge.info> wrote: > > On Mon, 2012-05-07 at 15:10 -0400, Scott Briggs wrote: > >> Hi, so I have a master-slave set of database servers that are running > >> postgres 9.0 using streaming replication and I'd like to migrate them > >> to 9.1. My question is, can 9.0 do streaming replication to 9.1? > > > > No. > > > >> If > >> not, what's the best way to upgrade a production database to 9.1 with > >> no downtime? > >> > > > > No downtime? you'll obviously have downtime to get the new binaries. > > Anyway, you should try pg_upgrade to have less downtime. > > Let me clarify, no downtime meaning I will be failing over from the > current server running 9.0 to a new server running 9.1. pg_upgrade or Slony as Raymond already told you. pg_upgrade is newer but easier, Slony is older, probably with less bugs, but hardier. Your choice :) > >> I also have a number of 8.4 servers that I'd like to upgrade to 9.1, > >> can 8.4 ship WAL files to 9.1? > >> > > > > Nope. Streaming replication doesn't work between major versions. > > Since 8.4 doesn't do streaming replication, Sure. > I'm asking about shipping > WAL files via the archive command using rsync. This is our current > replication setup for most of our older postgres servers. Let me rephrase it... log shipping and streaming replication don't work between major versions. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com