Message-ID: <c2d6beff-ab80-ad76-930f-05e4ddd9578c@sourcepole.ch>
Date: Wed, 11 May 2022 16:07:36 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.8.0
Content-Language: en-GB
To: pgsql-pkg-debian@lists.postgresql.org
From: Tomas Pospisek <tpo2@sourcepole.ch>
Subject: Breakage: pgbouncer has changed the user under which it runs between
 1.16.1 and 1.17.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/c2d6beff-ab80-ad76-930f-05e4ddd9578c%40sourcepole.ch>
Precedence: bulk

Dear packagers,

Due to the change of user under which pgbouncer runs (before: user 
pgbouncer, new: user postgres), an upgrade from 1.16.1 to 1.17.0 will 
break systems.

     # cat /var/log/apt/history.log
     [...]
     Upgrade: pgbouncer:amd64 (1.16.1-1.pgdg20.04+1,
              1.17.0-3.pgdg20.04+1)

     # cat /etc/apt/sources.list.d/apt_postgresql_org_pub_repos_apt.list
     deb http://apt.postgresql.org/pub/repos/apt/ focal-pgdg main

Workaround:

     # chown postgres.postgres /etc/pgbouncer/*
     # # the next line depends on where pgbouncer is set up to save
     # # its logs go - see /etc/pgbouncer/pgbouncer.ini
     # chown -R postgres.postgres /var/log/pgbouncer/
     # # see preceeding comment
     # chown postgres.postgres /var/log/postgres/pgbouncer*
     # chown -R postgres.postgres /var/run/pgbouncer

I've originally reported that [here] and was redirected to this mailing 
list.

Thanks a lot for the packages & greetings,
*t

[here](https://github.com/pgbouncer/pgbouncer/issues/716)