Re: PostgreSQL DB Replication

[K P Manoj <kpmanojpg@xxxxxxxxx>]

Hi Rajesh,

Parameter  hot_standby is on on slave server ?. You are trying to change postgres password on master or slave ?.

Regards

Manoj K P
8050972028

On Tue, Aug 26, 2014 at 10:15 AM, sivananda reddy <nanda.opdba@xxxxxxxxx> wrote:

Hi Rajesh

Please share the below information:

1)postgresql.conf file (Both master and slave)

2) database server logs 

3)recovery.conf file

4)pg_hba.conf file

With Regards,

Sivananda Reddy 

07385114008

On Tue, Aug 26, 2014 at 9:34 AM, wd <wd@xxxxxxxxx> wrote:

What's the output when you try to login? Have your slave configured as a standby server ?

On Mon, Aug 25, 2014 at 12:46 PM, Rajesh K <rajeshk02@xxxxxxxx> wrote:

Dear Sir,

I have planned to configure  PostgreSQL 9.2.4 database Master and Slave replication on Redhat Linux Server 6.As per the documentation i have done the settings on both Master and Slave.I choose 7 simple step binary replication method as per the PostgreSQL website.After DB Synchronization command I  start the slave and master as per the documentation.After that I am  not able to login as postgres user on slave and not able to change the password of the user postgres.Kindly help me to done the same .

Thanks & Regards
Rajesh.K/Pramod

Developer

Cochin
8129823272