Re: Testing 9.0beta3 and pg_upgrade

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Testing 9.0beta3 and pg_upgrade
Date: 2010-07-13 06:40:31
Message-ID: i1h1os$qaj$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Regards
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-07-13 07:05:43 Re: Redundant database objects.
Previous Message Joe Conway 2010-07-13 06:35:36 Re: Redundant database objects.