<div dir="ltr">Hi Yugo,<div><br></div><div>I have found pgpool.init at /pgpool-II-3.4.3/src/redhat but '<span style="font-size:12.8px">dpkg -L pgpool' result says</span></div><div><span style="font-size:12.8px"><br></span></div><div><div style=""><span style="font-size:12.8px">dpkg-query: package 'pgpool' is not installed</span></div><div style=""><span style="font-size:12.8px">Use dpkg --info (= dpkg-deb --info) to examine archive files,</span></div><div style=""><span style="font-size:12.8px">and dpkg --contents (= dpkg-deb --contents) to list their contents.</span></div><div style=""><span style="font-size:12.8px"><br></span></div><div style=""><span style="font-size:12.8px">But I have installed pgpool according to following doc and it is working fine.</span></div><div style=""><span style="font-size:12.8px"><br></span></div><div style=""><span style="font-size:12.8px"><a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/</a></span><br></div><div style=""><span style="font-size:12.8px"><br></span></div><div style=""><span style="font-size:12.8px">What should I do now?</span></div><div style=""><span style="font-size:12.8px"><br></span></div><div style=""><span style="font-size:12.8px">Regards,</span></div><div style=""><span style="font-size:12.8px">Giles.</span></div><div style=""><span style="font-size:12.8px"><br></span></div><div style=""><span style="font-size:12.8px"><br></span></div><div style="font-size:12.8px"><br></div></div><div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 5, 2016 at 1:21 PM, Yugo Nagata <span dir="ltr"><<a href="mailto:nagata@sraoss.co.jp" target="_blank">nagata@sraoss.co.jp</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Hi Giles,<br>
<br>
If you build pgpool-II from the tar ball, src/redhat/pgpool.init is this.<br>
Otherwize, if you installed by apt-get or deb packages, unfortunately I don't<br>
know where is. However, in my ubuntu, `dpkg -L pgpool` reuslt says<br>
/etc/init.d/pgpoo2 exists.<br>
<br>
Regards,<br>
Yugo.<br>
<br>
On Tue, 5 Apr 2016 12:18:23 +0600<br>
<div><div class="h5">Giles Cornelius <<a href="mailto:gil.corn@gmail.com">gil.corn@gmail.com</a>> wrote:<br>
<br>
> Dear Nagata,<br>
><br>
> Thank you for your response. Where is the init script of pgpool? There is<br>
> no file at /etc/init.d/ named pgpool or pgpool2.<br>
><br>
> Regards,<br>
> Giles.<br>
><br>
> On Tue, Apr 5, 2016 at 8:04 AM, Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>> wrote:<br>
><br>
> > Hi,<br>
> ><br>
> > On Mon, 4 Apr 2016 17:54:42 +0600<br>
> > Giles Cornelius <<a href="mailto:gil.corn@gmail.com">gil.corn@gmail.com</a>> wrote:<br>
> ><br>
> > > Dear Friends,<br>
> > ><br>
> > > When I reboot pgpool server /var/run/pgpool is deleted. Every time I<br>
> > reboot<br>
> > > the server the I need to create pgpool and change owner and permission. I<br>
> > > am using pgpool 3.4 on Ubuntu.<br>
> > ><br>
> > > What is the solution of this problem?<br>
> ><br>
> > I think this is a problem of Ubuntu not pgpool. I guess /var/run<br>
> > is mounted to tmpfs, so the contents of the directory is deleted on<br>
> > reboot. If so, the directory for pid should be made in the init<br>
> > script such as:<br>
> ><br>
> > PGPOOLUSER=postgres<br>
> > ...<br>
> > PGPOOLPIDDIR=/var/run/pgpool<br>
> > ...<br>
> ><br>
> > if [ ! -d $PGPOOLPIDDIR ]<br>
> > then<br>
> > mkdir $PGPOOLPIDDIR<br>
> > chown ${PGPOOLUSER}: $PGPOOLPIDDIR<br>
> > fi<br>
> ><br>
> ><br>
> > ><br>
> > > Regards,<br>
> > > Giles.<br>
> > ><br>
> > ><br>
> > > --<br>
> ><br>
> ><br>
> > --<br>
> > Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br>
> ><br>
><br>
><br>
><br>
> --<br>
><br>
</div></div>> *<br>
<span class="">><br>
> Every 3000 sheets of paper cost us a tree. Think about hazards related to<br>
</span>> climate change before printing this e-mail.*<br>
<span class=""><font color="#888888"><br>
<br>
--<br>
Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><b><span style="color:rgb(51,51,255)"><font size="2"><span style="text-decoration:underline">
</span><br><span style="font-family:tahoma,'new york',times,serif">Every 3000 sheets of
paper cost us a tree. Think about hazards related to climate change
before printing this e-mail.</span></font></span></b></div>
</div></div></div>