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

[ning chan]

Hi Nozomi,
Thanks for the Hint. I have talked with our build team it turns out that it
is a build server configuration problem.
Both prefix and sysconfdif are working now.

Thanks~
Ning


On Wed, Apr 17, 2013 at 9:17 PM, Nozomi Anzai <anzai at sraoss.co.jp> wrote:

> Hi,
>
> > I know it is referencing to the /etc/pgpool.conf because if i delete the
> > file, pgpool will complain:
> > [root at se032c-94-30 ~]# mv /etc/pgpool.conf /etc/pgpool.conf.bkp
> > mv: overwrite `/etc/pgpool.conf.bkp'? y
> > [root at 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 at 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 at 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 at pgpool.net
> > > > > http://www.pgpool.net/mailman/listinfo/pgpool-general
> > > > >
> > > > >
> > >
> > >
> > > --
> > > Nozomi Anzai
> > > SRA OSS, Inc. Japan
> > > _______________________________________________
> > > pgpool-general mailing list
> > > pgpool-general at pgpool.net
> > > http://www.pgpool.net/mailman/listinfo/pgpool-general
> > >
>
>
> --
> Nozomi Anzai
> SRA OSS, Inc. Japan
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130418/f471509f/attachment.html>