| From: | Chris Stephens <cstephens16(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | pgbouncer configuration |
| Date: | 2021-04-28 00:46:38 |
| Message-ID: | CAEFL0syTvyKTVkdTu+gda0Nrh8Evfp+3pTb1wGPgLeXBQXjVmw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm trying to run pgbouncer but am having trouble with what looks like a
very simple configuration.
centos 7
postgres 12
pgbouncer 1.15
we are already using pam for database auth. pgbouncer was compiled with
--with-pam. there is a /etc/pam.d/pgbouncer config file copied from the one
currently being used for postgres auth.
i can list the whole config file if needed but i get the following when
trying to start pgbouncer up:
[postgres(at)lsst-pgsql02 ~]$ pgbouncer -d /etc/pgbouncer/pgbouncer.ini
2021-04-27 19:37:34.256 CDT [10653] ERROR invalid value "pam" for parameter
auth_type in configuration (/etc/pgbouncer/pgbouncer.ini:118)
2021-04-27 19:37:34.256 CDT [10653] FATAL cannot load config file
[postgres(at)lsst-pgsql02 pgbouncer]$ egrep "auth_type" pgbouncer.ini
auth_type = pam
any ideas?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Pospisek | 2021-04-28 06:03:56 | Re: very long secondary->primary switch time |
| Previous Message | Tom Lane | 2021-04-27 20:16:01 | Re: very long secondary->primary switch time |