[pgpool-general: 4618] Re: /var/run/pgpool is deleted after rebooting the machine

[Giles Cornelius]

Hi Yugo,

I have found  pgpool.init at /pgpool-II-3.4.3/src/redhat but 'dpkg -L
pgpool' result says

dpkg-query: package 'pgpool' is not installed
Use dpkg --info (= dpkg-deb --info) to examine archive files,
and dpkg --contents (= dpkg-deb --contents) to list their contents.

But I have installed pgpool according to following doc and it is working
fine.

http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/

What should I do now?

Regards,
Giles.




On Tue, Apr 5, 2016 at 1:21 PM, Yugo Nagata <nagata at sraoss.co.jp> wrote:

> Hi Giles,
>
> If you build pgpool-II from the tar ball, src/redhat/pgpool.init is this.
> Otherwize, if you installed by apt-get or deb packages, unfortunately I
> don't
> know where is. However, in my ubuntu, `dpkg -L pgpool` reuslt says
> /etc/init.d/pgpoo2 exists.
>
> Regards,
> Yugo.
>
> On Tue, 5 Apr 2016 12:18:23 +0600
> Giles Cornelius <gil.corn at gmail.com> wrote:
>
> > Dear Nagata,
> >
> > Thank you for your response. Where is the init script of pgpool? There is
> > no file at /etc/init.d/ named pgpool or pgpool2.
> >
> > Regards,
> > Giles.
> >
> > On Tue, Apr 5, 2016 at 8:04 AM, Yugo Nagata <nagata at sraoss.co.jp> wrote:
> >
> > > Hi,
> > >
> > > On Mon, 4 Apr 2016 17:54:42 +0600
> > > Giles Cornelius <gil.corn at gmail.com> wrote:
> > >
> > > > Dear Friends,
> > > >
> > > > When I reboot pgpool server /var/run/pgpool is deleted. Every time I
> > > reboot
> > > > the server the I need to create pgpool and change owner and
> permission. I
> > > > am using pgpool 3.4 on Ubuntu.
> > > >
> > > > What is the solution of this problem?
> > >
> > > I think this is a problem of Ubuntu not pgpool. I guess /var/run
> > > is mounted to tmpfs, so the contents of the directory is deleted on
> > > reboot. If so, the directory for pid should be made in the init
> > > script such as:
> > >
> > > PGPOOLUSER=postgres
> > > ...
> > > PGPOOLPIDDIR=/var/run/pgpool
> > > ...
> > >
> > > if [ ! -d $PGPOOLPIDDIR ]
> > > then
> > >     mkdir $PGPOOLPIDDIR
> > >     chown ${PGPOOLUSER}: $PGPOOLPIDDIR
> > > fi
> > >
> > >
> > > >
> > > > Regards,
> > > > Giles.
> > > >
> > > >
> > > > --
> > >
> > >
> > > --
> > > Yugo Nagata <nagata at sraoss.co.jp>
> > >
> >
> >
> >
> > --
> >
> > *
> >
> > Every 3000 sheets of paper cost us a tree. Think about hazards related to
> > climate change before printing this e-mail.*
>
>
> --
> Yugo Nagata <nagata at sraoss.co.jp>
>



-- 

*

Every 3000 sheets of paper cost us a tree. Think about hazards related to
climate change before printing this e-mail.*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160405/bed9a65c/attachment.html>