Changing postgres user password in a master-slave setup

Posted by NRS on Stack Overflow See other posts from Stack Overflow or by NRS
Published on 2010-05-05T23:13:43Z Indexed on 2010/05/05 23:18 UTC
Read the original article Hit count: 468

Filed under:

password

|

change

|

pitr

|

master-slave

We have PITR setup and WAL shipping enabled. We would like to change the password for the user postgres. The process is simple enough. However, since we cannot connect to the SLAVE how would we make sure all passwords are in synch? Would temporarily disabling WAL shipping allow me to connect to the slave to change the password there? I cant seem to find documentation on a clean way to implement this password change and I don't have a test environment.

© Stack Overflow or respective owner

Related posts about password

remember password is not filling the password field automatically

as seen on Stack Overflow - Search for 'Stack Overflow'
IE is not filling the password field automatically when i click on the bookmarked url. But it's working on firefix,chrome etc. I tried with autocomplete="on" but no use. IE will fill the password only When i select a usename from the possible user names which the browser had kept for each login.… >>> More
Lost shell password: change user password from root

as seen on Super User - Search for 'Super User'
Hi. I recently accidentally forgot my user password to my shell. I know the root password. How do I change the user password? I figure it's something like $su root $passwd -[something] username but I can't get it to work. Halp pls? >>> More
[GEEK SCHOOL] Network Security 1: Securing User Accounts and Passwords in Windows

as seen on How to geek - Search for 'How to geek'
This How-To Geek School class is intended for people who want to learn more about security when using Windows operating systems. You will learn many principles that will help you have a more secure computing experience and will get the chance to use all the important security tools and features that… >>> More
Membership Generate Password alphanumeric only password?

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I use Membership.GeneratePassword to return a password that ONLY contains alpha or numeric characters? The default method will only guarantee a minimum and not a maximum number of non alphanumeric passwords. I have the solution already but thought I'd share for future visitors. .. Answer… >>> More
Password Recovery without sending password via email

as seen on Stack Overflow - Search for 'Stack Overflow'
So, I've been playing with asp:PasswordRecovery and discovered I really don't like it, for several reasons: 1) Alice's password can be reset even without having access to Alice's email. A security question for password resets mitigates this, but does not really satisfy me. 2) Alice's new password… >>> More

Related posts about change

Making a Job Change That's Easy Why Not Try a Career Change

as seen on Oracle Blogs - Search for 'Oracle Blogs'
A few nights ago I received a comment on one of our blog posts that reminded me of a statistic that I heard a while back. The statistic reflected the change in our views towards work and showed how while people in past generations would stay in one role for their working career - now with so much… >>> More
How to speed up this simple mysql query?

as seen on Programmers - Search for 'Programmers'
The query is simple: SELECT TB.ID, TB.Latitude, TB.Longitude, 111151.29341326*SQRT(pow(-6.185-TB.Latitude,2)+pow(106.773-TB.Longitude,2)*cos(-6.185*0.017453292519943)*cos(TB.Latitude*0.017453292519943)) AS Distance FROM `tablebusiness` AS TB WHERE -6.2767668133836 < TB.Latitude AND… >>> More
Hide/ change width/ change position of UIButton based on device type

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using the new in-app SMS features in my iPhone app, but obviously iPod Touches aren't able to send and receive SMS without support of a third party app. I know all well how to detect the device and how to hide a UIButton, but what I do not know is how to change the width of the others. Above… >>> More
jQuery select change/click problem - change doesn't work in IE, click doesn't work in Chrome

as seen on Stack Overflow - Search for 'Stack Overflow'
As the title says, I have a problem with binding to a change in a dropdown select list - it seems that "change" doesn't work with IE(7 or 8), so when I try the alternative and use a "click" event, it works in IE but doesn't work in Chrome! Am I missing something obvious here? Here's my code: //event… >>> More
Change DIV contents on SELECT change

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking for a method of how to change the contents of a div when an option on a select dropdown is selected. I came across the following: <script type="text/javascript" src="jquery.js"></script>  <select id="thechoices"> <option value="box1">Box… >>> More