Re: pgpool error, pid not found!

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: megha1983us(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pgpool error, pid not found!
Date: 2010-02-17 03:20:53
Message-ID: 20100217.122053.115913870.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How did you start pgpool exactly(command line)?

Also, the number "9999" dpends on pgpool.conf.
Can you show me pgpool.conf?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> >From the README file , I found that " psql -p 9999 -c 'show pool_status'
> template1" command gives the internal status of pgpool.
> so when i start pgpool, I dont get any inernal status.
> I get this error message
>
> psql: 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.9999"?
>
>
>
> On Tue, Feb 16, 2010 at 10:09 PM, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
>
> > pgpool.pid file contains pgpool's parent process id. That message
> > indicates that the file exists but the pgpool process id does not
> > exist. Probably pgpool was stopped in unclean way. You may ignore the
> > message as long as pgpool starts ok.
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> > English: http://www.sraoss.co.jp/index_en.php
> > Japanese: http://www.sraoss.co.jp
> >
> > > Hi
> > >
> > > I have installed pgpool in /home/megha/pgpool dir.
> > > I found pgpool.pid file in /tmp folder.
> > >
> > > when I try to start pgpool I get this error.
> > > *pid file found but it seems bogus. Trying to start pgpool anyway..*
> > >
> > > Please help me!
> > >
> > >
> > > Thanks,
> > >
> > > --
> > > Megha
> >
>
>
>
> --
> Megha

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2010-02-17 05:17:56 Why am I getting this error in DB
Previous Message Tatsuo Ishii 2010-02-17 03:09:47 Re: pgpool error, pid not found!