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

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Hartmut Goebel <h(dot)goebel(at)goebel-consult(dot)de>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, 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-04 00:04:38
Message-ID: 4c084318.0134e70a.5456.2970@mx.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Jun 03, 2010 at 06:04:16PM +0200, Hartmut Goebel wrote:
> 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.

pg_dump will complain if its version doesn't match the server version, but
that's neither a bug nor, in this case, a bad thing. You have pg_dump's -i
option which will squelch this message and allow pg_dump to continue.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2010-06-04 03:03:02 Re: Support on Postgres Database Corruption
Previous Message Mark Kirkwood 2010-06-03 23:16:48 Re: Bad optimizer data for xml (WAS: xml data type implications of no =)