| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-01-26 00:08:43 | Re: Postgres database access problem |
| Previous Message | Luis Sousa | 2005-01-25 14:41:02 | SSL connection |