RE: Replica Identity check of partition table on subscriber

2022-06-11 Thread houzj.f...@fujitsu.com
On Saturday, June 11, 2022 9:36 AM Amit Kapila wrote: > > On Fri, Jun 10, 2022 at 2:26 PM Amit Langote > wrote: > > > > +logicalrep_partmap_invalidate > > > > I wonder why not call this logicalrep_partmap_update() to go with > > logicalrep_relmap_update()? It seems confusing to have > > logical

Re: fix stats_fetch_consistency value in postgresql.conf.sample

2022-06-11 Thread Justin Pryzby
On Mon, May 30, 2022 at 05:27:19PM +0900, Kyotaro Horiguchi wrote: > At Sat, 28 May 2022 13:22:45 -0700, Andres Freund wrote > in > > Hi, > > > > On 2022-05-26 16:27:53 +0900, Kyotaro Horiguchi wrote: > > > It could be in SQL, but *I* prefer to use perl for this, since it > > > allows me to wri

Subscription tests vs log_error_verbosity

2022-06-11 Thread Andrew Dunstan
I have just got to the bottom of why the new subscription tests 027_nosuperuser.pl and 029_on_error.pl have been failing for me - it's because my test setup has log_error_verbosity set to 'verbose'. Either we should force log_error_verbosity to 'default' for these tests, or we should make the rege

Re: Subscription tests vs log_error_verbosity

2022-06-11 Thread Tom Lane
Andrew Dunstan writes: > I have just got to the bottom of why the new subscription tests > 027_nosuperuser.pl and 029_on_error.pl have been failing for me - it's > because my test setup has log_error_verbosity set to 'verbose'. Either > we should force log_error_verbosity to 'default' for these te

Re: Non-replayable WAL records through overflows and >MaxAllocSize lengths

2022-06-11 Thread Matthias van de Meent
On Sat, 11 Jun 2022 at 01:32, David Zhang wrote: > > Hi, > > > > MaxAllocSize is pretty easy: > > > SELECT pg_logical_emit_message(false, long, long) FROM repeat(repeat(' ', > > > 1024), 1024*1023) as l(long); > > > > > > on a standby: > > > > > > 2022-03-11 16:41:59.336 PST [3639744][startup][1/

Re: Collation version tracking for macOS

2022-06-11 Thread Thomas Munro
On Sat, Jun 11, 2022 at 4:21 PM Peter Geoghegan wrote: > What about "time travel collations", but without the time travel part? > That is, what about supporting multiple ICU versions per cluster, but > not per database? So you could upgrade the OS and Postgres, using > standard packages that typic

Re: Collation version tracking for macOS

2022-06-11 Thread Thomas Munro
On Sun, Jun 12, 2022 at 11:59 AM Thomas Munro wrote: > > On Sat, Jun 11, 2022 at 4:21 PM Peter Geoghegan wrote: > > What about "time travel collations", but without the time travel part? > > That is, what about supporting multiple ICU versions per cluster, but > > not per database? So you could u