Error while using pg_dump

On Tue, 16 Apr 2019 at 20:43, Raghavendra Rao J S V
<raghavendrajsv@gmail.com> wrote:

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;

This looks very much like the backend crashed as a result of the COPY.
Can you share which version of PostreSQL you're getting this with? If
not the latest minor version for the release, does it still happen on
the latest?

It would also be good if you could see if you could recreate the crash
with using:

COPY (SELECT * FROM public.aclappliedtopep) TO stdout;

then if you can, try to narrow down if it's crashing because of some
record by either adding a WHERE clause to the SELECT, or perhaps a
LIMIT. If for example, you can get it to crash with LIMIT 1, can you
send us the psql output of \d public.aclappliedtopep and also some
anonymised version of the row it crashes on? (ensuring it still
crashes once anonymised). You may be able to narrow it down by "binary
searching" through various LIMIT / OFFSET combinations.

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

David Rowley <david.rowley@2ndquadrant.com> writes:

On Tue, 16 Apr 2019 at 20:43, Raghavendra Rao J S V
<raghavendrajsv@gmail.com> wrote:

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: FATAL: terminating connection due to administrator command

This looks very much like the backend crashed as a result of the COPY.

That's not a message you'd get from a crash. I'd counsel looking into
the server log for more information about why the postmaster is forcing
session termination.

But yeah, it would be good to know what PG version this is.

regards, tom lane

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@aklaver.com