Re: PostgreSQL DB Replication

From: K P Manoj <kpmanojpg(at)gmail(dot)com>
To: sivananda reddy <nanda(dot)opdba(at)gmail(dot)com>
Cc: wd <wd(at)wdicc(dot)com>, Rajesh K <rajeshk02(at)yahoo(dot)in>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL DB Replication
Date: 2014-08-26 05:59:31
Message-ID: CAMVgnQ6O4pQMnPVNLWJfm7==C28R=N3mhHQWf6770gJ91SJZ7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)opdba(at)gmail(dot)com>
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(at)wdicc(dot)com> 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(at)yahoo(dot)in> 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
>>>
>>>
>>>
>>>
>>>
>>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2014-08-26 07:59:58 Re: Using fmgr_hook
Previous Message sivananda reddy 2014-08-26 04:45:25 Re: PostgreSQL DB Replication