Re: pg_upgrade error

On Thu, May  9, 2013 at 06:16:31PM +0530, Ramesh naik wrote:
> hello there,
>
> we are getting struck with this error while upgrading while upgrading from 9.1
> to 9.2
>
>
> -bash-4.1$ clear
> -bash-4.1$ /usr/pgsql-9.2/bin/pg_upgrade -c  --old-datadir=/var/lib/pgsql/9.1/
> data --new-datadir=/var/lib/pgsql/9.2/data --old-bindir=/usr/pgsql-9.1/bin
> --new-bindir=/usr/pgsql-9.2/bin
> Performing Consistency Checks
> -----------------------------
> Checking current, bin, and data directories                 ok
> Checking cluster versions                                   ok
> Checking database user is a superuser                       ok
> Checking for prepared transactions                          ok
> Checking for reg* system OID user data types                ok
> Checking for contrib/isn with bigint-passing mismatch       ok
> Checking for presence of required libraries                 ok
> Checking database user is a superuser                       ok
>
> Only the install user can be defined in the new cluster.
> Failure, exiting
>
>
> Can anyone help me in this regard..

You must only have the install user defined in the new cluster.  Either
they are not defiend, or a second user is also defined.  If you execute
'SELECT * from pg_authid' in the new cluster, I think you will see the
problem.  Our C comments say:

     *  We only allow the install user in the new cluster because other
     *  defined users might match users defined in the old cluster and
     *  generate an error during pg_dump restore.

Let me know what you find in case I can improve the error message.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +