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

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

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

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 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