Re: pg_upgrade and ubuntu

On 11/14/2014 11:10 AM, 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.

I believe there is:

http://www.postgresql.org/docs/9.3/interactive/pgupgrade.html

Notes

"If you are upgrading a pre-PostgreSQL 9.2 cluster that uses a
configuration-file-only directory, you must pass the real data directory
location to pg_upgrade, and pass the configuration directory location to
the server, e.g. -d /real-data-directory -o '-D /configuration-directory'."

>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com