Re: Trouble Upgrading Postgres

Charles Martin wrote:
> When I do a pg_dump using PG 9.6, I got this:
>
> > pg_dump: Dumping the contents of table "docfile" failed: PQgetCopyData() failed.
> > pg_dump: Error message from server: server closed the connection unexpectedly
> > This probably means the server terminated abnormally
> > before or while processing the request.
> > pg_dump: The command was: COPY public.docfile (docfile_pkey, docfileoriginalname,
> > ordernumber, versionnum, docfilecontents, docfilepath, docfileextension, enddatetime,
> > endby, editnum, insby, insdatetime, modby, moddatetime, active, doc_fkey) TO stdout;

You probably have a corrupted database.

You should get that fixed first, then you can upgrade.

Maybe you should hire a professional for that.

The other alternative is that you hava a buggy extension installed
that causes PostgreSQL to crash.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com