Problem upgrading from Postgresql 9.5

[Adam Norwood <norwooda@xxxxxxxxxxxxxx>]

​Hi Everyone,

First post and I'm a complete beginner when it comes to Postgresql, however I've been tasked with updating a versionn 9.5 install on Ubuntu 20.04 to just about any later version I can get (latest preferably) but have hit a number of roadblocks.

The machine has version 10 and 12 on it and by default, something I'm not sure how to change, postgresql tries to update to V12. However it hits the following errors when trying to update

Upgrading database moodlelive...

pg_dump: error: Dumping the contents of table "mdl_local_intelliboard_details" failed: PQgetResult() failed.

pg_dump: error: Error message from server: ERROR:  could not access status of transaction 2745040900

DETAIL:  Could not open file "pg_clog/0A39": No such file or directory.

pg_dump: error: The command was: COPY "public"."mdl_local_intelliboard_details" ("id", "logid", "visits", "timespend", "timepoint") TO stdout;

pg_restore: error: could not read from input file: end of file

Error during cluster dumping, removing new cluster

This is quite a handful of errors which I'm not sure how to resolve, or why they're happening (missing file I understand the error but not why it's looking for that file or where it has gone) any help would be very, very appreciated. As i said i'm a total beginner so apologies if any of this is particularly basic

all the best 

Adam Norwood

DISCLAIMER: This email and any enclosures are intended solely for the use of the named recipient. If this email and information within must be subject to appropriate safeguards to protect against unauthorised or unlawful processing and against accidental loss or destruction or damage any information should only be further shared where there is a legitimate need. If you are not the intended recipient, or responsible for delivering it to the intended recipient, you may not copy, disclose, distribute or use it without the authorisation of City of Wolverhampton College. If you have received this email in error please notify us by email to postmaster@xxxxxxxxxxxxxx and then delete it and any attachments accompanying it. Please note that City of Wolverhampton College do not guarantee that this message or attachments are virus free or reach you in their original form and accept no liability arising from this. Any views or opinions expressed within this email are those of the writer and may not necessarily reflect those of City of Wolverhampton College. No contractual commitment is intended to arise from this email or attachments.