Thread: 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
Venkatesan, Sekhar schrieb am 10.02.2016 um 07:36: > I need official documentation/links where I find information on PostgreSQL Replication support. > Can someone shed some light on this? Do you mean something else than the official manual? http://www.postgresql.org/docs/current/static/high-availability.html
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
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.
Attachment
Venkatesan, Sekhar schrieb am 29.02.2016 um 04:58: > 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? The manual is a good start: http://www.postgresql.org/docs/current/static/high-availability.html
Hello, Sekhar, Did you see the manual here? http://www.postgresql.org/docs/current/static/high-availability.html I'm afraid the trouble has nothing to do with ODBC... If so, pgsql-general@postgresql.org is the right place. Regards Takayuki Tsunakawa > -----Original Message----- > From: pgsql-odbc-owner@postgresql.org > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Venkatesan, Sekhar > Sent: Monday, February 29, 2016 1:01 PM > To: Adrian Klaver; David G. Johnston; Mike Sofen > Cc: Tom Lane; pgsql-sql@postgresql.org; Mallela, Anil; > pgsql-odbc@postgresql.org > Subject: Re: [ODBC] Need documentation for PostgreSQL Replication support. > > We have tried the following steps for PostgreSQL streaming replication > (attached mail) and ran into issues. Can anyone indicate what is wrong with > the configuration? > > Thanks, > Sekhar