Re: PostgreSQL replication lag - Suggestions and questions

> My current architecture is: master (AZ1) --> read slave (AZ2) --> hot-standby (AZ2) - They are all using streaming replication. I am not sure of the difference between read replica and a hot standby. At least with later versions hot standby allows read queries. I mean unless you do not want quer

PostgreSQL replication lag - Suggestions and questions

Hi, I have a cluster of PostgreSQL 9.2.21, where there is one master and one slave with streaming replication. I have few points and questions about the replication, and was hopping you guys could share your opinions, suggestions and experiences. > Before I start; Yes! I know... PG 9.2? Really?

Re: PostgreSQL Replication

On 2021-02-17 12:22:50 +0300, Mutuku Ndeti wrote: > I agree with you. Single master, with a standby replica, seems easier to > manage. Is there a way to automatically promote the standby, when the active > master fails? Yes. There are several solutions. We use Patroni, which is simple to set up an

Re: PostgreSQL Replication

On 2021-02-17 04:22, Mutuku Ndeti wrote: > Thank you.  > > I agree with you. Single master, with a standby replica, seems easier to > manage. Is there a way to automatically promote the standby, when the > active master fails? Is it feasible to have 2 instances of the > application, writing onto t

Re: PostgreSQL Replication

Thank you. I agree with you. Single master, with a standby replica, seems easier to manage. Is there a way to automatically promote the standby, when the active master fails? Is it feasible to have 2 instances of the application, writing onto the same DB, reason for two instances of the applicatio

Re: PostgreSQL Replication

On 2021-02-16 09:28, Raul Giucich wrote: > This article will help you > https://wiki.postgresql.org/wiki/Multimaster > .  > > El mar., 16 feb. 2021 10:56, Mutuku Ndeti > escribió: > > Hi, > > Need some advice here.

Re: PostgreSQL Replication

Thanks. Is there a free version of BDR? On Tue, Feb 16, 2021, 5:29 PM Raul Giucich wrote: > This article will help you > https://wiki.postgresql.org/wiki/Multimaster. > > El mar., 16 feb. 2021 10:56, Mutuku Ndeti escribió: > >> Hi, >> >> Need some advice here. I have an application using Postgr

Re: PostgreSQL Replication

This article will help you https://wiki.postgresql.org/wiki/Multimaster. El mar., 16 feb. 2021 10:56, Mutuku Ndeti escribió: > Hi, > > Need some advice here. I have an application using PostgreSQL. I need to > install it on 2 servers for redundancy purposes and have 2 databases. I > need the DBs

PostgreSQL Replication

Hi, Need some advice here. I have an application using PostgreSQL. I need to install it on 2 servers for redundancy purposes and have 2 databases. I need the DBs to replicate to each other, in real-time. Writes can be done on both DBs. Please let me know if this is a feasible setup and the best w

Re: PostGreSQL Replication and question on maintenance

Thanks Jeff for your reply. We are not using replication concept here but doing the data copy using few custom sql scripts. We had our PostgreSQL engine supported by AWS and the instance was restarted automatically based on the AWS design of PostgreSQL engine. Replica is restarted automatically wh

Re: PostGreSQL Replication and question on maintenance

Hi st 20. 11. 2019 v 13:12 odesílatel Soto Cuevas Manuel Alejandro < mcs...@entel.cl> napsal: > Taking advantage of the instance, what software do you recommend to do > reverse engineering of postgresql? > please, open new thread. Your query is not related to subject. https://wiki.postgresql.or

Re: PostGreSQL Replication and question on maintenance

Taking advantage of the instance, what software do you recommend to do reverse engineering of postgresql? Thank you Manuel El 16-11-2019, a la(s) 10:36, github kran escribió:  ANEXO ENTEL Este es un correo externo: Verifique remitente, No haga clic en vínculos. Si recibes un correo malicios

Re: PostGreSQL Replication and question on maintenance

On Thu, Nov 14, 2019 at 12:23 PM github kran wrote: > >> >> *Problem what we have right now. * >> >> When the migration activity runs(weekly) from past 2 times , we saw the >> cluster read replica instance has restarted as it fallen behind the >> master(writer instance). >> > I can't figure out w

Re: PostGreSQL Replication and question on maintenance

Any reply on this please ?. On Fri, Nov 15, 2019 at 9:10 AM github kran wrote: > > > On Thu, Nov 14, 2019 at 11:42 PM Pavel Stehule > wrote: > >> these numbers looks crazy high - how much memory has your server - more >> than 1TB? >> > > The cluster got 244 GB of RAM and storage capacity it h

Re: PostGreSQL Replication and question on maintenance

On Thu, Nov 14, 2019 at 11:42 PM Pavel Stehule wrote: > these numbers looks crazy high - how much memory has your server - more > than 1TB? > The cluster got 244 GB of RAM and storage capacity it has is 64 TB. > > > pá 15. 11. 2019 v 6:26 odesílatel github kran > napsal: > >> >> Hello postGr

Re: PostGreSQL Replication and question on maintenance

pá 15. 11. 2019 v 6:26 odesílatel github kran napsal: > > Hello postGreSQL Community , >> >> >> >> Hope everyone is doing great !!. >> >> >> *Background* >> >> We use PostgreSQL Version 10.6 version and heavily use PostgreSQL for our >> day to day activities to write and read data. We have 2 clus

Fwd: PostGreSQL Replication and question on maintenance

> Hello postGreSQL Community , > > > > Hope everyone is doing great !!. > > > *Background* > > We use PostgreSQL Version 10.6 version and heavily use PostgreSQL for our > day to day activities to write and read data. We have 2 clusters running > PostgreSQL engine , one cluster > > keeps data up to

PostGreSQL Replication and question on maintenance

sorry changing the subject line. On Thu, Nov 14, 2019 at 11:21 AM github kran wrote: > Hello Team, > > > > Hope everyone is doing great !!. > > > *Background* > > We use PostgreSQL Version 10.6 version and heavily use PostgreSQL for our > day to day activities to write and read data. We have 2 c

Re: Issue with PostgreSQL replication and PITR

Amee Sankhesara - Quipment India wrote: > We have setup replication and PITR on this PostgreSQL server and wal files > for replication and PITR we are storing on the another server which is > shared with primary and secondary server. > > For doing some OS migration activity for the PostgreSQL dat

Issue with PostgreSQL replication and PITR

[Quipment Logo] Hello, We have a windows(2016) setup for PostgreSQL(Version 9.6.5). We have setup replication and PITR on this PostgreSQL server and wal files for replication and PITR we are storing on the another server which is shared with primary and secondary server. For doing some OS mig