Postgres Pro
Downloads
Home   >   mailing lists

Restore postgres database problem - Mailing list pgsql-admin

From Inpreet Singh
Subject Restore postgres database problem
Date
Msg-id 006d01c5029a$38fb4e60$3c67a8c0@netsity.com
Whole thread Raw
Responses Re: Restore postgres database problem  (Michael Fuhr <mike@fuhr.org>)
Re: Restore postgres database problem  (Luis Sousa <llsousa@ualg.pt>)
List pgsql-admin
Tree view
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 and Regards
Inpreet Singh
 

pgsql-admin by date:

Previous
From: Luis Sousa
Date:
Subject: SSL connection
Next
From: Inpreet Singh
Date:
Subject: Postgres database access problem