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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Hartmut Goebel" <h(dot)goebel(at)goebel-consult(dot)de>
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 17:42:51
Message-ID: 4C07A34B0200002500031E87@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hartmut Goebel <h(dot)goebel(at)goebel-consult(dot)de> wrote:

> If upgraded the rpm-packages from 8.3 to 8.4. Then postgres failed
> starting (something like "Database version mismatch").

You need to be running the old server using 8.3 software and while
using pg_dump from 8.4 software. Does your packager provide some
way to install the new version at a different location? If not, is
there a separate machine on which you could install 8.4?

-Kevin

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Claudio Freire 2010-06-03 17:58:43 Re: BUG #5443: Undetected deadlock situation
Previous Message Tom Lane 2010-06-03 17:42:11 Re: BUG #5443: Undetected deadlock situation