Re: BUG #13911: pg_upgrade from 8.4 to 9.5 broken

jpaul(at)aconex(dot)com writes:
> I've been attempting to run "pg_upgrade" to move data from Postgresql 8.4.22
> to 9.5

> The command I've been running is:
> /usr/lib/postgresql/9.5/bin/pg_upgrade --old-datadir
> '/etc/postgresql/8.4/main' --new-datadir '/etc/postgresql/9.5/main'
> --old-bindir '/usr/lib/postgresql/8.4/bin' --new-bindir
> '/usr/lib/postgresql/9.5/bin'

> This results in the following error within "pg_upgrade_internal.log"
> Finding the real data directory for the old cluster Could not get
> data directory using "/usr/lib/postgresql/8.4/bin/postgres" -D
> "/etc/postgresql/8.4/main" -C data_directory: No such file or directory

Before 9.2, pg_upgrade never worked at all for setups with config-only
data directories, since it couldn't figure out where the real data
directory was. Now it does work, but only if the old postmaster supports -C.

regards, tom lane