Re: Need documentation for PostgreSQL Replication support.

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.