Thread: pgpool error, pid not found!
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
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
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
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@postgresql.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
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@postgresql.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@postgresql.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
The last version of pgpool(not pgpool-II) had been released almost 3 years ago. So I guess it has many bugs found during this 3 years. However as long as the bug does not bite you, it's ok. I just recommend to use pgpool-II in the real world use. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp > one of the student at my school worked on this. I need to extend her thesis. > so thats why I am using this. > Is there any problem if I use this version? > Is this stable version? > Finally I am able to work both pgpool and postgres working togather. > > ________________________________________ > From: Tatsuo Ishii [ishii@sraoss.co.jp] > Sent: Thursday, February 18, 2010 1:56 AM > To: megha1983us@gmail.com > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] pgpool error, pid not found! > > 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@postgresql.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@postgresql.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
I don't think pgpool can be compiled on Windows without heavy modifications. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp > I tried compiling on windows. I didnt get success in that. > > I tried gcc 2 ways. > 1) gcc -o pool_status_query pool_status_query.c > 2)make pool_status_query > > none of them gave me proper answer. there are errors but I cant see all > errors or understand them. > Do you have any clue? > On Sun, Feb 21, 2010 at 7:14 AM, Tatsuo Ishii <ishii@sraoss.co.jp> wrote: > > > > Hi, > > > > > > I made some changes in Pgpool .Now I am using Dev c++ to compile the > > code. > > > Is that the right tool to complie the pgpool code? or I should use Linux > > > compiler. > > > > Do you mean that Windows C compiler? I have no experience with > > compiling pgpool on Windows. Please let me know if you suceed. > > > > > can you advice me which linux compiler I can use? > > > > Plane gcc is fine. > > -- > > Tatsuo Ishii > > SRA OSS, Inc. Japan > > English: http://www.sraoss.co.jp/index_en.php > > Japanese: http://www.sraoss.co.jp > > > > > Thanks > > > > > > On Thu, Feb 18, 2010 at 7:26 PM, Tatsuo Ishii <ishii@sraoss.co.jp> > > wrote: > > > > > > > The last version of pgpool(not pgpool-II) had been released almost 3 > > > > years ago. So I guess it has many bugs found during this 3 years. > > > > However as long as the bug does not bite you, it's ok. > > > > > > > > I just recommend to use pgpool-II in the real world use. > > > > -- > > > > Tatsuo Ishii > > > > SRA OSS, Inc. Japan > > > > English: http://www.sraoss.co.jp/index_en.php > > > > Japanese: http://www.sraoss.co.jp > > > > > > > > > one of the student at my school worked on this. I need to extend her > > > > thesis. > > > > > so thats why I am using this. > > > > > Is there any problem if I use this version? > > > > > Is this stable version? > > > > > Finally I am able to work both pgpool and postgres working togather. > > > > > > > > > > ________________________________________ > > > > > From: Tatsuo Ishii [ishii@sraoss.co.jp] > > > > > Sent: Thursday, February 18, 2010 1:56 AM > > > > > To: megha1983us@gmail.com > > > > > Cc: pgsql-general@postgresql.org > > > > > Subject: Re: [GENERAL] pgpool error, pid not found! > > > > > > > > > > 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@postgresql.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@postgresql.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 > > > > > > > > -- > > > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > > > > To make changes to your subscription: > > > > http://www.postgresql.org/mailpref/pgsql-general > > > > > > > > > > > > > > > > -- > > > Megha > > > > > > -- > Megha