Postgres Pro
Downloads
Home   >   mailing lists

Thread: Create replication read only

Create replication read only

From
Erik Serrano
Date:
Dear, 

Have information on how to create a read-only replica ... PDF, video, etc.  I need to create a server to only make queries.  

From already thank you very much.  greetings



Erik Serrano 

Re: Create replication read only

From
Ron
Date:
On 3/1/23 12:27, Erik Serrano wrote:
> Dear,
>
> Have information on how to create a read-only replica ... PDF, video, 
> etc.  I need to create a server to only make queries.

Postgresql doesn't "do" master-master clustering, so it's replication 
methods are all read only.

This is what I used to implement streaming:
https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/


-- 
Born in Arizona, moved to Babylonia.