Payal Singh <paya...@umbc.edu> writes: > On Thu, Jul 5, 2012 at 12:15 PM, Craig Ringer <ring...@ringerc.id.au> wrote: >> If you start 9.1 on a copy of the backup then cleanly stop it again, does >> pg_upgrade then run?
> Thank you. That worked. ISTM that pg_upgrade should check that the old cluster was shut down cleanly, ie pg_control has state = "shut down". AFAICT from some testing, it currently only checks that there is no postmaster.pid file, which is easily bypassed by users who might not realize that it's not safe to run pg_upgrade against a filesystem backup. BTW, I also noticed while trying to test this that pg_upgrade is currently completely broken for the case of taking PGDATAOLD or PGDATANEW from the environment rather than switches. This is because the existing coding in option.c fails to set up the "pgconfig" fields in such cases. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs