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

Giles Cornelius gil.corn at gmail.com
Wed Apr 6 21:27:30 JST 2016


Hi Yugo,

I can see that lot of paths are lot of paths in pgpool.init which are not
matching with ubuntu. Can you please tell me what are the changes I need to
make in that file.

Regards,
Giles.

On Wed, Apr 6, 2016 at 7:23 AM, Yugo Nagata <nagata at sraoss.co.jp> wrote:

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



-- 

*

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/20160406/028a5df7/attachment.html>


More information about the pgpool-general mailing list