current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 2 down vote favorite

I just recently installed postgresql for mac with this. The problem I get, however, is that I never stated a password for the user 'postgres' but this seems vitally necessary to do anything with postgresql.

share|improve this question
1  
I gather you've read the installation guide? –  Milen A. Radev Apr 28 '12 at 13:47
    
Hmm, It doesn't prompt me to do the middle part (setup a password and other settings). Is there a way to completely remove postgresql? –  Vasseurth Apr 29 '12 at 13:54
    
Thank you, I realized I had made a mistake, complete uninstalled and then reinstalled. –  Vasseurth Apr 29 '12 at 14:04

1 Answer 1

up vote 2 down vote accepted

In the future, you do not need to completely reinstall, you can change the password with:

ALTER USER postgres WITH PASSWORD '<newPassword>';
share|improve this answer
    
And you do not need the current password to do so? –  Vasseurth May 15 '12 at 14:24
    
@Planetpluto I believe that as long as you are running the command as a privileged user, you should be fine. So if the superuser doesn't have a password, as long as your are logged into that account then this should still work, yes. Please correct me if this does not turn out to be the case. –  Igor May 15 '12 at 14:30

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.