Re: Pgbouncer and postgres - Mailing list pgsql-general

From Fabio Pardi
Subject Re: Pgbouncer and postgres
Date
Msg-id d74a3b93-d454-4b33-8299-18f5186625a9@portavita.eu
Whole thread Raw
In response to Re: Pgbouncer and postgres  (Nicola Contu <nicola.contu@gmail.com>)
List pgsql-general
I tried to compile 1.8.1 on my (now) up to date Centos 7 and everything
went ok. I can run pgbouncer and login to it.


this is the relevant part of the diff between config.log files


> config.status:1112: lib/usual/config.h is unchanged
4676c4689
< CPPFLAGS=''
---
> CPPFLAGS=' -I/usr/local/lib/include'

4690c4703
< LDFLAGS='-g  -Wl,--as-needed'
---
> LDFLAGS='-g  -Wl,--as-needed -L/usr/local/lib/lib'


together with the socket problem mentioned earlier makes me think that
we are overlooking something or we miss some important piece of information.

regards,

fabio pardi


On 09/19/2018 06:11 PM, Nicola Contu wrote:
> No the old one is stopped, so not sure why it says the port is in use.
> 
> Attached the config.log
> 
> Thanks
> 
> Il giorno mer 19 set 2018 alle ore 18:02 Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> ha scritto:
> 
>     On 9/19/18 8:39 AM, ncontu1 wrote:
>     > So unexpectedly with the rpms, it installed it on a different
>     place and it is
>     > working from command line
>     >
>     > [root@cmd-dev1 pgbouncer]# /bin/pgbouncer
>     /etc/pgbouncer/pgbouncer.ini -u
>     > postgres
>     > 2018-09-19 15:38:36.081 46322 LOG File descriptor limit: 1024
>     (H:4096),
>     > max_client_conn: 100, max fds possible: 230
>     > 2018-09-19 15:38:36.082 46322 LOG Stale pidfile, removing
>     > 2018-09-19 15:38:36.082 46322 LOG listening on 0.0.0.0:6543
>     <http://0.0.0.0:6543>
>     > 2018-09-19 15:38:36.082 46322 LOG listening on ::/6543
>     > 2018-09-19 15:38:36.083 46322 WARNING Cannot listen on
>     > unix:/tmp/.s.PGSQL.6543: bind(): Address already in use
> 
>     Is the compiled version still running?
> 
>     Or is something else sitting on the 6543 socket?
> 
>     > 2018-09-19 15:38:36.083 46322 LOG process up: pgbouncer 1.8.1,
>     libevent
>     > 2.0.21-stable (epoll), adns: c-ares 1.10.0, tls: OpenSSL
>     1.0.2k-fips  26 Jan
>     > 2017
>     >
>     > [root@cmd-dev1 ~]# psql -U ncontu -p 6543 cmd3dev -h IP_ADD
>     > Password for user ncontu:
>     > psql (10.5)
>     > Type "help" for help.
>     >
>     > cmd3dev=# \q
>     >
>     >
>     > So at this point... I don't really know why compiled from source
>     it does not
>     > work.
> 
>     Not sure.
> 
>     For those that might know it would help to provide the complete
>     ./configure used and the config.log(or equivalent)
> 
>     >
>     >
>     >
>     > --
>     > Sent from:
>     http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>     >
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


pgsql-general by date:

Previous
From: Zexuan Luo
Date:
Subject: Not debuginfo rpm for postgresql96-server package?
Next
From: Durgamahesh Manne
Date:
Subject: Re: *Regarding brin_index on required column of the table