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 postmas...@wolvcoll.ac.uk 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.
