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 <[email protected]> > To: [email protected] > Cc: [email protected]; [email protected] > 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 <[email protected]> > > > *To:* Rahul Reddy <[email protected]> > > > *Cc:* "[email protected]" <[email protected]> > > > *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 > > [email protected] > > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
