Search Postgresql Archives

Re: PostgreSQL DB Replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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.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









[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux