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

Re: Restore postgres database problem

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Inpreet Singh <Singh(dot)Inpreet(at)netsity(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restore postgres database problem
Date: 2005-01-25 21:38:47
Message-ID: 20050125213847.GA95908@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Jan 25, 2005 at 10:26:25AM +0530, Inpreet Singh wrote:
>
> 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

I see that pg_dumpall and psql are in different directories.  Are
they from different versions of PostgreSQL?  Are they connecting
to backends running different versions?  Which commands and which
backends are running which versions?

> but getting error
> ERROR:  copy: line 32, Bad date external representation '\N
> lost synchronization with server, resetting connection

What do the offending line and the line or two preceding it look
like?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

pgsql-admin by date

Next:From: Michael FuhrDate: 2005-01-26 00:08:43
Subject: Re: Postgres database access problem
Previous:From: Luis SousaDate: 2005-01-25 14:41:02
Subject: SSL connection

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