Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group