How can I connect to my postgresql-server?-->psql: FATAL Ident−Authentifizierung für Benutzer »ricky«

offbeatlossData Management

Nov 22, 2012 (4 years and 8 months ago)

1,122 views

Re: [opensuse] How can I connect to my
postgresql−server?−−>psql: FATAL:
Ident−Authentifizierung für Benutzer »ricky«
Source: http://linux.derkeiler.com/Mailing−Lists/SuSE/2009−09/msg01157.html
From: Ricky Tompu Breaky <ricky.breaky@xxxxxx>•
Date: Fri, 25 Sep 2009 02:17:10 +0700•
On Thu, 24 Sep 2009 20:57:29 +0200
Anders Johansson <ajohansson@xxxxxxx> wrote:
On Thursday 24 September 2009 20:47:12 Ricky Tompu Breaky wrote:
[...]
postgres@sussy:/root> createuser −D −p ricky
could not change directory to "/root"
Enter name of role to add: ricky
Shall the new role be a superuser? (y/n) y
createuser: could not connect to database postgres: could not
connect to server: No such file or directory Is the server running
locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.0"?
postgres@sussy:/root>
".
Why can I not connect to my Postgres?
Please tell me. Give me a first hint and this small step for me to
getting start to use postgres.
Probably because you used −p instead of −P
−p is when you're running postgresql on a non−standard port, and I
don't think "ricky" is a port − this is why you get the "No such file
or directory". I suspect you wanted to use −P, to assign a password
to the created user ricky
Anders
RB> Dear Anders,
Re: [opensuse] How can I connect to my postgresql−server?−−>psql: FATAL: Ident−Authentifizierung für Benutzer »ricky«
Re: [opensuse] How can I connect to my postgresql−server?−−>psql: FATAL: Ident−Authentifizierung für Benutzer »ricky«1
You're correct (thank you very much) but I still can not do login to my
PostgreSQL.
Here what I've done:
"
postgres@sussy:/root> createuser −D −P ricky
could not change directory to "/root"
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) y
postgres@sussy:/root>
sussy:~ # rcpostgresql restart
Shutting down PostgreSQLServer angehalten
done
Starting PostgreSQL done
sussy:~ # psql −U ricky −W
Password for user ricky:
psql: FATAL: Ident−Authentifizierung für Benutzer »ricky«
fehlgeschlagen sussy:~ #
".
I'm sure that I used the correct password as "createuser" the
account of 'ricky'.
Please keep telling me.
Thank you very much in advance.
−−
To unsubscribe, e−mail: opensuse+unsubscribe@xxxxxxxxxxxx
For additional commands, e−mail: opensuse+help@xxxxxxxxxxxx
Re: [opensuse] How can I connect to my postgresql−server?−−>psql: FATAL: Ident−Authentifizierung für Benutzer »ricky«
Re: [opensuse] How can I connect to my postgresql−server?−−>psql: FATAL: Ident−Authentifizierung für Benutzer »ricky«2