[Pgpool-general] pgpool Pid Error

Tatsuo Ishii ishii at sraoss.co.jp
Thu Feb 18 09:46:56 UTC 2010


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


More information about the Pgpool-general mailing list