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@xxxxxxxxxxxx> 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@xxxxxxxxxxxx> > > 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@xxxxxxxxxxxx] > > > > > Sent: Thursday, February 18, 2010 1:56 AM > > > > > To: megha1983us@xxxxxxxxx > > > > > Cc: pgsql-general@xxxxxxxxxxxxxx > > > > > Subject: Re: 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@xxxxxxxxxxxxxx> > > > > 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@xxxxxxxxxxxxxx> > > > > > > > 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@xxxxxxxxxxxxxx) > > > > To make changes to your subscription: > > > > http://www.postgresql.org/mailpref/pgsql-general > > > > > > > > > > > > > > > > -- > > > Megha > > > > > > -- > Megha -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
