Resetting Root Password For PostgreSQL (Ubuntu 10)

Installed PostgreSQL but had trouble logging in as the postgres superuser. Found help here…

(note… i had to sudo su postgres to get into postgres home directory, then had to switch back to my account user to open pg_hba.conf)

Had help actually finding pg_hba.conf here ( Step 4. PostgreSQL Configuration )…


About distinctinteractive

I graduated 3 years ago from the University of Huddersfield with a 2:1 BA in Interactive Multimedia. After leaving University i worked for a small company in Huddersfield (Offroad Code) mainly helping to maintain a large travel company website. I am currently freelancing as Distinct Interactive. Follow me on Twitter @jimmckerchar
This entry was posted in Gotchas, Ubuntu. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s