pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PQendcopy: resetting connection error
2+ messages / 2 participants
[nested] [flat]

* PQendcopy: resetting connection error
@ 2000-11-23 14:31  sathya priya <mscsathya@yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: sathya priya @ 2000-11-23 14:31 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org

hai,

 I encountered the following error While I was trying
to pg_dump the database using the command

  pg_dump -z dbname > bkfilename


PQendcopy: resetting connection
SQL query to dump the contents of Table 'sarehits' did
not execute correctly.  A
fter we read all the table contents from the backend,
PQendcopy() failed.  Expla
nation from backend: ''.
The query was: 'COPY "sarehits" TO stdout;
'.



any help to solve the above said problem.


with regds
p. ashok kumar


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [INTERFACES] PQendcopy: resetting connection error
@ 2000-11-23 17:26  Tom Lane <tgl@sss.pgh.pa.us>
  parent: sathya priya <mscsathya@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2000-11-23 17:26 UTC (permalink / raw)
  To: sathya priya <mscsathya@yahoo.com>; +Cc: pgsql-admin@postgresql.org

sathya priya <mscsathya@yahoo.com> writes:
>   pg_dump -z dbname > bkfilename

> PQendcopy: resetting connection

It's difficult to tell from this what made the COPY command fail.
There might be more info in the postmaster's logfile, though.
(If you're not running the postmaster with a logfile, restart it
with one --- no -S switch, send stdout and stderr to a file ---
and do the dump again.)

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-11-23 17:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-23 14:31 PQendcopy: resetting connection error sathya priya <mscsathya@yahoo.com>
2000-11-23 17:26 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox