Re: Restore postgres database problem

On Tue, Jan 25, 2005 at 10:26:25AM +0530, Inpreet Singh wrote:
>
> I am using postgres 7.3.4. I am trying to restore database dump using
> psql command but getting following error.
>
> Taken Dump :   /usr/bin/pg_dumpall > /home/inpreet/postgres.sql
> Restoring Dump :   su - postgres
> /usr/local/pgsql/bin/psql -d template1 < /home/inpreet/postgres.sql

I see that pg_dumpall and psql are in different directories.  Are
they from different versions of PostgreSQL?  Are they connecting
to backends running different versions?  Which commands and which
backends are running which versions?

> but getting error
> ERROR:  copy: line 32, Bad date external representation '\N
> lost synchronization with server, resetting connection

What do the offending line and the line or two preceding it look
like?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/