Error while using pg_dump - Mailing list pgsql-general

From Raghavendra Rao J S V
Subject Error while using pg_dump
Date
Msg-id CAEHH7R6uwNUpwE1q8yRh1cqX3-rYHU17AAuvu8M3hCC_GDmVYg@mail.gmail.com
Whole thread Raw
Responses Re: Error while using pg_dump  (David Rowley <david.rowley@2ndquadrant.com>)
Re: Error while using pg_dump  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi All,

We are facing below error while taking the backup of the database using pg_dump. Could you suggest me how to rectify this?


pg_dump: [archiver (db)] query was: COPY public.aclappliedtopep (id, instance_version, direction, aclname, ifname, owningentityid, protocolendpoint_id, deploypending, authentityid, authentityclass, accesscontrollist_id) TO stdout;

dollar qustion is 1

dbuser name is qovr , dbname is qovr and direcotry is /opt/tempbackups/HCS-SYD3-PCA01-weekly-backup/backup/appcomponent/qovr-db/emms_db_09_05_17_18_46_26.dump

dollar qustion is 0

pg_dump: FATAL:  terminating connection due to administrator command

pg_dump: [archiver (db)] query failed: server closed the connection unexpectedly

                This probably means the server terminated abnormally

                before or while processing the request.

pg_dump: [archiver (db)] query was: COPY public.aclappliedtopep (id, instance_version, direction, aclname, ifname, owningentityid, protocolendpoint_id, deploypending, authentityid, authentityclass, accesscontrollist_id) TO stdout;

pg_dump: [archiver (db)] connection to database "qovr" failed: could not connect to server: Connection refused

                Is the server running on host "localhost" (127.0.0.1) and accepting

                TCP/IP connections on port 5433?

pg_dump: error reading large object 69417845: FATAL:  terminating connection due to administrator command

FATAL:  terminating connection due to administrator command

pg_dump: could not open large object 59087743: FATAL:  terminating connection due to administrator command

FATAL:  terminating connection due to administrator command


--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425

pgsql-general by date:

Previous
From: "Takahashi, Ryohei"
Date:
Subject: RE: SQLSTATE when PostgreSQL crashes during COMMIT statement
Next
From: Tim Kane
Date:
Subject: Alter domain type / avoiding table rewrite