Data Dump Issue

Поиск
Список
Период
Сортировка
От Murali Mohan Kasetty
Тема Data Dump Issue
Дата
Msg-id 3D8B1F6A.56D4AA82@india.hp.com
обсуждение исходный текст
Ответы Re: Data Dump Issue  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephane Bortzmeyer
Дата:
Сообщение: Re: boolean
Следующее
От: Holger Klawitter
Дата:
Сообщение: Re: boolean