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 <kpmano...@gmail.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.op...@gmail.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 <w...@wdicc.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 <rajesh...@yahoo.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 >>>> >>>> >>>> >>>> >>>> >>> >> >
