Postgres Pro
Downloads
Home   >   mailing lists

Upgrading from 9.1 to 9.2 in place, same machine - Mailing list pgsql-admin

From Wells Oliver
Subject Upgrading from 9.1 to 9.2 in place, same machine
Date
Msg-id CAOC+FBUZL60+OzFXoQZFRL42Zn2DDkyhmmOUx3SKE4Xv1y=eYQ@mail.gmail.com
Whole thread Raw
Responses Re: Upgrading from 9.1 to 9.2 in place, same machine  (Jonathan Nalley <jnalley@jnalley.com>)
Re: Upgrading from 9.1 to 9.2 in place, same machine  (Chris Ernst <cernst@zvelo.com>)
List pgsql-admin
Tree view
I have 9.1 running on 5432, and 9.2 running on 5433. The 9.1 database size is 153g. 9.1 is actively used by systems, 9.2 is just sitting there empty.

I'd like to move the 9.1 database to 9.2 without any down time, and ensuring that no data is lost.

My original idea was to make 9.2 a slave of 9.1, then switch it over.

Is there a better idea? Thanks for any tips.

--
Wells Oliver
wellsoliver@gmail.com

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dump/Reload pg_statistic to cut time from pg_upgrade?
Next
From: Jonathan Nalley
Date:
Subject: Re: Upgrading from 9.1 to 9.2 in place, same machine