From: | Murali Mohan Kasetty <kasetty(at)india(dot)hp(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Data Dump Issue |
Date: | 2002-09-20 13:15:22 |
Message-ID: | 3D8B1F6A.56D4AA82@india.hp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm trying to dump the data from one PostgreqSQL 7.1.3 server to
another PostgreqSQL 7.1.3 server.
As per the documentation given, I have used the following commands
for the dump
In first server
----------------------------
pg_dump -o dbname > outfile
Its created outfile without any errors.
In Second server
------------------------------------
(1) ./createdb dbname
(2) ./psql dbname < outfile
When I try to run the command (2) in Second server, I got the following
error
"pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
PQendcopy: resetting connection"
and the error message on Postmaster console is "Socket command type \
unknown"
Any help would be greatly appreciated.
Thanks in advance,
Murali
Attachment | Content-Type | Size |
---|---|---|
kasetty.vcf | text/x-vcard | 334 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Klawitter | 2002-09-20 13:21:15 | Re: boolean |
Previous Message | Stephane Bortzmeyer | 2002-09-20 13:14:36 | Re: boolean |