pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #19075: pg_upgradecluster does not copy conf.d/* during cluster upgrade
2+ messages / 2 participants
[nested] [flat]

* BUG #19075: pg_upgradecluster does not copy conf.d/* during cluster upgrade
@ 2025-10-06 17:23 PG Bug reporting form <noreply@postgresql.org>
  2025-10-06 18:04 ` Re: BUG #19075: pg_upgradecluster does not copy conf.d/* during cluster upgrade Bruce Momjian <bruce@momjian.us>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2025-10-06 17:23 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: sergey.belyashov@gmail.com

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #19075: pg_upgradecluster does not copy conf.d/* during cluster upgrade
  2025-10-06 17:23 BUG #19075: pg_upgradecluster does not copy conf.d/* during cluster upgrade PG Bug reporting form <noreply@postgresql.org>
@ 2025-10-06 18:04 ` Bruce Momjian <bruce@momjian.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2025-10-06 18:04 UTC (permalink / raw)
  To: sergey.belyashov@gmail.com; pgsql-bugs@lists.postgresql.org

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.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2025-10-06 18:04 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-10-06 17:23 BUG #19075: pg_upgradecluster does not copy conf.d/* during cluster upgrade PG Bug reporting form <noreply@postgresql.org>
2025-10-06 18:04 ` Bruce Momjian <bruce@momjian.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox