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

Re: Restore postgres database problem

From: Luis Sousa <llsousa(at)ualg(dot)pt>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restore postgres database problem
Date: 2005-01-26 13:12:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Which options did you use to dump data?
And which options did you use to restore it?
Please submit the command lines used.

Luis Sousa

Inpreet Singh wrote:

> 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 a*n*d Regards
> *Inpreet Singh*

In response to

pgsql-admin by date

Next:From: Marty ScholesDate: 2005-01-26 15:16:31
Subject: 7.4.6 pg_dump failed
Previous:From: Dawid KuroczkoDate: 2005-01-26 09:36:00
Subject: Re: [Fwd: how to determine storage size of a numeric column]

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