Re: [GENERAL] pgpool error, pid not found!
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 is...@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 is...@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 [is...@sraoss.co.jp] Sent: Thursday, February 18, 2010 1:56 AM To: megha198...@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 is...@postgresql.org wrote: How did you start pgpool exactly(command line)? Also, the number 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 -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.? On Tue, Feb 16, 2010 at 10:09 PM, Tatsuo Ishii is...@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
Re: [GENERAL] pgpool error, pid not found!
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 [is...@sraoss.co.jp] Sent: Thursday, February 18, 2010 1:56 AM To: megha198...@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 is...@postgresql.org wrote: How did you start pgpool exactly(command line)? Also, the number 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 -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.? On Tue, Feb 16, 2010 at 10:09 PM, Tatsuo Ishii is...@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
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 is...@postgresql.org wrote: How did you start pgpool exactly(command line)? Also, the number 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 -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.? On Tue, Feb 16, 2010 at 10:09 PM, Tatsuo Ishii is...@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
[GENERAL] 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
Re: [GENERAL] pgpool error, pid not found!
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgpool error, pid not found!
How did you start pgpool exactly(command line)? Also, the number 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 -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.? On Tue, Feb 16, 2010 at 10:09 PM, Tatsuo Ishii is...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
