pg_upgrade and ubuntu - Mailing list pgsql-general

From Jonathan Vanasco
Subject pg_upgrade and ubuntu
Date
Msg-id 60BB2C7C-6399-411C-AC7B-3F994215318D@2xlp.com
Whole thread Raw
Responses Re: pg_upgrade and ubuntu
Re: pg_upgrade and ubuntu
Re: pg_upgrade and ubuntu
List pgsql-general
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.




pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Two instances of Postgres with single data directory
Next
From: David G Johnston
Date:
Subject: Re: pg_upgrade and ubuntu