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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
