[pgpool-general: 1631] Re: PgPool rpm spec file

[Nozomi Anzai]

Hi,

> I know it is referencing to the /etc/pgpool.conf because if i delete the
> file, pgpool will complain:
> [root ¡÷ se032c-94-30 ~]# mv /etc/pgpool.conf /etc/pgpool.conf.bkp
> mv: overwrite `/etc/pgpool.conf.bkp'? y
> [root ¡÷ se032c-94-30 ~]# pgpool
> pool_config: could not open configuration file (pgpool.conf)
> pool_config: using default values...
> 
> I have the same sysconfdir and prefix as my configure argument.

I see.
Could you show me the result of "pgpool --help"? It shows you the default
location of conf files to which pgpool refers.

----
ex.) I installed pgpool with "./configure --prefix=/usr".
$ bin/pgpool --help
:
  -f, --config-file=CONFIG_FILE
                      Sets the path to the pgpool.conf configuration file
                      (default: /usr/etc/pgpool.conf)
:

*) /usr/etc/pgpool.conf doesn' t exist, but /usr/etc/pgpool.conf.sample does.
----

> Side question, do i need to have the postgresql lib and include folder
> available in order to 'make' pgpool?
>
> Here is my configure cmd:
> --with-pgsql-libdir=/usr/pgsql-9.2/lib --prefix=/usr
>
> while /usr/pgsql-9.2/lib is not available during the compile time.  Will
> that be an issue?

Yes, it will be becouse pgpool needs PostgreSQL's libralies whichever by
RPM or by souce codes. If not, compaile will fail.
And, you might have to install not only postgresql92 but also
postgresql92-libs and postgresql92-devel, and you can use "./configure
--with-pgsql=/usr/pgsql-9.2" simply.

BTW, didn't you use "--sysconfdir" option?
I installed with "./configure --prefix=/usr --sysconfdir=/etc/pgpool_test",
and pgpool.con.sample was in /etc/pgpool_test.

# cp /etc/pgpool_test/pgpool.conf.sample /etc/pgpool_test/pgpool.conf
# /usr/bin/pgpool -nD
2013-04-18 11:15:43 LOG:   pid 28005: Backend status file /var/log/pgpool/pgpool_status discarded
2013-04-18 11:15:43 LOG:   pid 28005: pgpool-II successfully started. version 3.2.3 (namameboshi)
:

> Thanks~
> Ning
> 
> 
> On Tue, Apr 16, 2013 at 11:59 PM, Nozomi Anzai <anzai ¡÷ sraoss.co.jp> wrote:
> 
> > Hi,
> >
> > # I resend because I didn't reply to ML.
> >
> > > Hi Nozomi,
> > > Sorry for the late reply.
> > > I did not use your spec file directly but I referenced to it and it is
> > > working perfectly.
> > > One thing I would like to mention is that, i use the --prefix and
> > > --sysconfdir, the prefix works, without problem but the syscondir does
> > not.
> > > I set --sysconfdir=/etc/pgpool, but it still reference to
> > /etc/pgpool.conf
> > > and I guess that is the default location?
> > > I also verify that it did not reference to /usr/bin/etc which my
> > > prefix=/usr/
> >
> > Is configure in your spec file like this?
> >
> > %configure --with-pgsql-includedir=%{_includedir}/pgsql \
> >            --with-pgsql-lib=%{_libdir}/pgsql \
> >            --disable-static --with-pam --disable-rpath \
> >            --sysconfdir=/etc/pgpool/ \
> >            --prefix=/usr/
> >
> > I tried rpmbuild with this, and confirmed that /etc/pgpool was created and
> > that pgpool.conf was as /etc/pgpool/pgpool.conf. It seems fine.
> > So, could you tell me in detail about that "it still reference
> > to /etc/pgpool.conf"? How did you see it?
> > # The default is /etc/pgpool-II/pgpool.conf in my spec file.
> >
> > > Is this expected?
> > >
> > > Thanks~
> > > Ning
> > >
> > >
> > > On Sun, Apr 7, 2013 at 8:19 PM, Nozomi Anzai <anzai ¡÷ sraoss.co.jp> wrote:
> > >
> > > > Hi,
> > > >
> > > > > Hi all,
> > > > > Does anyone has a good rpm build process and spec file for pgpool to
> > > > share?
> > > >
> > > > Recently I'm updating pgpool.spec for 3.2.
> > > > Could you try this attached spec file?
> > > >
> > > >
> > > > > Thanks~
> > > > > Ning
> > > >
> > > >
> > > > --
> > > > Nozomi Anzai
> > > > SRA OSS, Inc. Japan
> > > >
> > > > _______________________________________________
> > > > pgpool-general mailing list
> > > > pgpool-general ¡÷ pgpool.net
> > > > http://www.pgpool.net/mailman/listinfo/pgpool-general
> > > >
> > > >
> >
> >
> > --
> > Nozomi Anzai
> > SRA OSS, Inc. Japan
> > _______________________________________________
> > pgpool-general mailing list
> > pgpool-general ¡÷ pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-general
> >


-- 
Nozomi Anzai
SRA OSS, Inc. Japan