Mailing lists [pgsql-general]

1 November 2022

• 01:02   Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Peter J. Holzer
• 01:26   Autovacuum on Partitioned Tables Ryan Ruenroeng
• 04:27   Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Bryn Llewellyn
• 04:44   Delete a table automatic? 黄宁
• 06:19   Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Bryn Llewellyn
• 06:27   Re: Autovacuum on Partitioned Tables Ron
• 06:36   Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should David G. Johnston
• 07:05   Re: Autovacuum on Partitioned Tables Tom Lane
• 07:43   Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Bryn Llewellyn
• 08:03   Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn
• 08:48   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" David G. Johnston
• 09:01   Re: empty pg_stat_progress_vacuum Michael Paquier
• 09:48   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Laurenz Albe
• 09:51   Re: Autovacuum on Partitioned Tables Laurenz Albe
• 10:54   Re: Autovacuum on Partitioned Tables Ron
• 12:31   Re: Delete a table automatic? jian he
• 16:41   Re: Delete a table automatic? Rob Sargent
• 17:16   Re: Delete a table automatic? Peter J. Holzer
• 17:35   Re: Delete a table automatic? Adrian Klaver
• 18:11   Re: Delete a table automatic? MuraliPD@GMail
• 18:11   Re: Autovacuum on Partitioned Tables Ryan Ruenroeng
• 18:23   Re: Delete a table automatic? Tom Lane
• 19:05   Re: Autovacuum on Partitioned Tables Ron
• 19:13   SSL/TLS encryption without Ron
• 19:15   Aw: Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Karsten Hilbert
• 20:55   Re: SSL/TLS encryption without Peter J. Holzer
• 23:20   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn
• 23:39   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" David G. Johnston

2 November 2022

• 00:50   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" David G. Johnston
• 03:40   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Adrian Klaver
• 07:11   Migrating postgres client(libpq) library from 12.10 to 14(Need some information) M Tarkeshwar Rao
• 17:56   Reducing bandwidth usage of database replication  Sascha Zenglein
• 19:29   Re: Reducing bandwidth usage of database replication Ron

3 November 2022

• 01:31   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn
• 02:39   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Adrian Klaver
• 04:22   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" David G. Johnston
• 04:41   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" David G. Johnston
• 06:26   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Rob Sargent
• 09:48   unable to install postgreql 13.4 shashidhar Reddy
• 09:59   Re: unable to install postgreql 13.4 Julien Rouhaud
• 10:08   Re: unable to install postgreql 13.4 shashidhar Reddy
• 10:22   Re: unable to install postgreql 13.4 Julien Rouhaud
• 10:39   Re: unable to install postgreql 13.4 shashidhar Reddy
• 11:40   AW: Reducing bandwidth usage of database replication Sascha Zenglein
• 12:44   Postgres to edb AS, need conversion? milist ujang
• 14:43   Would postgresql add a pg_sleep_backend() method lz ma
• 16:04   Re: Postgres to edb AS, need conversion? Abdul Sayeed
• 16:10   Re: unable to install postgreql 13.4 Ron
• 17:28   pg_restore error on function Post Gresql
• 17:43   Re: pg_restore error on function Adrian Klaver
• 17:45   Re: pg_restore error on function Ron
• 17:57   Re: pg_restore error on function Adrian Klaver
• 18:28   Re: Reducing bandwidth usage of database replication Ben Chobot
• 18:35   Re: pg_restore error on function Post Gresql
• 18:38   Re: pg_restore error on function Post Gresql
• 18:52   Re: pg_restore error on function David G. Johnston
• 19:01   Re: pg_restore error on function Adrian Klaver
• 19:32   Re: pg_restore error on function Tom Lane
• 19:34   Re: pg_restore error on function Ron
• 20:38   Some questions about Postgres Siddharth Jain
• 20:42   Re: Some questions about Postgres Christophe Pettus
• 21:17   Re: Some questions about Postgres Siddharth Jain
• 23:55   shutdown Postgres (standby) host causing timeout on other servers in replication Joanna Xu

4 November 2022

• 00:49   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn
• 00:49   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn
• 01:37   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Adrian Klaver
• 01:49   Re: shutdown Postgres (standby) host causing timeout on other servers in replication Tom Lane
• 02:01   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Peter J. Holzer
• 04:46   Re: shutdown Postgres (standby) host causing timeout on other servers in replication Ron
• 04:50   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn
• 05:50   autovacuum hung on simple tables senor
• 07:12   Re: Postgres to edb AS, need conversion? milist ujang
• 07:41   Re: Postgres to edb AS, need conversion? Ron
• 07:42   Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Adrian Klaver
• 09:11   Unable to use pg_verify_checksums shashidhar Reddy
• 09:46   How to avoid intstantiating multiple JVM instances across different sessions to use FDW? ganggewang(王刚)
• 10:18   Re: Unable to use pg_verify_checksums Guillaume Lelarge
• 11:50   Re: autovacuum hung on simple tables Laurenz Albe
• 11:55   Re: Some questions about Postgres Laurenz Albe
• 12:16   Re: Reducing bandwidth usage of database replication Simon Riggs
• 12:19   Calculating average block write time Thomas Kellerer
• 12:20   Re: Reducing bandwidth usage of database replication Simon Riggs
• 12:25   AW: Reducing bandwidth usage of database replication Sascha Zenglein
• 13:08   Re: Unable to use pg_verify_checksums shashidhar Reddy

5 November 2022

• 01:59   Setting up replication on Windows, v9.4 Brad White
• 02:14   Is there a guide to use PostgresSQL as alternative to MariaDB/MySQL in OpenStack? Larry Sevilla
• 04:02   Re: Setting up replication on Windows, v9.4 Ian Lawrence Barwick
• 04:08   Re: Setting up replication on Windows, v9.4 Ian Lawrence Barwick
• 07:55   Re: Setting up replication on Windows, v9.4 Ron
• 09:50   Re: Is there a guide to use PostgresSQL as alternative to MariaDB/MySQL in OpenStack? Tony Shelver
• 15:18   Re: Postgres 15 upgrades and template1 public schema Bruno Wolff III
• 18:10   an difficult SQL Rafal Pietrak
• 21:05   Re: an difficult SQL Thiemo Kellner

6 November 2022

• 10:30   Re: Is there a guide to use PostgresSQL as alternative to MariaDB/MySQL in OpenStack? Larry Sevilla
• 14:18   server process (PID 2964738) was terminated by signal 11: Segmentation fault Stefan Froehlich
• 15:48   Re: an difficult SQL Rafal Pietrak
• 17:13   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Tom Lane
• 17:23   Re: an difficult SQL Erik Wienhold
• 17:35   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Stefan Froehlich
• 17:48   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Tom Lane
• 18:48   Re: an difficult SQL Rafal Pietrak
• 22:05   Re: Some questions about Postgres Siddharth Jain

7 November 2022

• 08:21   Re: AW: Reducing bandwidth usage of database replication Kyotaro Horiguchi
• 13:02   postgres replication without pg_basebackup? postgres 13.3 Pilar de Teodoro
• 13:17   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Stefan Froehlich
• 14:19   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Laurenz Albe
• 14:21   Re: postgres replication without pg_basebackup? postgres 13.3 Laurenz Albe
• 16:17   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Mladen Gogala
• 16:47   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Stefan Froehlich
• 17:02   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Tom Lane
• 17:05   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Stefan Froehlich
• 17:40   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Ron
• 18:43   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Tom Lane
• 18:51   Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Ron
• 19:16   AW: AW: Reducing bandwidth usage of database replication Sascha Zenglein
• 19:57   copy file from a client app to remote postgres isntance Вадим Самохин
• 20:29   Re: copy file from a client app to remote postgres isntance Rob Sargent
• 20:33   Segmentation Fault PG 14 Willian Colognesi
• 20:51   Re: copy file from a client app to remote postgres isntance Вадим Самохин
• 21:05   Re: copy file from a client app to remote postgres isntance Rob Sargent
• 21:08   Re: Segmentation Fault PG 14 Tom Lane
• 21:14   My account was locked in pgadmin4 William Torrez Corea
• 21:24   Re: copy file from a client app to remote postgres isntance Adrian Klaver
• 21:36   Re: Segmentation Fault PG 14 Willian Colognesi
• 21:49   Re: Segmentation Fault PG 14 Adrian Klaver
• 21:57   Re: Segmentation Fault PG 14 Willian Colognesi
• 22:00   Re: Segmentation Fault PG 14 Adrian Klaver
• 22:03   Re: Segmentation Fault PG 14 Willian Colognesi
• 22:36   Re: Segmentation Fault PG 14 Adrian Klaver
• 22:38   Re: Segmentation Fault PG 14 Tom Lane
• 23:15   Re: Segmentation Fault PG 14 Willian Colognesi
• 23:25   Re: Segmentation Fault PG 14 Adrian Klaver
• 23:29   Re: Segmentation Fault PG 14 Willian Colognesi
• 23:40   Re: copy file from a client app to remote postgres isntance Ron
• 23:59   Re: Setting up replication on Windows, v9.4 Brad White

8 November 2022

• 00:09   Re: Segmentation Fault PG 14 Tom Lane
• 00:42   Re: Setting up replication on Windows, v9.4 Rob Sargent
• 01:03   Feature suggestions for backup and replication da avory
• 01:11   Re: postgres replication without pg_basebackup? postgres 13.3 Pilar de Teodoro
• 01:45   Re: Segmentation Fault PG 14 Willian Colognesi
• 02:05   Re: Segmentation Fault PG 14 Tom Lane
• 02:47   Re: Segmentation Fault PG 14 Jeffrey Walton
• 04:24   PCI:SSF - Safe SQL Query & operators filter Jan Bilek
• 04:29   Re: PCI:SSF - Safe SQL Query & operators filter Christophe Pettus
• 04:43   Re: PCI:SSF - Safe SQL Query & operators filter Jan Bilek
• 04:50   Re: PCI:SSF - Safe SQL Query & operators filter Christophe Pettus
• 04:51   Re: PCI:SSF - Safe SQL Query & operators filter David G. Johnston
• 05:06   Re: PCI:SSF - Safe SQL Query & operators filter Jeffrey Walton
• 06:19   Re: PCI:SSF - Safe SQL Query & operators filter Laurenz Albe
• 06:27   Re: postgres replication without pg_basebackup? postgres 13.3 Laurenz Albe
• 07:14   Re: PCI:SSF - Safe SQL Query & operators filter Jan Bilek
• 07:15   Re: My account was locked in pgadmin4 Ashesh Vashi
• 10:03   Re: PCI:SSF - Safe SQL Query & operators filter Laurenz Albe
• 10:10   Re: Segmentation Fault PG 14 Thomas Munro
• 10:35   Re: PCI:SSF - Safe SQL Query & operators filter Jan Bilek
• 11:49   for integer/bigint type while format to scientific notation, automatically get the correct number of precision jian he
• 13:50   Information to CVE-2022-42889 Cedric Aaron Towstyka
• 14:21   Re: Segmentation Fault PG 14 Willian Colognesi
• 14:27   Re: Information to CVE-2022-42889 Erik Wienhold
• 14:33   Aw: Information to CVE-2022-42889 Karsten Hilbert
• 16:02   Re: Feature suggestions for backup and replication Ron
• 16:16   Q: pg_hba.conf separate database names file format Albrecht Dreß
• 17:05   Re: Information to CVE-2022-42889 Imre Samu
• 19:40   Re: Segmentation Fault PG 14 Willian Colognesi
• 20:16   Re: Segmentation Fault PG 14 Tom Lane

9 November 2022

• 03:16   "set role" semantics Bryn Llewellyn
• 03:24   Re: "set role" semantics David G. Johnston
• 04:02   Re: "set role" semantics Adrian Klaver
• 04:27   escaping double-quotes in varchar array David Gauthier
• 04:38   Re: escaping double-quotes in varchar array David G. Johnston
• 08:19   Re: Q: pg_hba.conf separate database names file format Michael Paquier
• 10:46   write an analyze_function for own type 黄宁
• 13:02   Re: Q: pg_hba.conf separate database names file format Ron
• 14:11   Unnecessary locks for partitioned tables 
• 14:45   Q: documentation improvement re collation version mismatch Karsten Hilbert
• 16:14   Re: Unnecessary locks for partitioned tables Laurenz Albe
• 16:40   RE: Unnecessary locks for partitioned tables 
• 17:29   Re: Unnecessary locks for partitioned tables Tom Lane
• 18:11   RE: Unnecessary locks for partitioned tables 
• 19:15   Re: copy file from a client app to remote postgres isntance Peter J. Holzer
• 19:17   Re: copy file from a client app to remote postgres isntance Peter J. Holzer
• 21:29   Re: Unnecessary locks for partitioned tables David Rowley
• 21:55   Re: "set role" semantics Bryn Llewellyn
• 21:57   Re: copy file from a client app to remote postgres isntance Ron
• 22:22   Re: "set role" semantics Guillaume Lelarge
• 22:22   Re: "set role" semantics David G. Johnston
• 22:22   Re: "set role" semantics Adrian Klaver
• 22:27   Re: "set role" semantics Adrian Klaver
• 22:29   Re: "set role" semantics David G. Johnston
• 23:31   Re: "set role" semantics Bryn Llewellyn
• 23:53   Re: "set role" semantics Adrian Klaver

10 November 2022

• 01:32   Re: copy file from a client app to remote postgres isntance Peter J. Holzer
• 02:23   Re: "set role" semantics Bryn Llewellyn
• 07:23   Re: Q: pg_hba.conf separate database names file format Michael Paquier
• 07:40   List user databases Igor Korot
• 07:57   Re: List user databases Ian Lawrence Barwick
• 08:16   Re: List user databases Adrian Klaver
• 08:18   Re: "set role" semantics Adrian Klaver
• 08:22   Re: List user databases Julien Rouhaud
• 09:13   Re: "set role" semantics Bryn Llewellyn
• 09:25   Re: List user databases Ian Lawrence Barwick
• 11:33   Re: Q: documentation improvement re collation version mismatch Julien Rouhaud
• 12:02   change analyze function for a array type 黄宁
• 13:47   Aw: Re: Q: documentation improvement re collation version mismatch Karsten Hilbert
• 14:36   Re: Q: documentation improvement re collation version mismatch Julien Rouhaud
• 17:04   Re: Q: documentation improvement re collation version mismatch Ron
• 17:33   Re: Q: documentation improvement re collation version mismatch Julien Rouhaud
• 17:39   Re: Q: documentation improvement re collation version mismatch Ron
• 17:50   Re: Q: documentation improvement re collation version mismatch Julien Rouhaud
• 18:48   pgadmin4 versions on Ubuntu 22.04 Richard Welty
• 18:58   Re: pgadmin4 versions on Ubuntu 22.04 Adrian Klaver
• 19:13   Re: copy file from a client app to remote postgres isntance Вадим Самохин
• 19:15   Re: pgadmin4 versions on Ubuntu 22.04 Richard Welty
• 19:19   Re: pgadmin4 versions on Ubuntu 22.04 Richard Welty
• 19:31   Re: pgadmin4 versions on Ubuntu 22.04 Adrian Klaver
• 20:36   Aw: Re: Q: documentation improvement re collation version mismatch Karsten Hilbert
• 22:52   IMMUTABLE function to cast enum to/from text? Philip Semanchuk
• 23:18   Re: IMMUTABLE function to cast enum to/from text? Joe Conway
• 23:39   Re: IMMUTABLE function to cast enum to/from text? Tom Lane

11 November 2022

• 02:33   Re: IMMUTABLE function to cast enum to/from text? Philip Semanchuk
• 05:47   get table oid in GIN extracequery function 黄宁
• 06:24   Re: Setting up replication on Windows, v9.4 Brad White
• 06:25   Re: Setting up replication on Windows, v9.4 Brad White
• 07:02   programmatically retrieve details of a custom Postgres type Konstantin Izmailov
• 07:09   Re: programmatically retrieve details of a custom Postgres type Pavel Stehule
• 07:10   Re: programmatically retrieve details of a custom Postgres type Tom Lane
• 07:30   Re: programmatically retrieve details of a custom Postgres type Tom Lane
• 09:13   reviving "custom" dump Rob Sargent
• 09:29   Re: reviving "custom" dump David G. Johnston
• 09:29   Re: reviving "custom" dump Tom Lane
• 09:35   Re: reviving "custom" dump Rob Sargent
• 09:47   Re: reviving "custom" dump Rob Sargent
• 18:33   Re: programmatically retrieve details of a custom Postgres type Konstantin Izmailov
• 18:42   change Log language fernando violante
• 18:56   Re: change Log language Tom Lane
• 19:39   Re: pgadmin4 versions on Ubuntu 22.04 Richard Welty
• 20:09   pg_isready mandatory parameters? Zwettler Markus (OIZ)
• 20:09   Table : Bloat grow high  Alexis Zapata
• 20:21   Re: pg_isready mandatory parameters? Jeffrey Walton
• 20:27   Re: pg_isready mandatory parameters? Tom Lane
• 21:38   Re: Setting up replication on Windows, v9.4 Ron
• 21:46   Re: Table : Bloat grow high Ron
• 23:35   Re: Setting up replication on Windows, v9.4 Brad White
• 23:43   Upgrading to v12 Brad White
• 23:50   Re: Setting up replication on Windows, v9.4 Ron

12 November 2022

• 00:02   Re: Upgrading to v12 Adrian Klaver
• 00:05   Re: Upgrading to v12 Brad White
• 00:11   Re: Upgrading to v12 Brad White
• 00:16   Re: Upgrading to v12 Tom Lane
• 00:17   Re: Upgrading to v12 Adrian Klaver
• 00:42   Re: Upgrading to v12 Brad White
• 01:06   Re: Upgrading to v12 Brad White
• 01:27   Re: Upgrading to v12 Tom Lane
• 03:11   Re: Upgrading to v12 Adrian Klaver
• 05:41   Re: Upgrading to v12 Brad White
• 05:43   Re: Upgrading to v12 Brad White
• 06:57   Re: Upgrading to v12 Adrian Klaver
• 07:59   Re: Upgrading to v12 Brad White
• 08:07   Printf-like function Igor Korot
• 08:09   Re: Upgrading to v12 Adrian Klaver
• 08:12   Re: Printf-like function Tom Lane
• 08:13   Re: Printf-like function Igor Korot
• 11:44   Re: Upgrading to v12 Ron
• 17:05   Re: Table : Bloat grow high Laurenz Albe
• 17:24   Re: Table : Bloat grow high Ron
• 20:54   Re: Table : Bloat grow high Peter J. Holzer

13 November 2022

• 05:06   Re: Upgrading to v12 Brad White
• 05:07   Re: Upgrading to v12 Brad White
• 05:12   Re: Upgrading to v12 Brad White
• 05:18   Re: Upgrading to v12 Brad White
• 08:30   Re: Upgrading to v12 Ron
• 09:07   Re: Upgrading to v12 Tom Lane
• 17:50   RE: Table : Bloat grow high Alexis Zapata
• 19:09   How to check stream replication latest history status 徐志宇徐
• 19:46   Re: Upgrading to v12 Adrian Klaver
• 19:51   Re: Upgrading to v12 Adrian Klaver
• 23:15   Re: Table : Bloat grow high Laurenz Albe
• 23:35   ON CONFLICT and WHERE Adrian Klaver
• 23:45   Q: fixing collation version mismatches Karsten Hilbert
• 23:46   Re: Q: fixing collation version mismatches Christophe Pettus
• 23:54   Re: Setting up replication on Windows, v9.4 Ron

14 November 2022

• 00:07   Re: ON CONFLICT and WHERE Tom Lane
• 00:24   Re: ON CONFLICT and WHERE Adrian Klaver
• 00:33   Re: ON CONFLICT and WHERE Peter Geoghegan
• 00:58   Re: Q: fixing collation version mismatches Karsten Hilbert
• 08:10   Re: Q: fixing collation version mismatches Julien Rouhaud
• 08:13   Re: Q: fixing collation version mismatches Julien Rouhaud
• 10:29   Re: ON CONFLICT and WHERE jian he
• 19:30   Phantom Permissions Error Upesh Desai
• 19:42   Re: Q: fixing collation version mismatches Daniel Verite
• 20:31   Re: Q: fixing collation version mismatches Karsten Hilbert

15 November 2022

• 00:04   PANIC: could not flush dirty data: Cannot allocate memory klaus.mailinglists@pernau.at
• 00:29   Re: PANIC: could not flush dirty data: Cannot allocate memory Tom Lane
• 00:54   Re: PANIC: could not flush dirty data: Cannot allocate memory Christoph Moench-Tegeder
• 06:03   Re: PANIC: could not flush dirty data: Cannot allocate memory Thomas Munro
• 06:05   Re: How to check stream replication latest history status Kyotaro Horiguchi
• 07:05   Re: PANIC: could not flush dirty data: Cannot allocate memory Tom Lane
• 15:23   Re: PANIC: could not flush dirty data: Cannot allocate memory klaus.mailinglists@pernau.at
• 15:28   PostgreSQL server "idle in transaction" Matthias Apitz
• 18:08   Re: PostgreSQL server "idle in transaction" Adrian Klaver
• 18:28   Re: PostgreSQL server "idle in transaction" Tom Lane
• 18:46   Index not getting cleaned even though vacuum is running Karthik Jagadish (kjagadis)
• 20:44   Calling function from VFP changes character field to Memo Frank Cazabon
• 21:26   Re: Calling function from VFP changes character field to Memo Adrian Klaver
• 21:44   Re: Calling function from VFP changes character field to Memo Tom Lane
• 21:48   Re: Calling function from VFP changes character field to Memo Adrian Klaver
• 21:52   Re: Calling function from VFP changes character field to Memo Adrian Klaver
• 21:53   Re: Calling function from VFP changes character field to Memo Frank Cazabon
• 21:54   Re: Calling function from VFP changes character field to Memo Frank Cazabon
• 21:58   Re: Calling function from VFP changes character field to Memo Adrian Klaver
• 21:59   Re: Calling function from VFP changes character field to Memo Ron
• 22:07   Re: Calling function from VFP changes character field to Memo Frank Cazabon
• 22:10   Re: Calling function from VFP changes character field to Memo Frank Cazabon
• 22:55   Toast Tables, pg_repack, and AWS RDS Preston Hagar
• 23:55   Re: PANIC: could not flush dirty data: Cannot allocate memory Thomas Munro

16 November 2022

• 00:17   Re: PANIC: could not flush dirty data: Cannot allocate memory Christoph Moench-Tegeder
• 08:04   An I/O error occured while sending to the backend gzh
• 09:57   Re: An I/O error occured while sending to the backend Laurenz Albe
• 10:37   Re: An I/O error occured while sending to the backend gzh
• 11:23   unrecognized node type: 350 shashidhar Reddy
• 11:51   Re: PostgreSQL server "idle in transaction" Matthias Apitz
• 14:48   Re: unrecognized node type: 350 shashidhar Reddy
• 15:08   Re: pg_restore remap schema Fabrice Chapuis
• 15:25   Re: PostgreSQL server "idle in transaction" Matthias Apitz
• 15:56   Re: unrecognized node type: 350 Daniel Gustafsson
• 16:36   Re: pg_restore remap schema Guillaume Lelarge
• 16:48   Re: unrecognized node type: 350 shashidhar Reddy
• 17:23   Re: An I/O error occured while sending to the backend Rob Sargent
• 17:27   Re: unrecognized node type: 350 Tom Lane
• 17:42   Re: pg_restore remap schema Tom Lane
• 17:58   Re: pg_restore remap schema Stéphane Tachoires
• 18:10   Re: pg_restore remap schema Tom Lane
• 18:14   Re: pg_restore remap schema Thomas Kellerer
• 18:55   Re: unrecognized node type: 350 shashidhar Reddy
• 19:02   Re: unrecognized node type: 350 Tom Lane
• 19:06   Re: unrecognized node type: 350 shashidhar Reddy
• 19:18   Re: unrecognized node type: 350 Tom Lane
• 19:33   Re: unrecognized node type: 350 shashidhar Reddy
• 19:36   Re: unrecognized node type: 350 Tom Lane
• 20:16   Re: PANIC: could not flush dirty data: Cannot allocate memory Andres Freund
• 20:28   Re: PANIC: could not flush dirty data: Cannot allocate memory Andres Freund
• 20:42   Re: PostgreSQL server "idle in transaction" Adrian Klaver
• 21:01   Re: unrecognized node type: 350 shashidhar Reddy
• 21:21   Re: unrecognized node type: 350 Tom Lane
• 21:25   Re: unrecognized node type: 350 Pavel Stehule
• 21:52   Re: unrecognized node type: 350 Tom Lane

17 November 2022

• 06:13   Re: unrecognized node type: 350 Pavel Stehule
• 08:18   Re: unrecognized node type: 350 shashidhar Reddy
• 08:24   Re: unrecognized node type: 350 Pavel Stehule
• 08:55   Re: unrecognized node type: 350 shashidhar Reddy
• 09:04   Re: unrecognized node type: 350 Pavel Stehule
• 09:22   Re: unrecognized node type: 350 shashidhar Reddy
• 14:36   Re: MERGE output doubt Alvaro Herrera
• 15:20   replication phisical + logical Giovanni Biscontini
• 15:32   Re: unrecognized node type: 350 shashidhar Reddy
• 16:30   Configure StopWords in full text search without a configuration file? Florian Fuchs
• 16:57   Re: unrecognized node type: 350 Pavel Stehule
• 17:02   Re: unrecognized node type: 350 shashidhar Reddy
• 17:52   Re: unrecognized node type: 350 Pavel Stehule
• 18:11   session_user different from current_user after normal login Murillo corvino rocha
• 18:23   Re: Configure StopWords in full text search without a configuration file? Laurenz Albe
• 18:45   Postgresql 11.3 doesn't use gist index on polygon column Вадим Самохин
• 18:49   Re: pg_restore remap schema Fabrice Chapuis
• 18:52   Re: Postgresql 11.3 doesn't use gist index on polygon column Tom Lane
• 20:35   Re: session_user different from current_user after normal login Adrian Klaver
• 20:42   Re: Postgresql 11.3 doesn't use gist index on polygon column Вадим Самохин
• 20:57   Re: MERGE output doubt Alvaro Herrera
• 22:36   Seeking practice recommendation: is there ever a use case to have two or more superusers? Bryn Llewellyn

18 November 2022

• 00:26   RES: session_user different from current_user after normal login Murillo corvino rocha
• 01:30   Duda sobre como imprimir un campo INTERVAL Alejandro Baeza Rangel
• 01:54   Re: RES: session_user different from current_user after normal login Adrian Klaver
• 02:07   Drop role cascade ? David Gauthier
• 02:16   Re: Drop role cascade ? Adrian Klaver
• 02:16   Re: Drop role cascade ? Tom Lane
• 02:44   Re: Drop role cascade ? Ron
• 02:53   RES: session_user different from current_user after normal login Murillo corvino rocha
• 02:57   Re: Drop role cascade ? Tom Lane
• 03:14   Re: Drop role cascade ? Ron
• 06:25   Re: An I/O error occured while sending to the backend gzh
• 08:34   Re: Drop role cascade ? Andreas Kretschmer
• 09:13   Re: Drop role cascade ? Ron
• 13:11   Re: Calculating average block write time Thomas Kellerer
• 15:33   copy databases from two differend backups to one cluster Joseph Kennedy
• 17:31   Re: RES: session_user different from current_user after normal login Tom Lane
• 18:31   Re: copy databases from two differend backups to one cluster Ron
• 18:51   Re: Calculating average block write time Laurenz Albe
• 19:14   Re: Calculating average block write time Ron
• 19:18   Re: copy databases from two differend backups to one cluster Adrian Klaver
• 19:24   Re: Calculating average block write time Tom Lane
• 20:30   Re: Calculating average block write time Thomas Kellerer
• 23:01   Appetite for `SELECT ... EXCLUDE`? Nikhil Benesch
• 23:08   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Peter J. Holzer
• 23:18   Re: Appetite for `SELECT ... EXCLUDE`? Tom Lane
• 23:29   Re: Appetite for `SELECT ... EXCLUDE`? Nikhil Benesch
• 23:46   Lots of read activity on index only scan Peter J. Holzer
• 23:52   RES: RES: session_user different from current_user after normal login Murillo corvino rocha
• 23:59   Re: Lots of read activity on index only scan Tom Lane

19 November 2022

• 00:04   Re: RES: RES: session_user different from current_user after normal login Adrian Klaver
• 00:09   Re: Lots of read activity on index only scan Peter Geoghegan
• 00:09   Re: RES: RES: session_user different from current_user after normal login Tom Lane
• 00:11   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Bryn Llewellyn
• 00:38   Re: Lots of read activity on index only scan Peter J. Holzer
• 00:50   Re: Lots of read activity on index only scan Peter J. Holzer
• 01:13   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Peter J. Holzer
• 01:21   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Ron
• 02:13   Re: Lots of read activity on index only scan Peter Geoghegan
• 03:05   Re: Upgrading to v12 Brad White
• 03:30   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Mladen Gogala
• 03:34   Re: Upgrading to v12 Adrian Klaver
• 06:58   Re: Duda sobre como imprimir un campo INTERVAL Ken Tanzer
• 11:52   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Peter J. Holzer
• 13:39   Re: Duda sobre como imprimir un campo INTERVAL Alban Hertroys
• 23:37   Re: Duda sobre como imprimir un campo INTERVAL Ken Tanzer

20 November 2022

• 01:22   Re: Duda sobre como imprimir un campo INTERVAL Tom Lane

21 November 2022

• 04:48   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Bryn Llewellyn
• 05:32   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? David G. Johnston
• 08:20   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Adrian Klaver
• 14:40   Re: ERROR: could not find pathkey item to sort Vijaykumar Sampat Jain
• 16:35   Looking for onchain EVM Postgres port Myles Dear
• 18:25   Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak
• 18:58   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Tom Lane
• 19:01   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Dominique Devienne
• 20:12   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak
• 20:40   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Bryn Llewellyn
• 21:10   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Dominique Devienne
• 21:34   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Adrian Klaver
• 22:26   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? David G. Johnston
• 22:46   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Bryn Llewellyn

22 November 2022

• 00:36   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Adrian Klaver
• 02:05   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Bryn Llewellyn
• 02:31   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? David G. Johnston
• 03:04   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Gavan Schneider
• 03:30   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? Adrian Klaver
• 03:49   Re: Seeking practice recommendation: is there ever a use case to have two or more superusers? David G. Johnston
• 09:25   system variable can be edited by all user? chris navarroza
• 11:43   Re: system variable can be edited by all user? Laurenz Albe
• 17:23   copying json data and backslashes Alastair McKinley
• 18:15   Re: copying json data and backslashes Erik Wienhold
• 18:30   Re: copying json data and backslashes pbj@cmicdo.com
• 19:57   Re: system variable can be edited by all user? Adrian Klaver
• 20:39   Re: copying json data and backslashes Alastair McKinley
• 21:15   Re: copying json data and backslashes Peter J. Holzer
• 22:04   security label and indexes Ted Toth
• 22:11   Re: copying json data and backslashes pbj@cmicdo.com
• 22:39   Re: copying json data and backslashes Erik Wienhold
• 23:33   Re: security label and indexes Tom Lane
• 23:53   Re: Upgrading to v12 Brad White

23 November 2022

• 00:11   Puzzled by ROW constructor behaviour? Eagna
• 00:19   Re: Puzzled by ROW constructor behaviour? Steve Baldwin
• 00:19   Re: Upgrading to v12 Adrian Klaver
• 00:27   Re: Puzzled by ROW constructor behaviour? David G. Johnston
• 01:50   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Thomas Munro
• 06:50   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak
• 07:59   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak
• 11:49   Index filter instead of index condition w/ IN / ANY queries above certain set size Danny Shemesh
• 12:22   Re: Index filter instead of index condition w/ IN / ANY queries above certain set size Laurenz Albe
• 13:22   Fwd: Postgre und GIS Umstellung von MD5 auf SCUM SHA 256 Nikolas Hanry
• 13:23   Fwd: Change the auth. postgresql and GIS Nikolas Hanry
• 13:59   Planner choose to use big index instead of smaller one benj.dev@laposte.net
• 14:56   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Karsten Hilbert
• 16:38   Re: Index filter instead of index condition w/ IN / ANY queries above certain set size Danny Shemesh
• 17:24   Re: Index filter instead of index condition w/ IN / ANY queries above certain set size Laurenz Albe
• 17:25   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Laurenz Albe
• 17:29   Re: Index filter instead of index condition w/ IN / ANY queries above certain set size Tom Lane
• 18:31   table inheritance partition and indexes Ted Toth
• 19:16   Re: Fwd: Change the auth. postgresql and GIS Adrian Klaver
• 22:02   MERGE RETURNING Miles Elam
• 22:11   Re: MERGE RETURNING Simon Riggs
• 22:23   Re: Index filter instead of index condition w/ IN / ANY queries above certain set size Danny Shemesh
• 22:24   Re: table inheritance partition and indexes Ron
• 22:32   Re: Fwd: Postgre und GIS Umstellung von MD5 auf SCUM SHA 256 Peter Eisentraut
• 23:06   How to avoid having to run the GRANT command for newly added tables? Siddharth Jain
• 23:07   Re: How to avoid having to run the GRANT command for newly added tables? Christophe Pettus
• 23:13   Re: How to avoid having to run the GRANT command for newly added tables? Siddharth Jain
• 23:20   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak

24 November 2022

• 00:49   Re: table inheritance partition and indexes Ted Toth
• 01:01   Re: table inheritance partition and indexes Tom Lane
• 01:34   Re: table inheritance partition and indexes Ted Toth
• 02:02   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Andres Freund
• 02:11   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Tom Lane
• 03:41   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Andres Freund
• 04:28   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Tom Lane
• 04:55   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak
• 05:04   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak
• 05:13   Re: table inheritance partition and indexes David Rowley
• 05:22   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Andres Freund
• 05:32   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Andres Freund
• 05:57   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Tom Lane
• 07:26   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak
• 07:38   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak
• 10:36   Fwd: Change the auth. postgresql and GIS Nikolas Hanry
• 10:56   Why not set builder->next_phase_at=InvalidTransactionId in SnapBuildRestore function? zxwsbg
• 11:01   Why not set builder->next_phase_at=InvalidTransactionId in SnapBuildRestore function? zxwsbg
• 11:03   Re:Why not set builder->next_phase_at=InvalidTransactionId in SnapBuildRestore function? zxwsbg
• 13:06   About row locking ordering Ryo Yamaji (Fujitsu)
• 15:01   How to select unique records in PostgreSQL Rama Krishnan
• 17:45   Index-only scan not working when IN clause has 2 or more values Anna B.

25 November 2022

• 12:11   Re: About row locking ordering Kirk Wolak
• 14:04   [BeginnerQuestion]Why the postgres_fe.h not found? Wen Yi
• 16:34   Configure my pgadmin William Torrez Corea
• 17:50   Re: How to select unique records in PostgreSQL Ron
• 18:03   Re: table inheritance partition and indexes Ted Toth
• 18:05   Re: How to select unique records in PostgreSQL David G. Johnston
• 18:28   Re: Configure my pgadmin Adrian Klaver
• 18:31   Re: [BeginnerQuestion]Why the postgres_fe.h not found? Adrian Klaver
• 18:40   Re: Index-only scan not working when IN clause has 2 or more values Tom Lane
• 21:35   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak
• 23:56   How to create hot standby of Postgres 12/Debian 10.3 in Windows 11 Andrus

26 November 2022

• 02:45   Practical maximum max_locks_per_transaction? Ron
• 02:56   Re: Practical maximum max_locks_per_transaction? Tom Lane
• 10:33   Re: Practical maximum max_locks_per_transaction? Ron
• 12:14   Re: system variable can be edited by all user? Pierre Forstmann
• 19:06   WAL contains references to invalid pages in hot standby Andrus

27 November 2022

• 01:43   collect2: error: ld returned 1 exit status William Torrez Corea
• 01:59   Re: collect2: error: ld returned 1 exit status Rob Sargent
• 02:17   Re: collect2: error: ld returned 1 exit status William Torrez Corea
• 02:46   Re: collect2: error: ld returned 1 exit status Tom Lane
• 03:51   Re: collect2: error: ld returned 1 exit status William Torrez Corea
• 05:52   Re: collect2: error: ld returned 1 exit status William Torrez Corea
• 20:22   Get table catalog from pg_indexes Igor Korot
• 20:59   Re: Get table catalog from pg_indexes Erik Wienhold
• 21:42   Re: Get table catalog from pg_indexes Igor Korot
• 21:44   Re: Get table catalog from pg_indexes Christophe Pettus
• 21:53   Re: Get table catalog from pg_indexes Igor Korot
• 21:54   Re: Get table catalog from pg_indexes David G. Johnston
• 21:55   Re: Get table catalog from pg_indexes Christophe Pettus
• 21:55   Re: Get table catalog from pg_indexes Adrian Klaver
• 21:57   Re: Get table catalog from pg_indexes David G. Johnston

28 November 2022

• 00:31   Re: Get table catalog from pg_indexes Ron
• 00:55   Re: Get table catalog from pg_indexes Adrian Klaver
• 01:04   Re: Get table catalog from pg_indexes Igor Korot
• 01:10   Re: Get table catalog from pg_indexes Ron
• 01:11   Re: Get table catalog from pg_indexes Igor Korot
• 01:13   Re: Get table catalog from pg_indexes Igor Korot
• 01:20   Re: Get table catalog from pg_indexes Adrian Klaver
• 02:46   Re: Postgres upgrade 12 - issues with OIDs Venkata B Nagothi
• 03:16   Re: Postgres upgrade 12 - issues with OIDs David Rowley
• 07:05   Re: autovacuum hung on simple tables senor
• 09:04   Re: Get table catalog from pg_indexes Thomas Kellerer
• 10:53   Re: autovacuum hung on simple tables Laurenz Albe
• 13:17   Replicating an existing (huge) database Srinivasa T N
• 13:24   Re: Replicating an existing (huge) database Laurenz Albe
• 13:28   Re: Replicating an existing (huge) database Torsten Förtsch
• 15:37   how to implement add using upsert and trigger? yin.zhb@163.com
• 15:47   Re: how to implement add using upsert and trigger? Dominique Devienne
• 15:57   Re: Re: how to implement add using upsert and trigger? yin.zhb@163.com
• 16:09   Re[2]: Index-only scan not working when IN clause has 2 or more values Anna B.
• 16:26   Re: how to implement add using upsert and trigger? Pavel Luzanov
• 16:29   delete statement returning too many results Arlo Louis O'Keeffe
• 17:01   Standby restore_command j.emerlik
• 17:14   Re: Get table catalog from pg_indexes Ron
• 17:18   Re: delete statement returning too many results Ron
• 17:20   Re: Re: how to implement add using upsert and trigger? yin.zhb@163.com
• 17:34   Re: delete statement returning too many results David G. Johnston
• 20:11   Re: delete statement returning too many results Tom Lane

29 November 2022

• 01:22   Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... Kirk Wolak
• 03:02   Re: Upgrading to v12 Brad White
• 04:02   Re: Upgrading to v12 Tom Lane
• 05:23   Re: Upgrading to v12 Adrian Klaver
• 13:45   Re: PANIC: could not flush dirty data: Cannot allocate memory klaus.mailinglists@pernau.at
• 15:48   plpgsql_check_function issue after upgrade shashidhar Reddy
• 16:12   Re: plpgsql_check_function issue after upgrade Pavel Stehule
• 16:49   Re: plpgsql_check_function issue after upgrade shashidhar Reddy
• 18:19   #PGSQL Phriday #003 Pat Wright
• 18:37   Re: plpgsql_check_function issue after upgrade shashidhar Reddy
• 18:46   Re: delete statement returning too many results Harmen
• 19:28   Re: plpgsql_check_function issue after upgrade Pavel Stehule
• 19:31   Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Bruce Momjian
• 19:39   postgresql 13.1: precision of spatial operations Вадим Самохин
• 19:44   Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all David G. Johnston
• 20:01   Re: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Tom Lane
• 20:02   Re: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Bruce Momjian
• 20:35   Re: delete statement returning too many results Tom Lane
• 23:40   PostgreSQL extension for processing Graph queries (Apache AGE) Young Seung Andrew Ko
• 23:46   PostgreSQL extension for storing Graph data (Apache AGE) Young Seung Andrew Ko

30 November 2022

• 00:22   Re: postgresql 13.1: precision of spatial operations Ivan Panchenko
• 01:16   Re: delete statement returning too many results Kirk Wolak
• 03:38   Re: plpgsql_check_function issue after upgrade shashidhar Reddy
• 07:28   Re: plpgsql_check_function issue after upgrade Pavel Stehule
• 07:34   Re: plpgsql_check_function issue after upgrade Pavel Stehule
• 11:37   Re: PostgreSQL extension for processing Graph queries (Apache AGE) Alvaro Herrera
• 16:43   Finding free time period on non-continous tstzrange field values Amitabh Kant
• 16:50   Re: Finding free time period on non-continous tstzrange field values Marcos Pegoraro
• 17:13   Re: Finding free time period on non-continous tstzrange field values Amitabh Kant
• 18:40   postgres large database backup Atul Kumar
• 18:48   Re: postgresql 13.1: precision of spatial operations Вадим Самохин
• 19:24   Re: postgres large database backup Michael Loftis
• 20:31   Re: postgres large database backup Christophe Pettus
• 20:41   Re: postgres large database backup Vijaykumar Jain
• 20:51   Re: postgresql 13.1: precision of spatial operations Brad White
• 22:01   Re: postgres large database backup Mladen Gogala
• 22:06   Re: postgres large database backup Ron