Postgres Pro
Downloads
Home   >   mailing lists

Postgres UPGRADE from 9.2 to 9.4 - Mailing list pgsql-general

From Patrick B
Subject Postgres UPGRADE from 9.2 to 9.4
Date
Msg-id CAJNY3isQgMmyez6s9N8g5Cwau_O-93hOrK5TwOBPYD4+8JSG1A@mail.gmail.com
Whole thread Raw
Responses Re: Postgres UPGRADE from 9.2 to 9.4  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view
Hi guys,

I'll be migrating my Postgres 9.2 database from Rackspace to Amazon.

To do that work, I'll be using DMS at amazon... unfortunately DMS needs a Postgres 9.4+ version at least (http://docs.aws.amazon.com/pt_br/dms/latest/userguide/CHAP_Introduction.Sources.html) - So that means that I'll have to upgrade my postgres version.

Questions:

1 - I'll have to upgrade the version on my Master server, right? I can't upgrade only in a streaming replication slave server, right?

2 - I've never done a Postgres upgrade before, can you give some guide here? Is usually a easy thing? How long can it take? Is a downtime needed?

Thanks guys,
Patrick

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Privileges on public schema can't be revoked?
Next
From: Rich Shepard
Date:
Subject: Re: Postgres UPGRADE from 9.2 to 9.4