Re: [GENERAL] PostgreSQL DB Replication

2014-08-26 Thread Abdul Sayeed
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 shou

Re: [GENERAL] PostgreSQL DB Replication

2014-08-25 Thread K P Manoj
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 wrote: > Hi Rajesh > > Please share the below information: > > 1)postgresql.conf file (Bot

Re: [GENERAL] PostgreSQL DB Replication

2014-08-25 Thread sivananda reddy
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 wrote: > What's the output when you try to login? Have yo

Re: [GENERAL] PostgreSQL DB Replication

2014-08-25 Thread wd
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 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 h