Postgres connection to hot standby

2021-03-31 Thread Mutuku Ndeti
I have a third party application running on postgresql. I have a primary server ans secondary. I have setup the DBon primary to replicate to the secondary.(streaming) as a hot standby. Is it possible to have an instance of the application access the DB on secondary in readonly mode? I have tried

Re: PostgreSQL Replication

2021-02-17 Thread Mutuku Ndeti
er>. > > > > El mar., 16 feb. 2021 10:56, Mutuku Ndeti > <mailto:jnmut...@gmail.com>> escribió: > > > > Hi, > > > > Need some advice here. I have an application using PostgreSQL. I > > need to install it on 2 servers for redundancy

Re: PostgreSQL Replication

2021-02-16 Thread Mutuku Ndeti
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

PostgreSQL Replication

2021-02-16 Thread Mutuku Ndeti
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