Re: pg_dumpall - restoration problem- resolved

2024-04-07 Thread Tony Bazeley
just erased the collation from that field. Still no idea on how it came to be there. Cheers Tony On Sunday 7 April 2024 10:35:44 AM ACST Tom Lane wrote: > Tony Bazeley writes: > > I've a problem with restoring a cluster created with pg_dump_all from 14.8 > > ( pg_dumpall

pg_dumpall - restoration problem

2024-04-06 Thread Tony Bazeley
ething specific to postgres16 I installed a copy of the postgres14 (14.11) with failure in exactly the same way. I don't understand the class text COLLATE pg_catalog."C.UTF-8" syntax, but select * from pg_collation shows a C.UTF8 but no C.UTF-8 Any help on how to proceed would be most appreciated TIA Tony Bazeley