Hello,
I have one query regarding client/server authentication using certificate
in postgres.
I am able to establish client server connection with OpenSSL certificate
creation.
We can create server and root certificates using OpenSSL and keep them in
data directory.
We need to update field in po
On Mon, Jul 10, 2023 at 3:41 PM Ashok Patil wrote:
> Hello Julien,
>
> I need some more help regarding replication.
>
> Where Primary server can switch to Standby server role and stand by server
> can switch to Primary server role.
> [image: image.png]
> In our case we maintain two servers Server
Hello Julien,
I need some more help regarding replication.
Where Primary server can switch to Standby server role and stand by server
can switch to Primary server role.
[image: image.png]
In our case we maintain two servers Server1 and Server2.. Server1 will be
active and Server2 will be passive.
Hi,
On Mon, Jul 03, 2023 at 02:07:54PM +0530, Ashok Patil wrote:
>
> I am able to perform replication of a single machine where primary and
> stand-by are on same localhost..
> I think you are right.. it might be blocking the backup process by
> firewall..
Agreed
> Just one signal question: is m
Hello Julien,
I am able to perform replication of a single machine where primary and
stand-by are on same localhost..
I think you are right.. it might be blocking the backup process by
firewall..
Just one signal question: is multi-master replication possible on Postgres?
I searched on google.. bu
Hi,
On Fri, Jun 30, 2023 at 01:47:29PM +0530, Ashok Patil wrote:
> Hello MAZIÈRE,
>
> I tried update by
>
> listen_addresses = '*' and listen_addresses = 'server_address' but still
> i am getting same error.
Did you restart postgres after changing listen_addresses, and is the primary
port 5432?
Hello MAZIÈRE,
I tried update by
listen_addresses = '*' and listen_addresses = 'server_address' but still
i am getting same error.
Searched on internet for probable solution but does not get any proper
answer.
Will you please reply me for this issue?
Regards,
Ashok
On Tue, Jun 27, 2023 at
Hello,
You can have a look at the parameter : listen_addresses in the file
postgresql.conf.
By default the value is localhost.
Regards
Romain MAZIÈRE
romain.mazi...@sigmaz-consilium.fr
+33.535.545.085
+33.781.46.36.96
https://sigmaz-consilium.fr
Le 27/06/2023 à 16:04, Ashok Patil a écrit :
Hello Sir/Madam,
I have to perform task of database replication. For that for testing
purpose I have installed Postgress 14 on two different machine. One is
primary (We can say it as server) and another one is secondary (stand by).
Below steps i have performed
*On Primary*
1. Update Postgres.co
