John R Pierce wrote:
> I don't use Ubuntu, but the data directories shouldn't be in /etc, thats=
=20
> where the powergresql.conf files are located in their wrappered=20
> systems. The data directories should be in /var/something.
Yes, the data directory is presumably /var/lib/postgresql/8.4/main,
or the pg_lsclusters command can be used to clear up any doubt.
Besides, the pg_upgrade process is wrapped too, so what's
recommended is not to use pg_upgrade directly from
/usr/lib/postgresql/X.Y/... (just like any other command from
these directories), but rather invoke:
# pg_upgradecluster -v 9.5 8.4 main
which would let the wrapper deal with data directories and other
options by itself.
See=20
http://manpages.ubuntu.com/manpages/trusty/man8/pg_upgradecluster.8.html
If a main/9.5 cluster already exists beforehand, it should be
dropped first with
# pg_dropcluster --stop 9.5 main
Best regards,
--=20
Daniel V=E9rit=E9
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite