PostgreSQL DB Replication
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
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@yahoo.in> wrote:
Show quoted text
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
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@wdicc.com> wrote:
Show quoted text
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@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
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@gmail.com>
wrote:
Show quoted text
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 fileWith Regards,
Sivananda Reddy
07385114008On Tue, Aug 26, 2014 at 9:34 AM, wd <wd@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 <rajeshk02@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
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@gmail.com> wrote:
Show quoted text
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
8050972028On Tue, Aug 26, 2014 at 10:15 AM, sivananda reddy <nanda.opdba@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 fileWith Regards,
Sivananda Reddy
07385114008On Tue, Aug 26, 2014 at 9:34 AM, wd <wd@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 <rajeshk02@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