Mailing lists [pgsql-general]

1 October 2021

• 11:52   Sysbench tests on PG12 Subhrajyoti Senapati
• 13:12   Where can I find the pg_config binary in PostgreSQL 14? Oskar Stenberg
• 13:42   Re: Where can I find the pg_config binary in PostgreSQL 14? Oskar Stenberg
• 14:58   Re: Sysbench tests on PG12 Subhrajyoti Senapati
• 15:03   Re: postgresql11: How to use publication/subscription on primary/standby setup Tomas Pospisek
• 19:25   Problem in Storing Satellite imagey(Geotiff file) Vijay Garg

2 October 2021

• 23:48   Re: Problem in Storing Satellite imagey(Geotiff file) Adrian Klaver

3 October 2021

• 10:31   PostgreSQL CHECK Constraint Shaozhong SHI
• 10:48   PostgreSQL - Ordering Table based of Foreign Key FOUTE K. Jaurès
• 11:45   Re: PostgreSQL - Ordering Table based of Foreign Key Karsten Hilbert
• 11:49   Re: PostgreSQL - Ordering Table based of Foreign Key Thomas Kellerer
• 12:26   Re: PostgreSQL - Ordering Table based of Foreign Key Andreas Joseph Krogh
• 17:01   Re: PostgreSQL CHECK Constraint Christian Ramseyer
• 17:40   Re: PostgreSQL - Ordering Table based of Foreign Key FOUTE K. Jaurès
• 19:19   Re: PostgreSQL - Ordering Table based of Foreign Key Adrian Klaver
• 19:24   Re: PostgreSQL - Ordering Table based of Foreign Key FOUTE K. Jaurès
• 19:56   pg_dump save command in output Joao Miguel Ferreira
• 20:00   Re: PostgreSQL - Ordering Table based of Foreign Key Adrian Klaver
• 20:03   Re: pg_dump save command in output Adrian Klaver
• 20:15   Re: pg_dump save command in output Joao Miguel Ferreira
• 20:23   Re: pg_dump save command in output Karsten Hilbert
• 20:23   Re: pg_dump save command in output Adrian Klaver
• 21:16   Re: PostgreSQL CHECK Constraint Shaozhong SHI
• 21:35   Re: PostgreSQL CHECK Constraint Karsten Hilbert
• 21:44   Re: PostgreSQL CHECK Constraint Shaozhong SHI
• 21:47   Re: PostgreSQL CHECK Constraint Christian Ramseyer
• 21:53   Re: PostgreSQL CHECK Constraint Shaozhong SHI
• 21:56   Re: PostgreSQL CHECK Constraint Karsten Hilbert
• 22:51   Splitting libpq build Igor Korot
• 23:11   Re: Splitting libpq build Tom Lane
• 23:20   Re: Splitting libpq build Igor Korot
• 23:28   Re: Splitting libpq build Adrian Klaver
• 23:35   Re: Splitting libpq build Tom Lane

4 October 2021

• 00:10   Re: Splitting libpq build Igor Korot
• 00:14   Re: Check constraint failure messages zim
• 00:32   Re: PostgreSQL - Ordering Table based of Foreign Key David G. Johnston
• 00:49   Re: Check constraint failure messages David G. Johnston
• 01:27   Re: Splitting libpq build Tom Lane
• 01:55   Re: Splitting libpq build Igor Korot
• 09:30   create a new GIN index for my own type huangning290@yahoo.com
• 10:28   Problem in pg_basebackup of 1.7 TB database while replicating in PostgreSQL 9.4.( Master and slave both are in postgreSQL 9.4) Amal Chakravarty
• 12:19   Re: Problem in Storing Satellite imagey(Geotiff file) Vijay Garg
• 13:35   Why would Postgres 11 suddenly ignore the recovery.conf file? Dennis Jacobfeuerborn
• 13:40   How to set up temporary path for starting up psql in any folder? Shaozhong SHI
• 13:40   Re: Why would Postgres 11 suddenly ignore the recovery.conf file? Josef Šimánek
• 13:42   Re: Why would Postgres 11 suddenly ignore the recovery.conf file? Dennis Jacobfeuerborn
• 13:43   Re: Why would Postgres 11 suddenly ignore the recovery.conf file? hubert depesz lubaczewski
• 13:45   Re: Why would Postgres 11 suddenly ignore the recovery.conf file? Dennis Jacobfeuerborn
• 14:02   Re: PostgreSQL - Ordering Table based of Foreign Key FOUTE K. Jaurès
• 14:24   Re: How to set up temporary path for starting up psql in any folder? Francisco Olarte
• 14:42   Re: create a new GIN index for my own type Tomas Vondra
• 14:43   Re: Problem in pg_basebackup of 1.7 TB database while replicating in PostgreSQL 9.4.( Master and slave both are in postgreSQL 9.4) Tomas Vondra
• 16:49   Re: create a new GIN index for my own type Tomas Vondra
• 17:14   Re: Problem in pg_basebackup of 1.7 TB database while replicating in PostgreSQL 9.4.( Master and slave both are in postgreSQL 9.4) Ron
• 18:12   Re: Problem in Storing Satellite imagey(Geotiff file) Adrian Klaver
• 18:44   Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Shaozhong SHI
• 19:06   Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Adrian Klaver
• 19:20   Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Shaozhong SHI
• 19:22   Growth planning Israel Brewster
• 19:25   Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Rob Sargent
• 19:29   DELETE ... USING LATERAL Nikhil Benesch
• 19:46   Re: Growth planning Rob Sargent
• 19:50   Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Adrian Klaver
• 20:09   Re: Growth planning Israel Brewster
• 20:10   Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Shaozhong SHI
• 20:22   Re: Growth planning Rob Sargent
• 20:28   Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Adrian Klaver
• 20:30   Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Adrian Klaver
• 20:36   Re: Growth planning Israel Brewster
• 20:48   Re: DELETE ... USING LATERAL Tom Lane
• 21:36   Re: DELETE ... USING LATERAL Nikhil Benesch
• 22:03   Re: DELETE ... USING LATERAL Michael Lewis
• 22:21   Re: DELETE ... USING LATERAL Tom Lane
• 22:24   Re: Postgres PANIC when it could not open file in pg_logical/snapshots directory Alvaro Herrera
• 22:27   Re: DELETE ... USING LATERAL Tom Lane
• 23:29   Re: Growth planning Alban Hertroys
• 23:46   Re: Growth planning Ron

5 October 2021

• 00:09   Re: Growth planning Israel Brewster
• 00:20   Query time related to limit clause Shubham Mittal
• 00:21   Re: Growth planning Rob Sargent
• 00:27   Re: PostgreSQL 9.2 high replication lag - Part 2 Lucas
• 00:37   Re: Growth planning Israel Brewster
• 01:04   Re: Growth planning Israel Brewster
• 01:05   Re: Growth planning Rob Sargent
• 01:29   How to build psycopg2 for Windows Dan Davis
• 01:40   Re: How to build psycopg2 for Windows Daniele Varrazzo
• 01:57   Re: How to build psycopg2 for Windows Dan Davis
• 03:49   Re: Growth planning Ryan Booz
• 06:36   help implementing OGR Postgres foreign data wrapper  Brent Wood
• 10:57   Re: help implementing OGR Postgres foreign data wrapper Ben Madin
• 11:10   Re: PostgreSQL 9.2 high replication lag - Part 2 Ben Madin
• 11:11   Re: help implementing OGR Postgres foreign data wrapper Brent Wood

6 October 2021

• 02:03   Re: Growth planning Israel Brewster
• 06:50   type bug? ml@ft-c.de
• 08:21   Re: type bug? Ron
• 08:23   Re: Query time related to limit clause Michael Lewis
• 09:02   Re: type bug? ml@ft-c.de
• 09:10   Re: type bug? David G. Johnston
• 09:14   Re: type bug? David G. Johnston
• 09:42   Re: type bug? Pavel Stehule
• 12:33   Re: pg_dump save command in output Daniel Gustafsson
• 12:44   Re: pg_dump save command in output Joao Miguel Ferreira
• 12:58   how to merge two postgresql server instances into one Marco Lechner
• 13:01   idle_in_transaction_session_timeout Philippe Doussot
• 13:22   Re: pg_dump save command in output Laurenz Albe
• 13:40   Re: pg_dump save command in output Daniel Gustafsson
• 14:43   streaming replication different versions Marc Millas
• 14:46   Re: streaming replication different versions Thomas Kellerer
• 14:56   Re: pg_dump save command in output Joao Miguel Ferreira
• 18:03   Re: streaming replication different versions Guillaume Lelarge
• 18:06   Re: [Ext:] Configuration of pgaudit settings in postgreSQL.conf causes postgreSQL to fail to start Allie Crawford
• 18:32   Re: how to merge two postgresql server instances into one Adrian Klaver
• 18:50   Re: streaming replication different versions Marc Millas

7 October 2021

• 00:59   Using make_timestamp() to create a BC value Bryn Llewellyn
• 01:26   Re: Using make_timestamp() to create a BC value Adrian Klaver
• 01:28   Re: Using make_timestamp() to create a BC value Tom Lane
• 01:46   Re: Using make_timestamp() to create a BC value Bryn Llewellyn
• 09:17   Misplaced double quotes in error message Thomas Kellerer
• 11:19   AW: how to merge two postgresql server instances into one Marco Lechner
• 11:59   Re: AW: how to merge two postgresql server instances into one Heikki Pernu
• 16:39   Re: Misplaced double quotes in error message Adrian Klaver
• 16:52   Re: Misplaced double quotes in error message Sunil Thakur
• 17:12   Re: AW: how to merge two postgresql server instances into one Adrian Klaver
• 17:55   Re: Misplaced double quotes in error message Tom Lane
• 20:19   Re: DELETE ... USING LATERAL Nikhil Benesch
• 21:23   Re: Timestamp with vs without time zone. Bruce Momjian
• 21:38   Regression in PL/PGSQL code using RETURN QUERY with Postgres 14 Gavin Roy
• 21:47   Re: Currently running queries with actual arguments? Bruce Momjian
• 21:54   Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14 Adrian Klaver
• 22:05   Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14 Tom Lane
• 22:05   Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14 Gavin Roy
• 22:06   Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14 Gavin Roy
• 23:14   Re: Misplaced double quotes in error message Peter J. Holzer

8 October 2021

• 04:04   Re: create a new GIN index for my own type huangning290@yahoo.com
• 14:14   Gist fastbuild and performances talk to ben
• 14:42   Re: Gist fastbuild and performances Francisco Olarte
• 15:56   LDAP authorization with postgresql Keith Brown
• 16:52   Re: Gist fastbuild and performances talk to ben
• 17:33   Re: Gist fastbuild and performances Francisco Olarte
• 18:09   Re: Gist fastbuild and performances talk to ben
• 22:08   Re: LDAP authorization with postgresql Stephen Frost
• 23:01   Re: LDAP authorization with postgresql Keith Brown

9 October 2021

• 19:01   Error: server closed the connection unexpectedly Anil
• 23:26   Re: Error: server closed the connection unexpectedly Adrian Klaver

10 October 2021

• 09:18   Re: Error: server closed the connection unexpectedly Ron
• 19:27   Re: Error: server closed the connection unexpectedly Adrian Klaver
• 20:26   Re: Error: server closed the connection unexpectedly Adrian Klaver
• 21:42   Re: Error: server closed the connection unexpectedly Anil
• 21:55   Re: Error: server closed the connection unexpectedly Ron
• 22:20   Re: Error: server closed the connection unexpectedly Tom Lane
• 22:30   Re: Error: server closed the connection unexpectedly Ron
• 23:00   Re: Error: server closed the connection unexpectedly Tom Lane
• 23:06   Re: Error: server closed the connection unexpectedly Ron
• 23:12   Re: Error: server closed the connection unexpectedly Adrian Klaver
• 23:17   Re: Error: server closed the connection unexpectedly Adrian Klaver

11 October 2021

• 00:26   Re: Error: server closed the connection unexpectedly Ron
• 07:17    Ken Wang
• 11:00   GIN index huangning290@yahoo.com
• 11:08   Re: Error: server closed the connection unexpectedly Laurenz Albe
• 15:28   Check Replication lag Pawan Sharma
• 15:52   Re: Check Replication lag hubert depesz lubaczewski
• 19:59   Re: Check Replication lag Pawan Sharma

12 October 2021

• 09:42   Avg/max size of these JSON docs in Postgres Ram Pratap Maurya
• 10:43   Re: Avg/max size of these JSON docs in Postgres Simon Riggs
• 19:31   Fault with initcap Shaozhong SHI
• 20:52   Aw: Re: Fault with initcap Karsten Hilbert
• 20:53   Re: Avg/max size of these JSON docs in Postgres Michael Lewis
• 21:14   Re: Avg/max size of these JSON docs in Postgres Tom Lane
• 21:51   Re: Avg/max size of these JSON docs in Postgres Simon Riggs
• 22:21   Re: Avg/max size of these JSON docs in Postgres Michael Lewis
• 22:34   Re: Fault with initcap Adrian Klaver
• 22:56   Aw: Re: Re: Fault with initcap Karsten Hilbert
• 23:50   Re: Fault with initcap Shaozhong SHI

13 October 2021

• 00:09   Re: Fault with initcap Karsten Hilbert
• 01:02   Re: Fault with initcap Adrian Klaver
• 01:07   Re: Avg/max size of these JSON docs in Postgres Tomas Vondra
• 02:03   Re: Fault with initcap Shaozhong SHI
• 03:27   Re: Fault with initcap Adrian Klaver
• 06:55   Re: Fault with initcap Lee Hachadoorian
• 10:40   Re: Avg/max size of these JSON docs in Postgres Simon Riggs
• 12:04   Grant select for all tables of the 12 schemas of my one db ? celati Laurent
• 12:52   Re: Grant select for all tables of the 12 schemas of my one db ? hubert depesz lubaczewski
• 13:03   Re: Grant select for all tables of the 12 schemas of my one db ? Vijaykumar Jain
• 14:00   Re: Grant select for all tables of the 12 schemas of my one db ? hubert depesz lubaczewski
• 14:14   Re: Grant select for all tables of the 12 schemas of my one db ? Vijaykumar Jain
• 18:34   Detecting mis-planning of repeated application of a projection step pbj@cmicdo.com
• 18:42   Re: Detecting mis-planning of repeated application of a projection step Tom Lane
• 19:09   Replication between different architectures Phil Endecott
• 20:07   Re: Replication between different architectures hubert depesz lubaczewski
• 22:41   Re: Replication between different architectures Tom Lane

14 October 2021

• 00:19   Re: GIN index Tomas Vondra
• 02:09   NOTIFY queue is at 66% and climbing... Jeff Ross
• 02:12   Re: Replication between different architectures Phil Endecott
• 02:50   Re: NOTIFY queue is at 66% and climbing... Tom Lane
• 06:02   RE: Duplicate key in UUID primary key index... Eric Tobias
• 09:21   ask for help：I want to compile a dynamic library file, such as libpsqlodbc w.so 张进涛
• 12:12   Postresql/postgis/qgis : assign privileges only for access/reading tables ? celati Laurent
• 12:21   RSYNC YUM Mirror for pg14 not available yet Dennis Schwan
• 13:04   Re: Duplicate key in UUID primary key index... Peter J. Holzer
• 15:34   Certificate validity error download.postgresql.org Cedric Rey
• 15:56   RE: Duplicate key in UUID primary key index... Eric Tobias
• 16:00   JOB | DBA (Canada) James Tobin
• 16:00   Re: Certificate validity error download.postgresql.org Daniel Gustafsson
• 16:28   Re: Certificate validity error download.postgresql.org Christoph Moench-Tegeder
• 17:22   Re: JOB | DBA (Canada) Chris Travers
• 17:34   RE: Certificate validity error download.postgresql.org Cedric Rey
• 17:39   Re: NOTIFY queue is at 66% and climbing... Jeff Ross
• 17:51   Re: Certificate validity error download.postgresql.org Tom Lane
• 18:36   Re: JOB | DBA (Canada) Gavin Flower
• 18:49   RE: Certificate validity error download.postgresql.org Cedric Rey
• 19:34   Re: JOB | DBA (Canada) Chris Travers
• 20:13   Re: Certificate validity error download.postgresql.org Tom Lane
• 22:41   Conditional Tables in Postgres Mubashir Anwar

15 October 2021

• 00:15   Re: Conditional Tables in Postgres Imre Samu
• 02:38   "two time periods with only an endpoint in common do not overlap" ??? Bryn Llewellyn
• 02:54   Re: "two time periods with only an endpoint in common do not overlap" ??? Tom Lane
• 03:02   Re: "two time periods with only an endpoint in common do not overlap" ??? Adrian Klaver
• 03:24   Re: "two time periods with only an endpoint in common do not overlap" ??? David G. Johnston
• 05:49   Re: "two time periods with only an endpoint in common do not overlap" ??? Tom Lane
• 06:13   Re: "two time periods with only an endpoint in common do not overlap" ??? Bryn Llewellyn
• 06:47   Re: Postresql/postgis/qgis : assign privileges only for access/reading tables ? Ben Madin
• 15:21   PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe Nick Renders
• 15:53   Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe Maciek Sakrejda
• 16:13   Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe Alvaro Herrera
• 16:52   Re: "two time periods with only an endpoint in common do not overlap" ??? Ron
• 16:59   Re: "two time periods with only an endpoint in common do not overlap" ??? Adrian Klaver
• 17:01   Re: "two time periods with only an endpoint in common do not overlap" ??? Tom Lane
• 18:32   postgres ssl client certificate authentification Zwettler Markus (OIZ)
• 18:49   Re: postgres ssl client certificate authentification Tom Lane
• 19:33   Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe Tom Lane
• 20:08   Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe Tom Lane
• 20:50   Stuck: how can I disable automatic json array unwrapping? Seref Arikan
• 21:16   Re: "two time periods with only an endpoint in common do not overlap" ??? Ron
• 21:22   Re: "two time periods with only an endpoint in common do not overlap" ??? Rob Sargent
• 21:27   Re: "two time periods with only an endpoint in common do not overlap" ??? Brian Dunavant
• 22:26   Re: "two time periods with only an endpoint in common do not overlap" ??? Guyren Howe
• 22:28   Re: Stuck: how can I disable automatic json array unwrapping? Seref Arikan
• 23:01   Re: "two time periods with only an endpoint in common do not overlap" ??? Adrian Klaver

16 October 2021

• 05:42   Re: "two time periods with only an endpoint in common do not overlap" ??? Ron
• 07:08   Re: "two time periods with only an endpoint in common do not overlap" ??? Adrian Klaver
• 07:35   Re: "two time periods with only an endpoint in common do not overlap" ??? David G. Johnston
• 07:52   Re: "two time periods with only an endpoint in common do not overlap" ??? Ron
• 07:54   Re: "two time periods with only an endpoint in common do not overlap" ??? Ron
• 08:23   Re: "two time periods with only an endpoint in common do not overlap" ??? Tom Lane
• 08:41   Re: "two time periods with only an endpoint in common do not overlap" ??? David G. Johnston
• 11:31   Re: "two time periods with only an endpoint in common do not overlap" ??? Gavin Flower
• 13:50   Wrong sorting on docker image Oleksandr Voytsekhovskyy
• 15:32   Re: Wrong sorting on docker image Peter J. Holzer
• 18:42   Re: Wrong sorting on docker image Tom Lane
• 19:24   Re: "two time periods with only an endpoint in common do not overlap" ??? Adrian Klaver

17 October 2021

• 05:30   Re: Wrong sorting on docker image Thomas Munro
• 12:50   Re: "two time periods with only an endpoint in common do not overlap" ??? Francisco Olarte
• 18:12   Force re-compression with lz4 Florents Tselai
• 19:36   Re: Force re-compression with lz4 Ron
• 19:39   Re: Force re-compression with lz4 Ron
• 20:17   Re: Force re-compression with lz4 Magnus Hagander
• 20:28   Re: Force re-compression with lz4 Adrian Klaver
• 22:03   Re: Force re-compression with lz4 Florents Tselai
• 22:13   Re: Force re-compression with lz4 Florents Tselai
• 23:33   Re: Force re-compression with lz4 Daniel Verite

18 October 2021

• 08:18   Re: Force re-compression with lz4 Michael Paquier
• 09:46   Re: Force re-compression with lz4 Francisco Olarte
• 09:57   Re: Force re-compression with lz4 Florents Tselai
• 10:32   Re: Force re-compression with lz4 Michael Paquier
• 10:37   Re: Force re-compression with lz4 Magnus Hagander
• 14:42   Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe Nick Renders
• 16:41   Re: Force re-compression with lz4 Mladen Gogala
• 16:45   Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe Tom Lane
• 16:47   Debug PostgreSQL logical apply process Ramnivas Chaurasia
• 18:01   Re: Force re-compression with lz4 Adrian Klaver

19 October 2021

• 03:37   Unsynchronized parallel dumps from 13.3 replica produced by pg_dump Chris Williams
• 06:05   Re: Unsynchronized parallel dumps from 13.3 replica produced by pg_dump Tom Lane
• 06:39   Re: Unsynchronized parallel dumps from 13.3 replica produced by pg_dump Chris Williams
• 06:44   Where is the tsrange() function documented? Bryn Llewellyn
• 06:45   JSON query Scott Ribe
• 06:45   Re: Unsynchronized parallel dumps from 13.3 replica produced by pg_dump Tom Lane
• 06:47   Re: Where is the tsrange() function documented? David G. Johnston
• 07:02   Re: JSON query David G. Johnston
• 07:25   Re: Where is the tsrange() function documented? Adrian Klaver
• 07:27   Re: JSON query Scott Ribe
• 07:34   Re: Where is the tsrange() function documented? Bryn Llewellyn
• 08:11   Re: Where is the tsrange() function documented? Bryn Llewellyn
• 08:25   Where is the tsrange() function documented? David G. Johnston
• 10:19   connecting multiple INSERT CTEs to same record? Assaf Gordon
• 12:28   spannerdb migration to PostgreSQL Pawan Sharma
• 12:29   Re: Where is the tsrange() function documented? Alban Hertroys
• 16:24   Re: Force re-compression with lz4 Mladen Gogala
• 20:15   Connection queuing by connection pooling libraries Saurav Sarkar
• 20:39   Re: Connection queuing by connection pooling libraries Vijaykumar Jain
• 20:50   Re: Connection queuing by connection pooling libraries Vijaykumar Jain
• 20:59   Re: Where is the tsrange() function documented? Bryn Llewellyn
• 22:13   Re: connecting multiple INSERT CTEs to same record? David G. Johnston
• 22:31   How to rename in-use logical replication publication? Kristjan Mustkivi
• 22:36   Re: Connection queuing by connection pooling libraries Vijaykumar Jain

20 October 2021

• 01:50   Re: PostgreSQL 9.2 high replication lag - Part 2 Lucas
• 02:04   Relations between operators from pg_amop and classes of operators from pg_opclass Anna Rodionova
• 02:45   Re: connecting multiple INSERT CTEs to same record? Assaf Gordon
• 04:02   Re: Relations between operators from pg_amop and classes of operators from pg_opclass Tom Lane
• 14:33   Re: How to rename in-use logical replication publication? Kristjan Mustkivi
• 17:38   Can db user change own password? Toomas
• 17:45   Re: Can db user change own password? Adrian Klaver
• 17:56   Selectivity and row count estimates for JSONB columns Joel Perren
• 18:07   Re: Can db user change own password? Toomas
• 18:22   Re: Can db user change own password? Adrian Klaver
• 18:43   Re: Can db user change own password? Vijaykumar Jain
• 19:08   Re: Selectivity and row count estimates for JSONB columns Joel Perren
• 23:29   pg_class.oid at 4B Radoslav Nedyalkov
• 23:39   Re: pg_class.oid at 4B David G. Johnston

21 October 2021

• 00:20   Re: pg_class.oid at 4B Tom Lane
• 00:46   Re: Can we get rid of repeated queries from pg_dump? Tom Lane
• 08:53   Re: pg_class.oid at 4B Laurenz Albe
• 13:52   Re: Can we get rid of repeated queries from pg_dump? hubert depesz lubaczewski
• 18:39   Re: Can db user change own password? Toomas
• 19:13   Re: Can db user change own password? Adrian Klaver
• 19:53   Re: Can db user change own password? Tom Lane
• 20:29   Re: Can db user change own password? Adrian Klaver
• 20:32   Re: Can db user change own password? Toomas
• 20:44   Re: Can db user change own password? Tom Lane
• 20:51   Re: Can db user change own password? Tom Lane
• 21:33   Re: Connection queuing by connection pooling libraries Saurav Sarkar
• 22:49   Re: Can db user change own password? Adrian Klaver
• 22:52   Re: Can db user change own password? Adrian Klaver
• 22:52   Looking for a doc section that presents the overload selection rules Bryn Llewellyn
• 23:14   PGConf.NYC: Call for Volunteers Andreas 'ads' Scherbaum
• 23:19   Re: Looking for a doc section that presents the overload selection rules David G. Johnston
• 23:23   WAL streaming and dropping a large table Rory Falloon
• 23:36   Re: Looking for a doc section that presents the overload selection rules Adrian Klaver

22 October 2021

• 01:45   Re: Looking for a doc section that presents the overload selection rules Bryn Llewellyn
• 03:15   Re: Looking for a doc section that presents the overload selection rules Adrian Klaver
• 03:42   Re: Looking for a doc section that presents the overload selection rules Bryn Llewellyn
• 11:11   [Major version upgrade] pg_upgrade fails despite passing check mode Abhishek Bhola
• 16:02   Re: Error: server closed the connection unexpectedly Sachin Kotwal
• 18:12   Re: spannerdb migration to PostgreSQL Ninad Shah
• 18:40   Issue with pg_basebackup v.11 Ninad Shah
• 18:49   Re: Looking for a doc section that presents the overload selection rules Adrian Klaver
• 19:09   Re: Issue with pg_basebackup v.11 Tom Lane
• 20:26   Re: Looking for a doc section that presents the overload selection rules Bryn Llewellyn
• 20:48   Re: Looking for a doc section that presents the overload selection rules Tom Lane
• 20:51   Re: Looking for a doc section that presents the overload selection rules Adrian Klaver
• 21:16   Re: Looking for a doc section that presents the overload selection rules Rob Sargent
• 21:16   Re: Looking for a doc section that presents the overload selection rules David G. Johnston
• 21:39   Re: Looking for a doc section that presents the overload selection rules Bryn Llewellyn
• 21:41   Re: Looking for a doc section that presents the overload selection rules Bryn Llewellyn

23 October 2021

• 00:09   Re: Looking for a doc section that presents the overload selection rules Peter J. Holzer
• 05:58   Python3 for PostgreSQL 14 Дмитрий Иванов
• 06:33   Re: Issue with pg_basebackup v.11 Ninad Shah
• 07:04   Re: Python3 for PostgreSQL 14 Adrian Klaver
• 14:29   ZFS filesystem - supported ? Laura Smith
• 15:41   Re: WAL streaming and dropping a large table Mladen Gogala
• 16:03   Re: ZFS filesystem - supported ? Mladen Gogala
• 16:37   Re: ZFS filesystem - supported ? Laura Smith
• 17:42   Re: Issue with pg_basebackup v.11 Tom Lane
• 20:48   Re: ZFS filesystem - supported ? Mladen Gogala
• 23:00   Re: Python3 for PostgreSQL 14 Дмитрий Иванов
• 23:40   Re: Python3 for PostgreSQL 14 Adrian Klaver

24 October 2021

• 05:36   Re: Python3 for PostgreSQL 14 Дмитрий Иванов
• 06:12   Re: ZFS filesystem - supported ? Lucas
• 07:13   Re: ZFS filesystem - supported ? Mladen Gogala
• 16:39   Re: ZFS filesystem - supported ? Laura Smith

25 October 2021

• 01:52   Re: [Major version upgrade] pg_upgrade fails despite passing check mode Abhishek Bhola
• 11:18   Re: ZFS filesystem - supported ? Laurenz Albe
• 14:08   Re: Issue with pg_basebackup v.11 Ninad Shah
• 20:13   Re: ZFS filesystem - supported ? Stephen Frost
• 20:53   Re: ZFS filesystem - supported ? Chris Travers
• 21:09   Re: ZFS filesystem - supported ? Mladen Gogala
• 22:43   Re: ZFS filesystem - supported ? E-BLOKOS
• 22:59   Re: ZFS filesystem - supported ? Lucas
• 23:40   Re: ZFS filesystem - supported ? Mladen Gogala

26 October 2021

• 01:01   Re: ZFS filesystem - supported ? Robert L Mathews
• 03:18   Re: ZFS filesystem - supported ? Benedict Holland
• 05:33   plpython3 package installation problem Yi Sun
• 09:04   How to copy rows into same table efficiently Arun Suresh
• 09:09   Need recommendation on PARALLEL INDEX SCAN and PARALLEL APPEND Vivekk P
• 10:05   Determining if a table really changed in a trigger Mitar
• 10:18   Re: Need recommendation on PARALLEL INDEX SCAN and PARALLEL APPEND Vijaykumar Jain
• 12:05   Re: How to copy rows into same table efficiently Ron
• 12:23   Re: ZFS filesystem - supported ? Bob Jolliffe
• 12:35   Re: ZFS filesystem - supported ? Laura Smith
• 13:34   Re: plpython3 package installation problem Devrim Gündüz
• 14:05   Re: ZFS filesystem - supported ? E-BLOKOS
• 16:17   Re: Determining if a table really changed in a trigger David G. Johnston
• 16:23   Re: How to copy rows into same table efficiently David G. Johnston
• 16:36   Re: Determining if a table really changed in a trigger Marcos Pegoraro
• 16:45   Re: Determining if a table really changed in a trigger Miles Elam
• 17:05   Re: Determining if a table really changed in a trigger Alban Hertroys
• 17:16   Re: Determining if a table really changed in a trigger Marcos Pegoraro
• 17:39   Re: Determining if a table really changed in a trigger Alban Hertroys
• 19:58   Need help understanding error message Rich Shepard
• 20:07   Re: Need help understanding error message Rob Sargent
• 20:14   Re: Need help understanding error message Ron
• 21:00   Re: Need help understanding error message Rob Sargent
• 21:05   Re: Need help understanding error message Rich Shepard
• 21:06   Re: Need help understanding error message Rich Shepard
• 21:14   Re: Need help understanding error message Rob Sargent
• 21:15   Re: Need help understanding error message Rob Sargent
• 21:16   Re: Need help understanding error message Rich Shepard
• 21:17   Re: Need help understanding error message [RESOLVED] Rich Shepard
• 22:22   Re: Determining if a table really changed in a trigger Mitar
• 22:48   Re: [Major version upgrade] pg_upgrade fails despite passing check mode Bruce Momjian
• 23:01   Re: ZFS filesystem - supported ? Bruce Momjian
• 23:17   Re: Determining if a table really changed in a trigger Mark Dilger
• 23:34   Re: Determining if a table really changed in a trigger Mitar
• 23:55   Re: Determining if a table really changed in a trigger Mark Dilger

27 October 2021

• 01:21   Re: ZFS filesystem - supported ? Lucas
• 01:39   Re: Determining if a table really changed in a trigger Mitar
• 01:46   Re: Determining if a table really changed in a trigger Mark Dilger
• 02:01   Re: Determining if a table really changed in a trigger Michael Lewis
• 02:16   Re: Determining if a table really changed in a trigger Mark Dilger
• 02:32   Re: How to copy rows into same table efficiently Michael Lewis
• 02:42   Re: ZFS filesystem - supported ? Mladen Gogala
• 02:45   Re: Need recommendation on PARALLEL INDEX SCAN and PARALLEL APPEND Michael Lewis
• 03:12   Re: ZFS filesystem - supported ? E-BLOKOS
• 03:15   Re: Determining if a table really changed in a trigger Mitar
• 03:50   Re: ZFS filesystem - supported ? Mladen Gogala
• 03:50   Re: ZFS filesystem - supported ? Imre Samu
• 03:55   Re: ZFS filesystem - supported ? Mladen Gogala
• 04:26   Re: ZFS filesystem - supported ? Benedict Holland
• 04:56   Re: Determining if a table really changed in a trigger Michael Lewis
• 07:02   Re: Need help understanding error message [RESOLVED] Ron
• 07:08   Re: ZFS filesystem - supported ? Ron
• 07:33   Best options for tracking history of data? Guyren Howe
• 09:11   String comparison fails for some cases after migration Jayadevan M
• 09:19   Re: String comparison fails for some cases after migration Julien Rouhaud
• 09:19   Re: String comparison fails for some cases after migration Tom Lane
• 10:50   Re: Determining if a table really changed in a trigger Mitar
• 11:02   Re: Determining if a table really changed in a trigger Thomas Kellerer
• 13:48   Re: String comparison fails for some cases after migration Jayadevan M
• 13:56   Re: Determining if a table really changed in a trigger Marcos Pegoraro
• 14:27   pg_dump and pg_restore and foreign keys Tore Halvorsen
• 16:10   Re: Python3 for PostgreSQL 14 Magnus Hagander
• 16:27   Re: pg_dump and pg_restore and foreign keys Tom Lane
• 16:50   Re: pg_dump and pg_restore and foreign keys Tore Halvorsen
• 17:04   Re: pg_dump and pg_restore and foreign keys Tom Lane
• 17:06   Re: Determining if a table really changed in a trigger Mitar
• 17:08   Re: pg_dump and pg_restore and foreign keys Tore Halvorsen
• 18:51   psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13] Jérémy Garniaux
• 18:58   Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13] Adrian Klaver
• 19:01   Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13] Jérémy Garniaux
• 19:42   WAL File Recovery on Standby Server Stops Before End of WAL Files Ryan, Les
• 20:30   Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13] Adrian Klaver
• 21:06   Re: Strange sequences - how to construct? SQL Padawan
• 21:58   jsonb: unwrapping text 
• 22:39   Segmentation fault in volatile c function Louise Grandjonc
• 22:47   Re: Segmentation fault in volatile c function Peter Geoghegan
• 22:51   Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13] Jérémy Garniaux

28 October 2021

• 01:17   Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13] Adrian Klaver
• 01:44   Re: Segmentation fault in volatile c function Louise Grandjonc
• 02:18   Re: jsonb: unwrapping text David G. Johnston
• 04:58   Re: WAL File Recovery on Standby Server Stops Before End of WAL Files Kyotaro Horiguchi
• 07:29   Re: WAL File Recovery on Standby Server Stops Before End of WAL Files Dilip Kumar
• 11:53   Re: jsonb: unwrapping text tomas@tuxteam.de
• 13:58   database designs ERDs Zahid Rahman
• 15:23   Incremental backup Edu Gargiulo
• 15:58   Re: Incremental backup Ron
• 16:52   RE: WAL File Recovery on Standby Server Stops Before End of WAL Files Ryan, Les
• 17:44   How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8? Hilbert, Karin
• 17:45   Re: database designs ERDs Thomas Kellerer
• 18:04   Re: How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8? Tom Lane
• 18:05   Re: How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8? Adrian Klaver
• 18:06   Re: Incremental backup Ivan E. Panchenko
• 18:36   Re: Incremental backup Adrian Klaver
• 19:23   Re: Incremental backup Edu Gargiulo
• 19:25   Re: Incremental backup Ron
• 19:40   Re: Incremental backup Adrian Klaver
• 20:19   Re: Incremental backup Paul Jungwirth
• 20:51   Re: Incremental backup Ron
• 21:00   Re: Incremental backup Adrian Klaver
• 21:48   Re: Incremental backup Ron
• 22:06   Re: Incremental backup Adrian Klaver
• 22:23   Re: Incremental backup Ron
• 22:57   Model clause and SQL Padawan
• 23:00   Re: Model clause and SQL Padawan
• 23:08   Re: Incremental backup Bruce Momjian
• 23:43   Re: Incremental backup Adrian Klaver
• 23:44   Re: Model clause and Michael Lewis
• 23:47   Re: Model clause and Thomas Kellerer
• 23:56   Re: Model clause and Michael Lewis

29 October 2021

• 00:05   Re: Incremental backup Ron
• 00:09   Re: Incremental backup Ron
• 00:26   Re: How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8? Hilbert, Karin
• 01:07   Re: Incremental backup Andreas Joseph Krogh
• 01:24   Re: Incremental backup Ron
• 04:14   Re: Incremental backup Mladen Gogala
• 04:26   Re: database designs ERDs Zahid Rahman
• 04:44   Re: WAL File Recovery on Standby Server Stops Before End of WAL Files Kyotaro Horiguchi
• 08:57   Re: pg_dump and pg_restore and foreign keys Tore Halvorsen
• 10:30   Re: Incremental backup Peter J. Holzer
• 13:46   DBeaver does not show all tables in a Schema Shaozhong SHI
• 15:38   Re: Incremental backup Mladen Gogala
• 15:48   Re: DBeaver does not show all tables in a Schema Ron
• 15:49   Re: Incremental backup Peter J. Holzer
• 16:03   Re: Incremental backup Mladen Gogala
• 16:15   Re: DBeaver does not show all tables in a Schema negora
• 16:43   Re: Incremental backup Peter J. Holzer
• 16:47   Re: DBeaver does not show all tables in a Schema Shaozhong SHI
• 16:52   Re: DBeaver does not show all tables in a Schema Ryan Booz
• 17:01   Re: Incremental backup Thomas Kellerer
• 17:02   Postgres dblink example Pratik Mehta
• 17:14   Re: DBeaver does not show all tables in a Schema Shaozhong SHI
• 17:19   Re: Postgres dblink example Tom Lane
• 17:57   Re: Incremental backup Mladen Gogala
• 18:17   Re: Postgres dblink example Adrian Klaver
• 18:24   Re: DBeaver does not show all tables in a Schema Adrian Klaver
• 20:21   psql syntax for array of strings in a variable? Philip Semanchuk
• 20:22   Question: Is it possible to get the new xlog position after query execution? Oleg Serov
• 20:34   Re: psql syntax for array of strings in a variable? David G. Johnston
• 20:52   Re: psql syntax for array of strings in a variable? Pavel Stehule
• 21:05   Re: psql syntax for array of strings in a variable? Tom Lane
• 21:44   Re: psql syntax for array of strings in a variable? Philip Semanchuk

30 October 2021

• 11:55   Why does the OID jump by 3 when creating tables? Daniel Westermann (DWE)
• 12:51   Re: Why does the OID jump by 3 when creating tables? Guillaume Lelarge
• 13:20   Re: Why does the OID jump by 3 when creating tables? Daniel Westermann (DWE)
• 18:04   Re: Why does the OID jump by 3 when creating tables? Ron
• 19:31   Settings for a new machine - some guidance sought. SQL Padawan

31 October 2021

• 23:29   Re: Question: Is it possible to get the new xlog position after query execution? Peter J. Holzer