From: Bruce Momjian <bruce@momjian.us>
To: Sergey Konoplev <gray.ru@gmail.com>
Cc: Wells Oliver <wellsoliver@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: pg_upgrade (9.1 to 9.2) bombing on casts
Date: Mon, 15 Jul 2013 04:47:02 -0400
Message-ID: <20130715084702.GA1730@momjian.us> (raw)
In-Reply-To: <CAL_0b1v3xp_W_ZRLCCMwF_RKWHd4T10U6Jp84xzqY3yg6-8a6A@mail.gmail.com>
References: <CAOC+FBUPXxkwe+Qyx3e9_02h061L8OHgY4OUUtEFwwvYydbrig@mail.gmail.com>
<CAL_0b1v3xp_W_ZRLCCMwF_RKWHd4T10U6Jp84xzqY3yg6-8a6A@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Sun, Jul 14, 2013 at 10:42:22PM -0700, Sergey Konoplev wrote:
> On Thu, Jul 11, 2013 at 9:55 PM, Wells Oliver <wellsoliver@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 <bruce@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, gray.ru@gmail.com, wellsoliver@gmail.com
Subject: Re: pg_upgrade (9.1 to 9.2) bombing on casts
In-Reply-To: <20130715084702.GA1730@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox