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

[Yugo Nagata]

Hi Giles,

On Tue, 5 Apr 2016 16:43:50 +0600
Giles Cornelius <gil.corn at gmail.com> wrote:

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

I'm sorry, it's my mistake. The package name is 'pgpool2' not 'pgpool'... 

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

Just copy pgpool.init included in the tar ball as /etc/init.d/pgpool. This will
make /var/run/pgpool directory if doesn't exist when pgpool-II is started by the
script.

However, note that this is basically made for RHEL not Ubuntu. For example,
this looks for configuration file in the /etc/sysconfig not /etc/default.
Maybe, some modification migth be needed.


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


-- 
Yugo Nagata <nagata at sraoss.co.jp>