Re: Upgrade from 9.5.4 to 9.6.1

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrade from 9.5.4 to 9.6.1
Date: 2016-11-16 16:17:01
Message-ID: alpine.LNX.2.11.1611160815140.13561@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 15 Nov 2016, Adrian Klaver wrote:

> To add to my previous post. If you do decide to follow the pg_upgrade
> procedure in the README do a pg_dump of the 9.5 data just before you do
> pg_ugrade and store it away in a safe place. The first time through a new
> process does not always end well:)

Adrian, et al.:

Did a pg_dumpall and stored it with my database-backups. Now that I know
where to find the bin/ directories pg_upgrade ran flawlessly. Quick and
easy.

Thanks all,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-11-16 19:05:04 Re: pg_restore --clean failing due to dependancies
Previous Message David G. Johnston 2016-11-16 16:08:58 Re: Change column type from int to bigint - quickest way