Which options did you use to dump data?
And which options did you use to restore it?
Please submit the command lines used.
Luis Sousa
Inpreet Singh wrote:
> Hello,
> 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
>
> but getting error
> ERROR: copy: line 32, Bad date external representation '\N
> lost synchronization with server, resetting connection
>
> Please tell me which way to go.
>
> Thanks a*n*d Regards
> *Inpreet Singh*
>
>