pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Create replication read only
2+ messages / 2 participants
[nested] [flat]

* Create replication read only
@ 2023-03-01 18:27  Erik Serrano <eserranos@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Erik Serrano @ 2023-03-01 18:27 UTC (permalink / raw)
  To: pgsql-admin

Dear,

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Create replication read only
@ 2023-03-01 22:00  Ron <ronljohnsonjr@gmail.com>
  parent: Erik Serrano <eserranos@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Ron @ 2023-03-01 22:00 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2023-03-01 22:00 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-03-01 18:27 Create replication read only Erik Serrano <eserranos@gmail.com>
2023-03-01 22:00 ` Ron <ronljohnsonjr@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox