Re: Problem with pgpool-II tool

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: avin_friends(at)yahoo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with pgpool-II tool
Date: 2009-04-23 01:38:10
Message-ID: 20090423.103810.26982919.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The error message says all. Pgpool process needs to create
/var/run/pgpool/pgpool.pid when starting up. So you should give pgpool
write access right to the directory(/var/run/pgpool/), and of courese
along with access right to reach the directory.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Hello,
>
> I have encountered a problem while configuring pgpool-II,I encountered a problem while executing the following command.
>
> pgpool -n &
> [1] 2796
> [achandana(at)localhost ~]$ pool_config: could not open configuration file (pgpool.conf)
> pool_config: using default values...
> pid file found but it seems bogus. Trying to start pgpool anyway...
> 2009-04-19 12:39:24 ERROR: pid 2796: could not open pid file as /var/run/pgpool/pgpool.pid. reason: Permission denied
>
> Following were the default paths in pgpool.conf file
>
> # Logging directory
> logdir = '/tmp'
>
> # pid file name
> pid_file_name = '/var/run/pgpool/pgpool.pid'
>
> since there is no pgpool/pgpool.pid file in run folder i created pgpool directory and pgpool.pid file in that directory and gave a value 2678 in pgpool.pid file then i got the above message.Can you guys please help me in this?
>
> Thanks,
> Aravind.
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-04-23 01:50:28 Re: Help request to improve function performance
Previous Message DM 2009-04-23 00:40:10 Re: how to revoke multiple users permission from multiple tables at the same time?