On Sun, Jul 14, 2013 at 10:42:22PM -0700, Sergey Konoplev wrote: > On Thu, Jul 11, 2013 at 9:55 PM, Wells Oliver <wellsoli...@gmail.com> wrote: > > Command executed: > > > > time \ > > /usr/lib/postgresql/9.2/bin/pg_upgrade -k \ > > -b /usr/lib/postgresql/9.1/bin \ > > -B /usr/lib/postgresql/9.2/bin \ > > -d /data/postgresql/9.1/test \ > > -D /data/postgresql/9.2/main \ > > -o '-D /etc/postgresql/9.1/test' \ > > -O '-D /etc/postgresql/9.2/main' > > In future I suggest you to use --check (from docs: check clusters > only, don't change any data) when performing pg_upgrade first. I will > show you all the errors but will not affect your cluster. And you can > use safe it on a running instance BTW.
While that is a good suggstion, it would not have found this error becaues --check does not test the restore of the database schemas. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
