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: | 41F79758.2030802@ualg.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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*
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Marty Scholes | 2005-01-26 15:16:31 | 7.4.6 pg_dump failed |
Previous Message | Dawid Kuroczko | 2005-01-26 09:36:00 | Re: [Fwd: how to determine storage size of a numeric column] |