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

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,

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

Relevant Pages