Re: pgpool error, pid not found!

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

Wao. This is pgpool, right? It's not maintained anymore(it was almost
3 years ago). Please use pgpool-II. The latest version is pgpool-II
2.3.2.1.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Sorry for late reply. I work full time. so I work on postgres in night.
> here is the command that I use.
>
> I started pgpool using this command.
> pgpool/bin/pgpool -f /home/megha/pgpool/etc/pgpool.conf -a
> /home/megha/pgpool/etc/pool_hba.conf
>
> pgpool.conf is attached.
>
> I have been trying to configure postgres and pgpool for past 2 months and I
> am getting too many problems with this.
> I hope you help me out to solve my errors.
>
> Waiting for your reply.
> Thanks
>
> On Tue, Feb 16, 2010 at 10:20 PM, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:
>
> > 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
> >
>
>
>
> --
> Megha

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2010-02-18 07:08:52 Re: Howto analyse sql statement.
Previous Message Scott Bailey 2010-02-18 06:55:52 returning records from plpython