Thread

1. BUG #19075: pg_upgradecluster does not copy conf.d/* during cluster upgrade

   PG Bug reporting form <noreply@postgresql.org> — 2025-10-06T17:23:26Z

   The following bug has been logged on the website:
   
   Bug reference:      19075
   Logged by:          Sergey Belyashov
   Email address:      sergey.belyashov@gmail.com
   PostgreSQL version: 17.6
   Operating system:   Debian bookworm x86_64
   Description:        
   
   I try to upgrade DB postgresql 17 to 18. So I install postgresql-18 (from
   PostgreSQL repo) and then run "pg_upgradecluster -m link 17 main"...
   It fails on checking wal_level of the new cluster - wal_level should be
   logical but it is replica.
   Reason: I have redefined default settings in the extra config file places in
   the /etc/postgresql/17/main/conf.d/local.conf.
   So I have wal_level=logical defined there, but not in the
   /etc/postgresql/17/main/postgresql.conf.
   If I redefine it in the /etc/postgresql/17/main/postgresql.conf then
   pg_upgradecluster succeed.
   
   

2. Re: BUG #19075: pg_upgradecluster does not copy conf.d/* during cluster upgrade

   Bruce Momjian <bruce@momjian.us> — 2025-10-06T18:04:50Z

   On Mon, Oct  6, 2025 at 05:23:26PM +0000, PG Bug reporting form wrote:
   > The following bug has been logged on the website:
   > 
   > Bug reference:      19075
   > Logged by:          Sergey Belyashov
   > Email address:      sergey.belyashov@gmail.com
   > PostgreSQL version: 17.6
   > Operating system:   Debian bookworm x86_64
   > Description:        
   > 
   > I try to upgrade DB postgresql 17 to 18. So I install postgresql-18 (from
   > PostgreSQL repo) and then run "pg_upgradecluster -m link 17 main"...
   > It fails on checking wal_level of the new cluster - wal_level should be
   > logical but it is replica.
   > Reason: I have redefined default settings in the extra config file places in
   > the /etc/postgresql/17/main/conf.d/local.conf.
   > So I have wal_level=logical defined there, but not in the
   > /etc/postgresql/17/main/postgresql.conf.
   > If I redefine it in the /etc/postgresql/17/main/postgresql.conf then
   > pg_upgradecluster succeed.
   
   pg_upgradecluster is maintained by Debian, not the Postgres project.  If
   you can reproduce the error via pg_upgrade, which we do maintain, we can
   research the cause.
   
   -- 
     Bruce Momjian  <bruce@momjian.us>        https://momjian.us
     EDB                                      https://enterprisedb.com
   
     Do not let urgent matters crowd out time for investment in the future.