Re: Error while using pg_dump

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(dot)klaver(at)aklaver(dot)com