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
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 |