Home > mailing lists

Restore postgres database problem - Mailing list pgsql-novice

From	Inpreet Singh
Subject	Restore postgres database problem
Date	January 25, 2005 20:33:37
Msg-id	004601c50299$cef5bc30$3c67a8c0@netsity.com Whole thread Raw
List	pgsql-novice

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-novice by date:

From: "Mike Disbrow"
Date: 25 January 2005, 20:32:13
Subject: Installing dblink

From: Klaus
Date: 25 January 2005, 20:33:46
Subject: How to update dependent tables AND design considerations