Re: pg_upgrade and ubuntu - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: pg_upgrade and ubuntu
Date
Msg-id 54666CC6.5060701@gmx.net
Whole thread Raw
In response to pg_upgrade and ubuntu  (Jonathan Vanasco <postgres@2xlp.com>)
List pgsql-general
On 11/14/14 2:10 PM, Jonathan Vanasco wrote:
> I ran into an issue migrating from 9.1 to 9.3 on ubuntu using pg_upgrade
>
> the default ubuntu package, and the one from postgresql.org, both store `postgresql.conf` in etc as
`/etc/postgresql/VERSION/main/postgresql.conf`
>
> however, the pg_upgrade script expects it in the `datadir`.
>
> the simple solution seems to be just symlinking the /etc files into the data dirs.
>
> it took me a while to realize this was the error.
>
> it might make sense to upgrade the docs with a note about what should be in the data dir to enable an upgrade.

On Debian/Ubuntu, use pg_upgradecluster --method upgrade.  See the man
page for details.



pgsql-general by date:

Previous
From: David G Johnston
Date:
Subject: Re: pg_upgrade and ubuntu
Next
From: Jim Nasby
Date:
Subject: Re: NEW in after insert trugger contained incorrect data