[ADMIN] how to upgrade PG

From: "Huang, Suya" <Suya(dot)Huang(at)experian(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: [ADMIN] how to upgrade PG
Date: 2016-04-19 05:19:37
Message-ID: D83E55F5F4D99B4A9B4C4E259E6227CD4586B4EB@AUX1EXC02.apac.experian.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Our PG runs on Ubuntu boxes and it's 9.3.4, thinking of upgrading to 9.3.12 or 9.5.2.

Is the normal approach of upgrade something like below, no matter if it's major version or minor version upgrade? My focus is on pg_dump at the moment.
#1 pg_dump
Dump DB
Apt-get update
Apt-get install new version
Createdb
Import DB

#2 pg_upgrade (a little complicated, worth trying on test environment)

#3 using trigger based replication tool (not interested at this moment)

Thanks,
Suya

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2016-04-19 06:39:19 Re: Re: what's the exact command definition in read committed isolation level?
Previous Message Alvaro Aguayo Garcia-Rada 2016-04-19 04:59:09 Re: BDR replication slots