[Pgpool-general] pgpool Pid Error

[Tatsuo Ishii]

Just use ps to find pgpool parent process and kill it by SIGTERM
(smart shutdown) or SIGINT/SIGQUIT(fast/immediate shutdown).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> I guess i know what the problem is. 
> 
> I have accidently deleted the pid file as i couldn't find it. 
> 
> Anyway how i can restore it ?
> 
> I uninstalled pgpool and reinstalled it and still couldn't retrieve the pgpool.pid
> 
> appreciate your response
> 
> 
> 
> 
> 
> 
> 
> ________________________________
> From: Tatsuo Ishii <ishii at sraoss.co.jp>
> To: ger.apeldoorn at sara.nl
> Cc: nilapusa at yahoo.com; pgpool-general at pgfoundry.org
> Sent: Thu, February 18, 2010 4:46:56 AM
> Subject: Re: [Pgpool-general] pgpool Pid Error
> 
> In addition to this, I would suggest to use strace to track file
> accesses.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
> 
> > Hi Rahul,
> > 
> > Check that the file you moved is an init-script (which accepts the start 
> > and stop parameters) and not the pgpool binary itself.
> > 
> > If you created the pid-directory, make sure the user that pgpool runs as 
> > has write access to it.
> > 
> > Greetings,
> > Ger Apeldoorn
> > 
> > Rahul Reddy wrote:
> > > Thank Ger,
> > >
> > > I tried stopping the pgpool, but i get the following error when i run 
> > > /etc/init.d/pgpool stop( I had to move pgpool from pgpool/bin to 
> > > /etc/init.d/pgpool)
> > >
> > > pool_config: could not open configuration file(pgpool.conf)
> > > pool_config: using default values...
> > > ERROR: pid 29400: could not read pid file
> > >
> > >
> > > I created a pgpool folder in /var/run to match the pid_file_name path 
> > > in pgpool.conf file. I checked the /var/run/pgpool and the pgpool.pid 
> > > was not there
> > >
> > > Appreciate any help
> > >
> > > ------------------------------------------------------------------------
> > > *From:* Ger Apeldoorn <ger.apeldoorn at sara.nl>
> > > *To:* Rahul Reddy <nilapusa at yahoo.com>
> > > *Cc:* "pgpool-general at pgfoundry.org" <pgpool-general at pgfoundry.org>
> > > *Sent:* Wed, February 17, 2010 2:28:00 AM
> > > *Subject:* Re: [Pgpool-general] pgpool Pid Error
> > >
> > > Hi Rahul,
> > >
> > > It sounds like that pgpool is already running. Otherwise another 
> > > process is using the port.
> > >
> > > Try ps -ef | grep pgpool to see if pgpool is running in the background.
> > >
> > > Stop it (/etc/init.d/pgpool stop)
> > > then try to start it again with pgpool -n -d
> > >
> > > Greetings
> > > Ger Apeldoorn
> > >
> > > Rahul Reddy wrote:
> > > > Hello, After installing pgpooll 2.2.2 on a pgpool directory inside 
> > > where i installed PosgreSQL 8.4.2,
> > > >
> > > > I get the following error message when i type pgpool -n -d. right 
> > > after I install the pgpooll:
> > > >
> > > >
> > > > pool_config: could not open configuration file (pgpool.conf)
> > > > pool_config: using default values...
> > > > ERROR Pid 25200: bind(localhost.localdomain:distinct) failed reason: 
> > > address already in use
> > > > ERROR Pid 25200: unlink() failed
> > > > DEBUG Pid 25200: shmem_exit(1)
> > > >
> > > > Any help is greatly appreciated
> > > > thanks,
> > > > Sami
> > > >
> > > >
> > >
> > _______________________________________________
> > Pgpool-general mailing list
> > Pgpool-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgpool-general
> 
> 
> 
>