On Thu, 24 Sep 2009 14:55:59 -0400
Chuck Payne
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