On 4/16/19 12:07 AM, Raghavendra Rao J S V wrote:
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
I'm trying to figure out the above:
Is this the actual error message or a translated/edited one?
What is the name of the database you are taking the dump from?
Is the *.dump file your output file or is it something being used in the
database?
What is the pg_dump command you are issuing?
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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
