current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I've been attempting to connect to my server's PostgreSQL database. The error message I am getting is "Error connecting to the server: FATAL: password authentication failed for user "postgres"

I've tried a whole bunch of things, but I think I'm just chasing my tail at this point.

Some of the things I've tried is multiple iterations of the pg_hba.conf file, such as changing md5 to password, all to template1, all to postgres, changing the password time limit to 'infinity,' commenting out sections of the pg_hba.conf file, and etc.

I did change the listen_adress to "*" in the postgres.conf file.

So, this is where the pg_hba.conf file is right now: 

host    all     all     machine.ip.address/16       password

I've attempted multiple masks, such as 16, 32, 24, etc.

I'm at an utter loss here. Just want to log into the server on my local machine and (hopefully) use PgAdmin. I'm guessing at that point that the problem is not in the pg_hba file, but I wouldn't know where to go from here.

I just upgraded to PostgreSQL 9.3. The server and the local machine are Arch Linux.

Thanks.

share|improve this question

closed as off-topic by dezso, Michael - sqlbot, Marian, Max Vernon, RolandoMySQLDBA Jan 29 '14 at 18:09

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – dezso, Michael - sqlbot, Marian, Max Vernon, RolandoMySQLDBA
If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer 1

up vote 0 down vote accepted

Are you sure you are using the right password for the postgres user? Have you tried to use the createuser command and try and login with that user?

share|improve this answer
    
It may have have been that I only created the password at the server level, but not in the database level using the ALTER USER command. Thanks for the fast reply @FabrizioMazzoni. –  dizzystar Jan 27 '14 at 6:05

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