I replicated a database, it's working fine but when I enter the replication database it displays the following message:
> The database was created using collation version 2.31, but the operating system provides version 2.35.
>
> Rebuild all objects in this database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
PgPool is also not working with this replication database, it only works when I remove it.
Pgpool gives the following error when trying to login:
child pid 5286: ERROR: unable to read message kind
child pid 5286: DETAIL: kind does not match between main(53) slot (4e)
The same message also appears in the postgresql logs.
How do I rebuild my database?
Asked by Miqueias Kevison
(750 rep)
Mar 11, 2023, 12:49 PM
Last activity: Nov 1, 2024, 04:55 PM
Last activity: Nov 1, 2024, 04:55 PM