Setting Up PostgreSQL for Rails on a Mac

Question

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.

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
– Vasseurth, Commented Apr 29, 2012 at 13:54
Thank you, I realized I had made a mistake, complete uninstalled and then reinstalled. — Vasseurth
– Vasseurth, Commented Apr 29, 2012 at 14:04

Igor · Accepted Answer · 2012-05-14 13:55:30Z

2

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

ALTER USER postgres WITH PASSWORD '<newPassword>';

answered May 14, 2012 at 13:55

Igor

34.3k14 gold badges82 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vasseurth Over a year ago

And you do not need the current password to do so?

Igor Over a year ago

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

Collectives™ on Stack Overflow

Setting Up PostgreSQL for Rails on a Mac

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related