Re: Restore postgres database problem - Mailing list pgsql-admin

From Luis Sousa
Subject Re: Restore postgres database problem
Date
Msg-id 41F79758.2030802@ualg.pt
Whole thread Raw
In response to Restore postgres database problem  (Inpreet Singh <Singh.Inpreet@netsity.com>)
List 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*
>
>



Attachment

pgsql-admin by date:

Previous
From: Dawid Kuroczko
Date:
Subject: Re: [Fwd: how to determine storage size of a numeric column]
Next
From: Marty Scholes
Date:
Subject: 7.4.6 pg_dump failed