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

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> 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?

In practice, if he has to redo the dump, the easiest fix is really
going to be to rename the column beforehand.  He's likely to end up
doing that anyway rather than quoting its name forever ...

            regards, tom lane