Re: PostgreSQL DB Replication

Hi Rajesh,

I don't know what error you are getting. Though you can use below
workaround to login and change the password.

Step 1: Open pg_hba.conf file and modify md5 to trust

Step 2: reload the cluster (/opt/PostgreSQL/9.2/bin/pg_ctl -D ../data/
reload)

Step 3: Connect to the database, it should not ask for password:

bash-4.1$ ./psql -p 5435 postgres
psql.bin (9.2.7)
Type "help" for help.

postgres=# \password postgres;
Enter new password:
Enter it again:
postgres=# \q
bash-4.1$ ./psql -p 5435 postgres
Password:
psql.bin (9.2.7)
Type "help" for help.

postgres=#

If the above workaround does not work, please share what error you are
getting.

Hope this helps….

Thanks & Regards,
Abdul Sayeed
PostgreSQL DBA
Postgres Professional Certified
EnterpriseDB Corp
Skype: abdul.sayeed24

On Tue, Aug 26, 2014 at 11:29 AM, K P Manoj <kpmanojpg(at)gmail(dot)com> wrote:

> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>