Postgres Pro
Downloads
Home   >   mailing lists

Re: using pg_upgrade on FreeBSD for postgresql installed by ports - Mailing list pgsql-admin

From Luca Ferrari
Subject Re: using pg_upgrade on FreeBSD for postgresql installed by ports
Date
Msg-id CAKoxK+7_ixVPpvzpx5Ajr3-ePnAvcLjNtvti2uq=nUcFG0Vyyw@mail.gmail.com
Whole thread Raw
In response to Re: using pg_upgrade on FreeBSD for postgresql installed by ports  (Alejandro Brust <alejandrobrust@gmail.com>)
List pgsql-admin
Tree view 
On Mon, Nov 11, 2013 at 8:47 PM, Alejandro Brust
<alejandrobrust@gmail.com> wrote:
> Hello
> I recommend you to install the new version in other directory (start the
> cluster on other port.... first) and perform the backup with de "NEW"
> client.
> Restore  the backup(with de "NEW" client), test...and test...and compare.
> Then U could promote the new one version to production.

Thanks, but this sounds like the "usual" pg_dump/pg_restore chain, I
was wondering about pg_upgrade.

Luca

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: using pg_upgrade on FreeBSD for postgresql installed by ports
Next
From: Guillermo Carrasco
Date:
Subject: REVOKE command not working as expected