Question: I tried upgrading my postgres database and getting the following error: pg _ dump: error: query failed: FATAL: terminating connection due to administrator command server
I tried upgrading my postgres database and getting the following error:
pgdump: error: query failed: FATAL: terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pgdump: error: query was: SELECT ttableoid, toid, trelname AS indexname, AS parentidx, pgcatalog.pggetindexdefiindexrelid AS indexdef, iindnatts AS indnkeyatts, iindnatts AS indnatts, iindkey, iindisclustered, iindisreplident, ccontype, cconname, ccondeferrable, ccondeferred, ctableoid AS contableoid, coid AS conoid, pgcatalog.pggetconstraintdefcoid, false AS condef, SELECT spcname FROM pgcatalog.pgtablespace s WHERE soid treltablespace AS tablespace, treloptions AS indreloptions, AS indstatcols, AS indstatvals FROM pgcatalog.pgindex i JOIN pgcatalog.pgclass t ON toid iindexrelid LEFT JOIN pgcatalog.pgconstraint c ON iindrelid cconrelid AND iindexrelid cconindid AND ccontype IN pux WHERE iindrelid ::pgcatalog.oid AND iindisvalid AND iindisready ORDER BY indexname
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
