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

From Kevin Grittner
Subject Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Date
Msg-id 4C07A34B0200002500031E87@gw.wicourts.gov
Whole thread Raw
In response to Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading  (Hartmut Goebel <h.goebel@goebel-consult.de>)
Responses Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hartmut Goebel <h.goebel@goebel-consult.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5443: Undetected deadlock situation
Next
From: Claudio Freire
Date:
Subject: Re: BUG #5443: Undetected deadlock situation