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 -- ----------------------------------------- Discover it! Enjoy it! Share it! openSUSE Linux. ----------------------------------------- openSUSE -- http://en.opensuse.org/User:Terrorpup openSUSE Ambassador openSUSE Member skype -- terrorpup twitter -- terrorpup Identica -- terrorpup freenode(irc) -- terrorpup/lupinstein. friendfeed -- http://friendfeed.com/terrorpup Have you tried SUSE Studio? Need to create a Live CD, an app you want to package and distribute , or create your own linux distro. Give SUSE Studio a try. http://www.susestudio.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

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