Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

From: Hartmut Goebel <h(dot)goebel(at)goebel-consult(dot)de>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Date: 2010-06-03 16:04:16
Message-ID: 4C07D280.4080809@goebel-consult.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Am 03.06.2010 16:16, schrieb Kevin Grittner:

>> 8.4 did not allow accessing the 8.3 database
>
> What do you mean? (What did you try and what happened?)

If upgraded the rpm-packages from 8.3 to 8.4. Then postgres failed
starting (something like "Database version mismatch"). So I downgraded
to 8.3, pg_dump'ed there, upgraded and pg_restore'd.

Since 8.4 was not willed to work in the 8.3 database files, I expected
this being a correct upgrade path.

--
Schönen Gruß - Regards
Hartmut Goebel

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gurjeet Singh 2010-06-03 16:43:12 superuser unable to modify settings of a system table
Previous Message Bruce Momjian 2010-06-03 15:25:45 Re: BUG #5364: citext behavior when type not in public schema