Skip site navigation (1) Skip section navigation (2)

Restore postgres database problem

From: Inpreet Singh <Singh(dot)Inpreet(at)netsity(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Restore postgres database problem
Date: 2005-01-25 04:53:27
Message-ID: 004601c50299$cef5bc30$3c67a8c0@netsity.com (view raw or flat)
Thread:
Lists: 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

Next:From: Ramon OrticioDate: 2005-01-25 05:09:12
Subject: programming language for postgresql
Previous:From: Michael FuhrDate: 2005-01-25 04:05:08
Subject: Re: extracting date from timestamp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group