Re: Testing 9.0beta3 and pg_upgrade

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Testing 9.0beta3 and pg_upgrade
Date: 2010-07-13 16:21:24
Message-ID: 201007131621.o6DGLOf18431@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thomas Kellerer wrote:
> Craig Ringer, 13.07.2010 05:11:
> > On 13/07/10 05:29, Thomas Kellerer wrote:
> >
> >> I would suggest to either manually change the autocommit mode from
> >> within pg_upgrade or to add a note in the manual to disable/remove this
> >> setting from psqlrc.conf before running pg_upgrade. Personally I think
> >> the first option would be the better one.
> >
> > Should pg_upgrade be reading psqlrc at all? There are bound to be all
> > sorts of exciting issues that psqlrc settings can create.
> >
> I interpret the error message such that pg_upgrade _calls_ (i.e spawns)
> psql to run the CREATE DATABASE command. If that is true, probably the
> easiest solution would be to run psql using the -X switch.

Yes, this is the solution I used.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ None of us is going to be here forever. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Falanga 2010-07-13 16:27:55 Re: Why can't I see the definition of my relations
Previous Message Bruce Momjian 2010-07-13 16:19:57 Re: Testing 9.0beta3 and pg_upgrade