Re: Do we still need MULE_INTERNAL?

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgsql(at)j-davis(dot)com
Cc: thomas(dot)munro(at)gmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Do we still need MULE_INTERNAL?
Date: 2026-04-01 22:50:06
Message-ID: 20260402.075006.1215979483410908859.ishii@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Repro of my case:
>
> cd pgsql18dbg
> ./bin/initdb -D data -N -E MULE_INTERNAL --locale=C
> ./bin/pg_ctl -D data -l logfile start
> PGCLIENTENCODING=SQL_ASCII ./bin/psql postgres \
> -c 'create table x(t text);'
> ./bin/pg_ctl -D data stop
> cd ../pgsql19dbg
> ./bin/initdb -D data -N -E SQL_ASCII --locale=C
> ./bin/pg_upgrade -b ../pgsql18dbg/bin -B bin \
> -d ../pgsql18dbg/data -D data

Oh, initdb with encoding MULE_INTERNAL. I see cause of the error now.

> ===========================
> ...
> Performing Upgrade
> ------------------
> ...
> Setting frozenxid and minmxid counters in new cluster
> connection to server on socket ".../pgsql19dbg/.s.PGSQL.50432" failed:
> FATAL: invalid database encoding: 7
>
> Failure, exiting
> ===========================
>
> It's easy to fix by just rejecting MULE_INTERNAL during the "check"
> phase.

Agreed.

Regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2026-04-01 22:50:15 Re: index prefetching
Previous Message Peter Smith 2026-04-01 22:36:12 Re: DOCS - DROP SUBSCRIPTION does not document parameter "IF EXISTS"