On Thu, 24 Sep 2009 20:57:29 +0200
Anders Johansson
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@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org