| 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: | Whole Thread | Raw Message | 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] |