psql: FATAL: Ident authentication failed for user "postgres"
$ sudo -u postgres psql
password
Enter password: ...
...psql: FATAL: Ident authentication failed for user "postgres"
$ sudo -u postgres psql
password
Enter password: ...
...password authentication failed for user postgres pgadmin
happened with me as well, when I started pgadmin3 for the first time, i was expecting it to ask for the password which I provided during but it didnt ask and then didnt display any servers.
anyways, you can create a server yourself,
if your server is on the same machine,
provide a name: test
provide server: localhost
port: 5432 (default port)
user: postgres (default user) you can change later in login roles
password: provide something
restart if required and it will then show you
database with postgres (default db),
tablespace,
login roles
under your server and you should be good to goCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
