Search Postgresql Archives

Re: Error while using pg_dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux