Upgrading from 9.1 to 9.2 in place, same machine

From: Wells Oliver <wellsoliver(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Upgrading from 9.1 to 9.2 in place, same machine
Date: 2013-07-10 17:53:50
Message-ID: CAOC+FBUZL60+OzFXoQZFRL42Zn2DDkyhmmOUx3SKE4Xv1y=eYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jonathan Nalley 2013-07-10 18:08:04 Re: Upgrading from 9.1 to 9.2 in place, same machine
Previous Message Tom Lane 2013-07-10 16:46:26 Re: Dump/Reload pg_statistic to cut time from pg_upgrade?