Re: HOLD THE PRESSES!! ... pg_dump from v7.0.3 can't import to v7.1?

Joel Burton <jburton@scw.org>

From: Joel Burton <jburton@scw.org>
To: The Hermit Hacker <scrappy@hub.org>
Cc: pgsql-hackers@postgresql.org
Date: 2001-04-10T18:33:37Z
Lists: pgsql-hackers
On Tue, 10 Apr 2001, The Hermit Hacker wrote:

> all I did was use pg_dumpall from v7.0.3 to dump to a text file, and
> "psql template1 < dumpfile" to load it back in again ...
> 
> obviously this doesn't work like it has in the past?

Marc --

Was there an error message during restore?

I've been dumping/restoring w/7.1 since long before beta, w/o real
problems, but haven't been doing this w/7.0.3 stuff. But still, psql
should give you some error messages.

(I'm sure you know this, but for the benefit of others on the list)
In Linux, I usually use the command)

   psql dbname < dumpfile 2>&1 | grep ERROR

so that I don't miss any errors among the all the NOTICEs


-- 
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington