On Thu, 24 Sep 2009 14:55:59 -0400 Chuck Payne wrote:

On Thu, Sep 24, 2009 at 2:47 PM, Ricky Tompu Breaky wrote:

...

Dear my friends....

I am still new in PostgreSQL. Usually I use MySQL on OpenSuSE.

I just have installed postgres with: "zypper install postgresql-server". The installation looked OK.

As post-installation process, I've done: " sussy:~ # rcpostgresql status Checking for PostgreSQL:   running sussy:~ # su postgres 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.

Thank you very much in advance. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Did you do this to see if postgres is running.

ps ax | grep post

You should see something like this...

32028 ? Ss 1:18 postgres: writer process 32029 ? Ss 0:48 postgres: wal writer process 32030 ? Ss 0:03 postgres: autovacuum launcher process 32031 ? Ss 1:50 postgres: stats collector process

If not, then postgres didn't start correct

RB>Dear Chuck, Firstly thank you very much for your answer. Here is my try: " sussy:~ # ps ax | grep post 5584 ? Ss 0:00 /usr/lib/postfix/master 11788 ? Ss 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data 11789 ? Ss 0:00 postgres: logger process 11791 ? Ss 0:00 postgres: writer process 11792 ? Ss 0:00 postgres: wal writer process 11793 ? Ss 0:00 postgres: autovacuum launcher process 11794 ? Ss 0:00 postgres: stats collector process 12274 pts/2 S 0:00 su postgres 12527 pts/4 R+ 0:00 grep post sussy:~ # " -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

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