Linked Questions
48 questions linked to/from 'password authentication failed for user "postgres"'
14
votes
3
answers
62k
views
password authentication failed for user "postgres" [duplicate]
I have installed PostgreSQL server 8.4 on my CentOS server sucessfully.
After that, I login to CentOS server by using 'postgres' user, but I can not run any command, the error occur:
password ...
0
votes
0
answers
233
views
pgAdmin:Password authentication failed [duplicate]
I Installed PGadmin9+ in my ubuntu machine few month back but i lost the password of default database postgres . Now when i am trying to connect with postgres DB i am getting error
Error connecting ...
1200
votes
39
answers
1.3m
views
How can I start PostgreSQL server on Mac OS X?
Final update:
I had forgotten to run the initdb command.
By running this command
ps auxwww | grep postgres
I see that postgres is not running
> ps auxwww | grep postgres
remcat 1789 0....
Community wiki
1252
votes
29
answers
1.3m
views
Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails
I'm getting the error:
FATAL: Peer authentication failed for user "postgres"
when I try to make postgres work with Rails.
Here's my pg_hba.conf, my database.yml, and a dump of the full trace.
I ...
171
votes
16
answers
565k
views
What is the default password for Postgres [closed]
I have just installed Postgres 9.3 on Windows 7. The installation completed successfully. It has never asked me to provide the password for postgres user.
The service postgresql-x64-9.3 is up and ...
163
votes
7
answers
490k
views
How can I log in and authenticate to PostgreSQL after a fresh install? [closed]
I did a new install of PostgreSQL 8.4 on Linux Mint/Ubuntu. How do I create a user for PostgreSQL and log in using psql?
When I type psql, it just tells me
psql: FATAL: Ident authentication failed ...
62
votes
8
answers
98k
views
Default password for my user in postgresql
I installed postgresql on my Mac through homebrew. It said it didn't create a postgres account, but is using an account with my username instead. However, running the command psql fails because when I ...
60
votes
5
answers
149k
views
Postgres password authentication fails
I tried to login with the postgres user from my windows machine to my server with Pgadmin.
But it keeps giving me this error:
psql: FATAL: password authentication failed for user "postgres"
So then ...
30
votes
7
answers
33k
views
PgAdmin on Windows 10 with Postgres when installed via Bash on Ubuntu on Windows
I would like to install Rails 5/Postgres within Bash On Ubuntu On Windows
and also be able to access Postgres database via PgAdmin for Windows.
Am quiet happy to install all my rails dependencies ...
17
votes
7
answers
44k
views
ERROR: must be superuser to alter superusers
Unfortunately, I have removed super user privileges from postgres user in PostgreSQL. And currently I have not any super user in PostgreSQL. And i want to make superuser. So how can i make it ? Every ...
17
votes
6
answers
36k
views
Why postgresql on mac asks me for password after fresh install?
I just installed postgresql on a Macbook with brew install postgresql. Then I try to psql, but it requires password and then show psql: FATAL: password authentication failed for user "<myname>"....
9
votes
4
answers
34k
views
FATAL: password authentication failed for user "postgres"
getting this error message in ubuntu. in pg_hba.conf file, I tried using 'ident','peer','trust','md5' in different times.but no go. please help.
17
votes
4
answers
39k
views
PostgreSQL under Lion: What's the password?
I got my new lion machine. Ran the PostgreSQL installer from the PostgreSQL site for Mac and i have no multiple apps installed. One of them is "pgAdmin III.app". When I open it there is already one ...
22
votes
1
answer
58k
views
PSQLException: password-based authentication
Here is the Exception:when I run my testDao file, working on springs.Is there any path given to database in springs?
org.postgresql.util.PSQLException: The server requested password-based ...
4
votes
2
answers
11k
views
error: error: password authentication failed for user "electron_release_server_user"
I was messing around with this amazing Sails project here.
I managed to get it 100% functional on my Macbook Pro with little to no difficulty.
Here's my fork.
Now I'm trying to get it working on ...