Обсуждение: 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.

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