Mailinglist Archive: opensuse (1701 mails)

[Ricky Tompu Breaky <ricky.breaky@xxxxxx>]

On Thu, 24 Sep 2009 14:55:59 -0400
Chuck Payne <terrorpup@xxxxxxxxx> wrote:

> On Thu, Sep 24, 2009 at 2:47 PM, Ricky Tompu Breaky
> <ricky.breaky@xxxxxx> 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@xxxxxxxxxxxx
> > For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx
>
> 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@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx