Thanks Tom,
Dumped in Ubuntu 22.04_1 and restore attempted using Ubuntu 22.04.3
Editing the dump file to C.UTF8 didn't solve the problem.
The default for the database was en_AU.utf8 so I should have changed the
collation to that, but it was one field in one table of superseded data, so I
just e
Tony Bazeley writes:
> I've a problem with restoring a cluster created with pg_dump_all from 14.8
> ( pg_dumpall >pgall.out and then psql -f pgall.out postgres).
> ...
> Attempting to restore to postgresql-16 results in errors
> 2024-04-05 22:17:15.418 ACDT [6565] postgres@tonbaz ERROR: collatio
I've a problem with restoring a cluster created with pg_dump_all from 14.8
( pg_dumpall >pgall.out and then psql -f pgall.out postgres).
pgall.out was recovered after a hardware failure on the hosting machine.
Attempting to restore to postgresql-16 results in errors
.
.
.
psql:/tmp/pgall.out:51
