Restore postgres database problem

From: Inpreet Singh <Singh(dot)Inpreet(at)netsity(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Restore postgres database problem
Date: 2005-01-25 04:56:25
Message-ID: 006d01c5029a$38fb4e60$3c67a8c0@netsity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Inpreet Singh 2005-01-25 06:16:54 Postgres database access problem
Previous Message Scott Marlowe 2005-01-24 19:33:28 Re: benchmarks with pgbench