We have tried the following steps for PostgreSQL streaming replication (attached mail) and ran into issues. Can anyone
indicatewhat is wrong with the configuration?
Thanks,
Sekhar
-----Original Message-----
From: Venkatesan, Sekhar
Sent: Monday, February 29, 2016 9:28 AM
To: 'Adrian Klaver'; 'David G. Johnston'; 'Mike Sofen'
Cc: 'Tom Lane'; 'pgsql-sql@postgresql.org'; Mallela, Anil; 'pgsql-odbc@postgresql.org'
Subject: RE: Need documentation for PostgreSQL Replication support.
Hi Folks,
Any help regarding the below topic? I want to certify PostgreSQL replication functionality with my application and I
needassistance on this?
Thanks,
Sekhar
-----Original Message-----
From: Venkatesan, Sekhar
Sent: Wednesday, February 10, 2016 12:07 PM
To: 'Adrian Klaver'; 'David G. Johnston'; 'Mike Sofen'
Cc: 'Tom Lane'; 'pgsql-sql@postgresql.org'; Mallela, Anil
Subject: Need documentation for PostgreSQL Replication support.
Hi Folks,
I need official documentation/links where I find information on PostgreSQL Replication support. Can someone shed some
lighton this?
Thanks,
Sekhar
Hi Raghavendra/sekhar,
I have tried base postgres streaming replication with Content server. Database/tables/schema are
replicatedfrom master to slave properly but I am facing odbc connectivity issue from master to slave. Due to that I am
unableto stop master postgres service and test the CS functionality when master is down.
I have added below entries in pg_hbf.conf of master vm
host all all 10.31.159.199/32 md5(master)
host all all 10.31.159.204/32 md5(slave)
and also recreated postmaster.pid file Even then I have seen below issue during odbc connectivity from master to
slave:
psql: FATAL: no pg_hba.conf entry for host "10.31.159.199", user "postgres", database "postgres", SSL off
Can you please suggest me is there any other approach I can follow to resolve above issue.
please find the attached replication configuration steps with environment details.
Note : Not seeing issue with slave vm for odbce connectivity of master
Thanks,
Anil.
