Postgresql streaming replication - Mailing list pgsql-admin

From Prasanth
Subject Postgresql streaming replication
Date
Msg-id 06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.com
Whole thread Raw
Responses Re: Postgresql streaming replication
Re: Postgresql streaming replication
List pgsql-admin
Hi,

We are running postgresql 16 on debian 12. I tried to create a hot standby on a different server that is running alma linux 9.  After doing the backbackup and starting the server seems like the replication is going fine. When I tried to login to the standby to run some queries got the below message. Postgresql is installed using rpm.

DETAIL:  The database was created using collation version 2.36, but the operating system provides version 2.34.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE database_name REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.


Thanks,
Prasanth

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Toast table infi
Next
From: Matti Linnanvuori
Date:
Subject: Re: Postgresql streaming replication