Error while using pg_dump

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Error while using pg_dump
Date: 2019-04-16 07:07:06
Message-ID: CAEHH7R6uwNUpwE1q8yRh1cqX3-rYHU17AAuvu8M3hCC_GDmVYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tim Kane 2019-04-16 09:22:27 Alter domain type / avoiding table rewrite
Previous Message Takahashi, Ryohei 2019-04-16 04:44:54 RE: SQLSTATE when PostgreSQL crashes during COMMIT statement