Mailing lists [pgsql-general]

1 June 2024

• 13:53   Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound Ron Johnson
• 16:02   Proposing a PostgreSQL Independent Professionals Network Chris Travers

3 June 2024

• 08:06   Poor performance after restoring database from snapshot on AWS RDS Sam Kidman
• 10:19   Postgresql 16.3 Out Of Memory Radu Radutiu
• 13:12   Re: Postgresql 16.3 Out Of Memory Greg Sabino Mullane
• 13:32   Re: Postgresql 16.3 Out Of Memory Ron Johnson
• 14:41   Unexpected results from CALL and AUTOCOMMIT=off Victor Yegorov
• 17:40   Re: Unexpected results from CALL and AUTOCOMMIT=off Pierre Forstmann
• 18:15   Re: Unexpected results from CALL and AUTOCOMMIT=off Victor Yegorov
• 19:28   Re: Unexpected results from CALL and AUTOCOMMIT=off Tom Lane

4 June 2024

• 12:13   Purpose of pg_dump tar archive format? Ron Johnson
• 13:48   Re: Purpose of pg_dump tar archive format? Erik Wienhold
• 14:43   Re: Purpose of pg_dump tar archive format? Adrian Klaver
• 15:25   Re: Purpose of pg_dump tar archive format? Ron Johnson
• 15:33   Re: Purpose of pg_dump tar archive format? Adrian Klaver
• 16:53   Re: Purpose of pg_dump tar archive format? Tom Lane
• 17:06   Re: Purpose of pg_dump tar archive format? Adrian Klaver
• 17:40   Re: Purpose of pg_dump tar archive format? Shaheed Haque
• 17:55   Bugs details. Muhammad Salahuddin Manzoor
• 18:07   Re: Bugs details. Erik Wienhold
• 18:55   Re: Purpose of pg_dump tar archive format? Rob Sargent
• 19:15   Re: Purpose of pg_dump tar archive format? Ron Johnson
• 19:37   Re: Purpose of pg_dump tar archive format? Rob Sargent
• 19:47   Re: Purpose of pg_dump tar archive format? Gavin Roy
• 21:35   Re: Purpose of pg_dump tar archive format? Shaheed Haque
• 22:55   Questions on logical replication Koen De Groote
• 23:02   Re: Questions on logical replication Koen De Groote
• 23:05   Re: Questions on logical replication Adrian Klaver
• 23:36   Re: Purpose of pg_dump tar archive format? Ron Johnson

5 June 2024

• 06:25   Re: Long running query causing XID limit breach sud
• 06:36   Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir Meera Nair
• 07:08   Re: Long running query causing XID limit breach Simon Elbaz
• 07:39   Re: Long running query causing XID limit breach sud
• 08:16   Re: Postgresql 16.3 Out Of Memory Radu Radutiu
• 08:31   Re: Poor performance after restoring database from snapshot on AWS RDS Shammat
• 08:34   Variant (Untyped) parameter for function/procedure Durumdara
• 08:55   Re: Unable to connect to any data source for foreign server Russell Mercer
• 10:22   Re: Long running query causing XID limit breach Laurenz Albe
• 10:26   Re: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir Laurenz Albe
• 12:09   Re: Poor performance after restoring database from snapshot on AWS RDS Jeremy Smith
• 14:22   Re: Purpose of pg_dump tar archive format? Gavin Roy
• 15:01   Re: Variant (Untyped) parameter for function/procedure Adrian Klaver
• 17:50   Length returns NULL ? Marcos Pegoraro
• 19:07   Re: Length returns NULL ? Erik Wienhold
• 19:21   Re: Long running query causing XID limit breach yudhi s
• 20:24   how to tell if a pg version supports a linux distribution bruno vieira da silva
• 20:31   Re: how to tell if a pg version supports a linux distribution Adrian Klaver
• 20:35   Re: how to tell if a pg version supports a linux distribution Adrian Klaver
• 21:54   Re: Questions on logical replication Koen De Groote
• 22:19   Re: Questions on logical replication Adrian Klaver

6 June 2024

• 01:52   RE: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir Meera Nair
• 04:40   Re: Poor performance after restoring database from snapshot on AWS RDS Sam Kidman
• 08:41   Re: how to tell if a pg version supports a linux distribution Laurenz Albe
• 14:46   Can't Remote connection by IpV6 Marcelo Marloch
• 14:58   Re: Can't Remote connection by IpV6 Kashif Zeeshan
• 15:03   Re: Can't Remote connection by IpV6 Adrian Klaver
• 15:13   Re: Can't Remote connection by IpV6 Ron Johnson
• 16:25   Re: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir Ron Johnson
• 16:28   Oracle to Postgres - Transform Hash Partition David Barbour
• 16:38   Tables get stuck at srsubstate = f Avi Weinberg
• 18:41   Re: Oracle to Postgres - Transform Hash Partition Christoph Moench-Tegeder
• 18:47   Re: Can't Remote connection by IpV6 Alan Hodgson
• 19:02   Re: Can't Remote connection by IpV6 Adrian Klaver
• 22:19   Re: Questions on logical replication Koen De Groote

7 June 2024

• 01:45   RE: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir Meera Nair
• 01:54   PG 14 pg_basebackup accepts --compress=server-zst option Ron Johnson
• 04:20   Re: Questions on logical replication Kashif Zeeshan
• 04:27   Re: PG 14 pg_basebackup accepts --compress=server-zst option Kashif Zeeshan
• 04:32   Re: PG 14 pg_basebackup accepts --compress=server-zst option David G. Johnston
• 05:40   Re: Oracle to Postgres - Transform Hash Partition Muhammad Ikram
• 08:31   Re: Oracle to Postgres - Transform Hash Partition Laurenz Albe
• 11:04   PG16.1 security breach? Zwettler Markus (OIZ)
• 12:04   Re: PG 14 pg_basebackup accepts --compress=server-zst option Ron Johnson
• 12:13   Re: Poor performance after restoring database from snapshot on AWS RDS Ron Johnson
• 13:22   Re: PG16.1 security breach? Joe Conway
• 13:54   AW: [Extern] Re: PG16.1 security breach? Zwettler Markus (OIZ)
• 14:16   Re: PG16.1 security breach? David G. Johnston
• 14:32   Re: AW: [Extern] Re: PG16.1 security breach? Laurenz Albe
• 14:35   Re: AW: [Extern] Re: PG16.1 security breach? Adrian Klaver
• 14:42   PG16.1 security breach? David G. Johnston
• 15:15   Re: Questions on logical replication Adrian Klaver
• 15:33   Re: PG 14 pg_basebackup accepts --compress=server-zst option Tom Lane

8 June 2024

• 07:23   Creating big indexes Lok P
• 09:21   Re: Long running query causing XID limit breach sud
• 09:31   Question on pg_cron yudhi s
• 13:33   How to create efficient index in this scenario? veem v
• 14:59   Columnar Format Export in Postgres Sushrut Shivaswamy
• 16:23   Re: Question on pg_cron Ron Johnson
• 16:34   Re: Question on pg_cron yudhi s
• 17:40   Re: Questions on logical replication Koen De Groote
• 17:46   Re: Questions on logical replication Adrian Klaver
• 20:33   Re: Questions on logical replication Justin

9 June 2024

• 04:15   Re: How to create efficient index in this scenario? Lok P
• 04:51   Re: How to create efficient index in this scenario? veem v
• 05:06   Re: Creating big indexes sud
• 05:09   Re: Creating big indexes Lok P
• 06:27   Re: Question on pg_cron sud
• 08:09   Re: Creating big indexes Lok P
• 21:46   Fwd: lost master password Afa Jamal

10 June 2024

• 09:06   Re: Fwd: lost master password Laurenz Albe
• 09:06   Re: Fwd: lost master password Afa Jamal
• 09:13   Re: lost master password Kashif Zeeshan
• 09:16   Re: Fwd: lost master password Laurenz Albe
• 09:21   Re: PG16.1 security breach? Laurenz Albe
• 11:39   Question regarding automatically paused streaming replication Ian van der Linde
• 12:06   Vacuum backend with backend_xmin? Torsten Förtsch
• 14:02   Escaping single quotes with backslash seems not to work Ron Johnson
• 14:07   Re: Escaping single quotes with backslash seems not to work David G. Johnston
• 14:12   Re: Escaping single quotes with backslash seems not to work David G. Johnston
• 14:36   libpq v17 PQsocketPoll timeout is not granular enough Dominique Devienne
• 14:52   Re: Escaping single quotes with backslash seems not to work Ron Johnson
• 14:56   Re: Escaping single quotes with backslash seems not to work David G. Johnston
• 14:59   Re: Escaping single quotes with backslash seems not to work Ron Johnson
• 15:08   Re: Escaping single quotes with backslash seems not to work Tom Lane
• 15:19   Re: Escaping single quotes with backslash seems not to work Ron Johnson
• 15:38   Re: Escaping single quotes with backslash seems not to work Adrian Klaver
• 15:42   Re: Escaping single quotes with backslash seems not to work David G. Johnston
• 16:16   Re: Vacuum backend with backend_xmin? Laurenz Albe
• 16:18   Re: libpq v17 PQsocketPoll timeout is not granular enough Tom Lane
• 17:51   Re: Escaping single quotes with backslash seems not to work Ron Johnson
• 18:43   Re: libpq v17 PQsocketPoll timeout is not granular enough Dominique Devienne
• 18:50   Multiple tables row insertions from single psql input file Rich Shepard
• 19:17   Does trigger only accept functions? veem v
• 19:42   Re: Multiple tables row insertions from single psql input file Ron Johnson
• 20:02   Re: Multiple tables row insertions from single psql input file Torsten Förtsch
• 20:06   Re: Multiple tables row insertions from single psql input file Rich Shepard
• 20:11   Re: Multiple tables row insertions from single psql input file Rich Shepard
• 20:13   Re: libpq v17 PQsocketPoll timeout is not granular enough Adrian Klaver
• 20:20   Re: Does trigger only accept functions? Adrian Klaver
• 20:25   Re: Multiple tables row insertions from single psql input file Ron Johnson
• 20:52   Re: Escaping single quotes with backslash seems not to work Adrian Klaver
• 21:15   Re: Multiple tables row insertions from single psql input file David G. Johnston
• 21:27   Re: Multiple tables row insertions from single psql input file Peter J. Holzer
• 21:58   Re: Multiple tables row insertions from single psql input file Rich Shepard
• 22:00   Re: Multiple tables row insertions from single psql input file David G. Johnston
• 22:35   Re: Multiple tables row insertions from single psql input file [RESOLVED] Rich Shepard
• 22:57   Gaps in PK sequence numbers Rich Shepard
• 22:59   Re: libpq v17 PQsocketPoll timeout is not granular enough Thomas Munro
• 23:03   Re: Gaps in PK sequence numbers David G. Johnston
• 23:05   Re: Gaps in PK sequence numbers Christophe Pettus
• 23:49   Re: libpq v17 PQsocketPoll timeout is not granular enough Tom Lane

11 June 2024

• 01:10   Re: Gaps in PK sequence numbers [RESOLVED] Rich Shepard
• 01:13   Re: Gaps in PK sequence numbers Rich Shepard
• 01:21   Re: Gaps in PK sequence numbers [RESOLVED] Christophe Pettus
• 01:23   Re: Gaps in PK sequence numbers [RESOLVED] David G. Johnston
• 01:41   Re: Does trigger only accept functions? Laurenz Albe
• 03:27   Re: Vacuum backend with backend_xmin? Kashif Zeeshan
• 04:40   Re: Multiple tables row insertions from single psql input file Ron Johnson
• 06:55   autoanalyze / autovacuum vs manually executed "vacuum analyze" Shenavai, Manuel
• 07:19   Re: libpq v17 PQsocketPoll timeout is not granular enough Francisco Olarte
• 11:33   Re: Does trigger only accept functions? hubert depesz lubaczewski
• 12:28   Re: Gaps in PK sequence numbers [RESOLVED] Rich Shepard
• 15:05   Unexpected Backend PID reported by Notification Dominique Devienne
• 15:21   Re: Unexpected Backend PID reported by Notification Adrian Klaver
• 15:29   Re: Unexpected Backend PID reported by Notification David G. Johnston
• 18:22   Re: Creating big indexes sud
• 18:49   Re: Does trigger only accept functions? veem v
• 18:56   Re: Does trigger only accept functions? hubert depesz lubaczewski
• 19:20   Re: Does trigger only accept functions? veem v
• 19:46   Re: Does trigger only accept functions? Adrian Klaver
• 19:58   Re: Does trigger only accept functions? hubert depesz lubaczewski
• 21:15   DROP COLLATION vs pg_collation question Karsten Hilbert
• 21:38   Re: Questions on logical replication Koen De Groote
• 21:42   Re: Questions on logical replication Koen De Groote
• 22:11   Re: Oracle to Postgres - Transform Hash Partition - Thanks! David Barbour
• 22:25   Re: Does trigger only accept functions? Ron Johnson

12 June 2024

• 06:53   Re: Unexpected Backend PID reported by Notification Dominique Devienne
• 07:03   Re: DROP COLLATION vs pg_collation question Laurenz Albe
• 07:47   postgres table statistics Chandy G
• 08:27   Re: postgres table statistics Ron Johnson
• 09:54   Oracle Linux 9 Detected RPMs with RSA/SHA1 signature Hans Schou
• 14:34   Re: Oracle Linux 9 Detected RPMs with RSA/SHA1 signature Adrian Klaver
• 14:44   Re: postgres table statistics Shammat
• 15:34   Question about UNIX socket connections and SSL Casey & Gina
• 16:40   Re: Does trigger only accept functions? Isaac Morland
• 17:01   Re: Questions on logical replication Justin
• 19:13   Re: DROP COLLATION vs pg_collation question Karsten Hilbert
• 19:17   Re: Question about UNIX socket connections and SSL Tom Lane
• 19:32   Re: Question about UNIX socket connections and SSL Daniel Gustafsson
• 20:35   Re: PG16.1 security breach? David G. Johnston
• 20:46   Re: Question about UNIX socket connections and SSL Casey & Gina
• 21:11   Definging columns for INSERT statements Rich Shepard
• 21:28   UPDATE with multiple WHERE conditions Rich Shepard
• 21:31   Re: UPDATE with multiple WHERE conditions Muhammad Salahuddin Manzoor
• 21:34   Re: UPDATE with multiple WHERE conditions Rich Shepard
• 21:36   Re: Defining columns for INSERT statements Rich Shepard
• 21:37   Re: PG16.1 security breach? Ron Johnson
• 21:48   Re: UPDATE with multiple WHERE conditions Ron Johnson
• 22:05   Re: UPDATE with multiple WHERE conditions Rob Sargent
• 22:08   Re: PG16.1 security breach? David G. Johnston
• 22:09   Re: UPDATE with multiple WHERE conditions David G. Johnston
• 22:12   Re: Definging columns for INSERT statements David G. Johnston
• 22:41   Re: UPDATE with multiple WHERE conditions Rich Shepard
• 22:43   Re: Definging columns for INSERT statements Rich Shepard
• 22:46   Re: UPDATE with multiple WHERE conditions Rich Shepard
• 22:47   Re: UPDATE with multiple WHERE conditions Rich Shepard
• 22:56   Re: PG16.1 security breach? Tom Lane
• 23:05   Re: Definging columns for INSERT statements Adrian Klaver
• 23:07   Re: PG16.1 security breach? David G. Johnston
• 23:24   Re: Definging columns for INSERT statements Rich Shepard
• 23:38   Re: Definging columns for INSERT statements Adrian Klaver

13 June 2024

• 00:54   Is NVMe RAID useless (performance-wise) with PostgreSQL? Dragan Milivojević
• 01:31   "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program Chema
• 01:44   Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program David G. Johnston
• 01:48   Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program Tom Lane
• 01:53   Re: "permission denied to COPY to or from an external program" even with GRANT pg_execute_server_program Chema
• 07:11   Re: postgres table statistics Chandy G
• 07:43   Re: Long running query causing XID limit breach yudhi s
• 07:49   Re: DROP COLLATION vs pg_collation question Laurenz Albe
• 07:55   TOAST Table / Dead Tuples / Free Pages Shenavai, Manuel
• 08:08   Re: TOAST Table / Dead Tuples / Free Pages Kashif Zeeshan
• 08:41   Re: TOAST Table / Dead Tuples / Free Pages Muhammad Ikram
• 10:01   Re: Questions on logical replication Koen De Groote
• 10:34   Re: UPDATE with multiple WHERE conditions Alvaro Herrera
• 11:47   Re: Question about UNIX socket connections and SSL Daniel Gustafsson
• 11:59   Re: PG16.1 security breach? Joe Conway
• 12:37   Re: Definging columns for INSERT statements Rich Shepard
• 14:11   Syntax on BEFORE Trigger - Cascade? David Barbour
• 14:23   Re: Syntax on BEFORE Trigger - Cascade? Tom Lane
• 14:25   Re: Syntax on BEFORE Trigger - Cascade? David G. Johnston
• 14:38   Re: TOAST Table / Dead Tuples / Free Pages Adrian Klaver
• 14:41   Re: Oracle Linux 9 Detected RPMs with RSA/SHA1 signature Adrian Klaver
• 15:37   Re: Questions on logical replication Justin
• 17:20   Reset sequence to current maximum value of rows Rich Shepard
• 17:26   Re: Reset sequence to current maximum value of rows Ron Johnson
• 17:28   Re: Reset sequence to current maximum value of rows David G. Johnston
• 18:24   Re: Reset sequence to current maximum value of rows Rich Shepard
• 18:38   Re: Reset sequence to current maximum value of rows Rich Shepard
• 18:50   Re: Reset sequence to current maximum value of rows Ron Johnson
• 18:54   Re: Reset sequence to current maximum value of rows Adrian Klaver
• 19:26   Reserving GUC prefixes from a non-preloaded DB extension is not always enforced Narek Galstyan
• 19:35   Re: Reset sequence to current maximum value of rows David G. Johnston
• 19:39   Re: Reserving GUC prefixes from a non-preloaded DB extension is not always enforced Tom Lane
• 19:50   Re: Reset sequence to current maximum value of rows Rich Shepard
• 19:57   Re: Reset sequence to current maximum value of rows Rich Shepard
• 20:09   Re: Reset sequence to current maximum value of rows Rich Shepard
• 20:14   Re: Reset sequence to current maximum value of rows David G. Johnston
• 20:18   Re: Question about UNIX socket connections and SSL Casey & Gina
• 20:22   Re: Reset sequence to current maximum value of rows [RESOLVED] Rich Shepard
• 20:30   Re: Reset sequence to current maximum value of rows Jeremy Smith
• 21:13   Re: Reset sequence to current maximum value of rows Rich Shepard
• 22:01   Re: Reset sequence to current maximum value of rows Adrian Klaver
• 22:13   Re: Reset sequence to current maximum value of rows Rich Shepard
• 22:24   Re: Reset sequence to current maximum value of rows Adrian Klaver
• 22:29   Re: Reset sequence to current maximum value of rows David G. Johnston

14 June 2024

• 06:20   Configure autovacuum Shenavai, Manuel
• 07:08   Re: Reset sequence to current maximum value of rows Alban Hertroys
• 07:41   Re: Configure autovacuum Laurenz Albe
• 07:44   Re: Reserving GUC prefixes from a non-preloaded DB extension is not always enforced Laurenz Albe
• 09:17   Re: Configure autovacuum Ron Johnson
• 14:32   Re: Configure autovacuum Adrian Klaver
• 20:08   Re: DROP COLLATION vs pg_collation question Karsten Hilbert

15 June 2024

• 12:40   pgstattuple - can it/does it provide stats by partition? Dragam
• 13:24   Design for dashboard query sud
• 15:14   Re: Design for dashboard query Sushrut Shivaswamy
• 17:04   Re: pgstattuple - can it/does it provide stats by partition? Ron Johnson
• 20:09   Re: Design for dashboard query yudhi s
• 22:55   Is a VACUUM or ANALYZE necessary after logical replication? Koen De Groote
• 23:13   Re: Is a VACUUM or ANALYZE necessary after logical replication? Adrian Klaver

16 June 2024

• 04:53   Re: DROP COLLATION vs pg_collation question Laurenz Albe
• 06:54   Re: Is a VACUUM or ANALYZE necessary after logical replication? Achilleas Mantzios
• 07:09   Re: Is a VACUUM or ANALYZE necessary after logical replication? David G. Johnston
• 09:27   Re: DROP COLLATION vs pg_collation question Karsten Hilbert
• 17:37   Re: DROP COLLATION vs pg_collation question Laurenz Albe
• 20:38   Re: DROP COLLATION vs pg_collation question Tom Lane

17 June 2024

• 13:46   WAL settings for larger imports Benoit, Eric
• 15:10   Re: WAL settings for larger imports Adrian Klaver
• 15:57   Re: WAL settings for larger imports Ron Johnson
• 18:46    Дмитрий Питаков

18 June 2024

• 05:32   How to attach partition with primary key Philipp Faster
• 06:45   HISTIGNORE in psql Wiwwo Staff
• 08:35   set search_path "$owner". And name versus literal for schemas. Dominique Devienne
• 09:03   Re: Monitoring logical replication Shaheed Haque
• 09:46   Re: How to attach partition with primary key Alvaro Herrera
• 13:02   Re: DROP COLLATION vs pg_collation question Karsten Hilbert
• 13:32   Re: Monitoring logical replication Ron Johnson
• 13:32   Re: DROP COLLATION vs pg_collation question Karsten Hilbert
• 13:58   Re: How to attach partition with primary key Philipp Faster
• 14:43   Re: How to attach partition with primary key Alvaro Herrera
• 14:44   Re: DROP COLLATION vs pg_collation question Adrian Klaver
• 14:59   RE: Restore of a reference database kills the auto analyze processing. HORDER Philip
• 16:12   Re: HISTIGNORE in psql Adrian Klaver
• 16:19   Re: set search_path "$owner". And name versus literal for schemas. Adrian Klaver
• 16:50   Seeking Clarification on Function Definitions in PostgreSQL Extensions Ayush Vatsa
• 17:07   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions Ron Johnson
• 17:13   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions David G. Johnston
• 17:15   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions David G. Johnston
• 17:28   Re: HISTIGNORE in psql Wiwwo Staff
• 17:40   fail to install postgresql15 on Alma9 Dmitry O Litvintsev
• 17:44   Re: fail to install postgresql15 on Alma9 Adrian Klaver
• 17:48   Re: fail to install postgresql15 on Alma9 Dmitry O Litvintsev
• 17:54   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions Ron Johnson
• 17:56   Re: fail to install postgresql15 on Alma9 Dmitry O Litvintsev
• 17:57   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions David G. Johnston
• 18:27   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions Ron Johnson
• 18:37   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions David G. Johnston
• 19:03   Re: HISTIGNORE in psql Daniel Gustafsson
• 19:04   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions Ron Johnson
• 19:17   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions David G. Johnston
• 19:31   Re: fail to install postgresql15 on Alma9 Adrian Klaver
• 20:04   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions Tom Lane
• 20:57   Re: Restore of a reference database kills the auto analyze processing. Peter J. Holzer

19 June 2024

• 02:50   Pgpool delegate IP is not reachable from the remote host Mukesh Tanuku
• 04:42   Re: [pgpool-general: 9132] Pgpool delegate IP is not reachable from the remote host Bo Peng
• 15:03   Manual Failover Yongye Serkfem
• 15:26   Re: Manual Failover Rob Sargent
• 15:55   Proper format for pg_dump file date Rich Shepard
• 15:59   Re: Proper format for pg_dump file date Adrian Klaver
• 16:11   Re: Proper format for pg_dump file date [RESOLVED] Rich Shepard
• 16:14   Re: Proper format for pg_dump file date David G. Johnston
• 16:46   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions Ayush Vatsa
• 16:50   Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions David G. Johnston
• 17:07   Re: Manual Failover Ron Johnson
• 17:13   Re: Proper format for pg_dump file date Rich Shepard
• 17:15   Re: Proper format for pg_dump file date Ron Johnson
• 17:17   Re: Proper format for pg_dump file date Ron Johnson
• 17:38   Re: Proper format for pg_dump file date Rich Shepard
• 17:56   Transaction issue Rich Shepard
• 17:58   Re: Transaction issue Adrian Klaver
• 18:07   Re: Transaction issue David G. Johnston
• 18:36   Re: Transaction issue Rich Shepard
• 18:38   Re: Transaction issue Rich Shepard
• 18:40   Re: Transaction issue Adrian Klaver
• 18:44   Re: Transaction issue David G. Johnston
• 19:40   Re: Transaction issue Rich Shepard
• 20:10   Re: Transaction issue Adrian Klaver
• 20:13   Re: Transaction issue Rich Shepard
• 20:20   Re: Transaction issue Alban Hertroys
• 20:33   Re: Transaction issue Rich Shepard
• 20:43   Re: Transaction issue Adrian Klaver
• 20:54   Re: Transaction issue Rich Shepard
• 20:57   Re: Transaction issue Ron Johnson
• 21:02   Re: Transaction issue Ron Johnson
• 21:03   Re: Transaction issue Adrian Klaver
• 21:09   Re: Transaction issue Adrian Klaver
• 21:32   Re: Transaction issue Rich Shepard
• 21:33   Re: Transaction issue Rich Shepard
• 21:39   Re: Transaction issue Rich Shepard
• 21:44   Re: Transaction issue Ron Johnson
• 21:48   Re: Transaction issue Adrian Klaver
• 21:55   Re: Transaction issue David G. Johnston
• 22:14   Re: Transaction issue Rob Sargent

20 June 2024

• 00:16   Re: Transaction issue Adrian Klaver
• 00:18   Re: Transaction issue Adrian Klaver
• 00:27   Re: Transaction issue David G. Johnston
• 00:30   Re: Transaction issue Adrian Klaver
• 05:05   Postgresql python in upgraded version 16.2 Šika Michal
• 07:23   Help. The database was created using collation version 2.17, but the operating system provides version 2.34. Dmitry O Litvintsev
• 08:23   Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34. Achilleas Mantzios - cloud
• 09:31   Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34. Kenneth Barber
• 12:02   Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34. Daniel Verite
• 12:25   Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34. Ron Johnson
• 12:44   Re: Transaction issue Karsten Hilbert
• 13:04   Re: Transaction issue Rich Shepard
• 13:06   Re: Transaction issue Rich Shepard
• 14:41   Re: Transaction issue Rob Sargent
• 14:47   Re: Transaction issue Rich Shepard
• 14:56   Re: Transaction issue Adrian Klaver
• 15:03   Re: Postgresql python in upgraded version 16.2 Adrian Klaver
• 15:15   Replication using mTLS issue Drew Zoellner
• 15:30   Re: Transaction issue Rich Shepard
• 16:46   Autovacuum, dead tuples and bloat Shenavai, Manuel
• 17:06   Re: Autovacuum, dead tuples and bloat Adrian Klaver
• 17:06   Re: Autovacuum, dead tuples and bloat Ron Johnson
• 17:09   Re: Autovacuum, dead tuples and bloat Achilleas Mantzios

21 June 2024

• 07:33   Re: Postgresql python in upgraded version 16.2 Šika Michal
• 14:41   RowDescription for a function does not include table OID Maxwell Dreytser
• 14:48   Re: RowDescription for a function does not include table OID David G. Johnston
• 15:03   Re: RowDescription for a function does not include table OID Maxwell Dreytser
• 15:28   Re: RowDescription for a function does not include table OID David G. Johnston
• 15:41   Re: RowDescription for a function does not include table OID Maxwell Dreytser
• 15:51   Re: RowDescription for a function does not include table OID Tom Lane
• 15:52   Re: RowDescription for a function does not include table OID David G. Johnston
• 15:57   Re: RowDescription for a function does not include table OID David G. Johnston
• 16:12   Re: RowDescription for a function does not include table OID Tom Lane
• 16:17   Re: RowDescription for a function does not include table OID Tom Lane
• 16:46   Re: Replication using mTLS issue Tom Lane
• 17:21   Re: Replication using mTLS issue Drew Zoellner
• 18:24   Re: Replication using mTLS issue Tom Lane
• 19:31   RE: Autovacuum, dead tuples and bloat Shenavai, Manuel
• 19:58   RE: Autovacuum, dead tuples and bloat Shenavai, Manuel
• 20:39   Re: Autovacuum, dead tuples and bloat Adrian Klaver

22 June 2024

• 11:50   AI for query-planning? Andreas Joseph Krogh
• 14:01   Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34. Dmitry O Litvintsev
• 14:40   Re: AI for query-planning? Adrian Klaver
• 14:55   Re: AI for query-planning? Vijaykumar Jain
• 15:21   Re: AI for query-planning? Christoph Moench-Tegeder
• 17:01   pg_dump restores as expected on some machines and reports duplicate keys on others Shaheed Haque
• 17:18   Re: pg_dump restores as expected on some machines and reports duplicate keys on others Tom Lane
• 20:13   RE: Autovacuum, dead tuples and bloat Shenavai, Manuel
• 21:16   Re: Autovacuum, dead tuples and bloat Adrian Klaver
• 21:41   Re: pg_dump restores as expected on some machines and reports duplicate keys on others Ron Johnson
• 21:59   Re: pg_dump restores as expected on some machines and reports duplicate keys on others Adrian Klaver
• 23:28   Password complexity/history - credcheck? Martin Goodson

23 June 2024

• 00:23   Re: Password complexity/history - credcheck? Tom Lane
• 02:38   Re: Password complexity/history - credcheck? Ron Johnson
• 05:53   Re: pg_dump restores as expected on some machines and reports duplicate keys on others Muhammad Ikram
• 06:02   Re: pg_dump restores as expected on some machines and reports duplicate keys on others David G. Johnston
• 06:07   Re: pg_dump restores as expected on some machines and reports duplicate keys on others David G. Johnston
• 07:08   Upgrade PG from 12 to latest Doron Tsur
• 07:19   Stack Smashing Detected When Executing initdb Xu Haorong
• 07:54   Re: Upgrade PG from 12 to latest Muhammad Ikram
• 08:40   Re: pg_dump restores as expected on some machines and reports duplicate keys on others Shaheed Haque
• 08:50   Re: Stack Smashing Detected When Executing initdb Kashif Zeeshan
• 09:30   Re: Password complexity/history - credcheck? Martin Goodson
• 10:49   Re: Password complexity/history - credcheck? Christoph Moench-Tegeder
• 13:14   Re: Password complexity/history - credcheck? Martin Goodson
• 14:13   Re: Stack Smashing Detected When Executing initdb Kashif Zeeshan
• 14:20   回复: Stack Smashing Detected When Executing initdb Xu Haorong
• 15:09   Re: Password complexity/history - credcheck? Greg Sabino Mullane
• 15:48   Re: Stack Smashing Detected When Executing initdb Tom Lane
• 18:32   Re: Stack Smashing Detected When Executing initdb Tom Lane
• 18:43   How to use createdb command with newly created user? 毛毛
• 18:47   Re: How to use createdb command with newly created user? David G. Johnston
• 19:00   Re: How to use createdb command with newly created user? Tom Lane
• 19:22   Re:Re: How to use createdb command with newly created user? 毛毛
• 19:38   Re: Re: How to use createdb command with newly created user? Ron Johnson

24 June 2024

• 03:36   Re:Re: Re: How to use createdb command with newly created user? 毛毛
• 03:51   Re: Re: Re: How to use createdb command with newly created user? Muhammad Ikram
• 04:20   Re: How to use createdb command with newly created user? Adrian Klaver
• 05:18   Re: Stack Smashing Detected When Executing initdb Xu Haorong
• 05:28   Re: Stack Smashing Detected When Executing initdb Kashif Zeeshan
• 08:20   Re: Password complexity/history - credcheck? Laurenz Albe
• 08:23   Re: Upgrade PG from 12 to latest Laurenz Albe
• 08:48   Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34. Daniel Verite
• 10:29   Execute permission to function arun chirappurath
• 11:09   Issue with pgstattuple on Sequences in PostgreSQL Ayush Vatsa
• 11:38   Re: Issue with pgstattuple on Sequences in PostgreSQL Kashif Zeeshan
• 12:54   Re: Execute permission to function Ron Johnson
• 12:56   Re: Issue with pgstattuple on Sequences in PostgreSQL Ron Johnson
• 12:59   2FA - - - was Re: Password complexity/history - credcheck? o1bigtenor
• 13:14   Re: Execute permission to function David G. Johnston
• 13:30   Re: 2FA - - - was Re: Password complexity/history - credcheck? Chris Travers
• 13:35   Re: Issue with pgstattuple on Sequences in PostgreSQL David G. Johnston
• 14:32   Re: Issue with pgstattuple on Sequences in PostgreSQL Adrian Klaver
• 14:44   Re: Execute permission to function Adrian Klaver
• 15:01   Re: Password complexity/history - credcheck? Christoph Moench-Tegeder
• 18:10   Re: Execute permission to function arun chirappurath
• 18:42   Re: Execute permission to function Adrian Klaver
• 23:28   PostgreSQL Community Enquire ! madhav sira
• 23:56   Re: PostgreSQL Community Enquire ! Adrian Klaver

25 June 2024

• 00:00   schema privileges and drop role Matt Zagrabelny
• 00:03   Re: schema privileges and drop role Adrian Klaver
• 00:37   Re: Issue with pgstattuple on Sequences in PostgreSQL Tatsuo Ishii
• 00:43   Re: schema privileges and drop role Matt Zagrabelny
• 01:08   Re: schema privileges and drop role Tom Lane
• 04:06   Re: PostgreSQL Community Enquire ! Kashif Zeeshan
• 10:30   Re: Issue with pgstattuple on Sequences in PostgreSQL Ayush Vatsa
• 15:42   Re: Postgresql python in upgraded version 16.2 Adrian Klaver
• 16:42   Can any_value be used like first_value in an aggregate? Bruno Wolff III
• 17:08   Re: Can any_value be used like first_value in an aggregate? Tom Lane
• 17:20   Replication After manual Failover Yongye Serkfem
• 18:38   Re: Replication After manual Failover Muhammad Ikram
• 19:00   Re: PostgreSQL Community Enquire ! madhav sira
• 19:06   Re: Replication After manual Failover Ron Johnson
• 19:07   Re: Replication After manual Failover Ron Johnson
• 19:11   Re: Can any_value be used like first_value in an aggregate? Bruno Wolff III
• 19:15   Re: PostgreSQL Community Enquire ! Adrian Klaver

26 June 2024

• 07:03   RE: Autovacuum, dead tuples and bloat Shenavai, Manuel
• 07:50   Re: Can any_value be used like first_value in an aggregate? Laurenz Albe
• 08:35   current_role of caller of a DEFINER function Dominique Devienne
• 09:08   Re: current_role of caller of a DEFINER function Laurenz Albe
• 10:06   Re: current_role of caller of a DEFINER function Erik Wienhold
• 10:11   Re: current_role of caller of a DEFINER function walther@technowledgy.de
• 12:25   Re: current_role of caller of a DEFINER function Dominique Devienne
• 12:42   Re: current_role of caller of a DEFINER function David G. Johnston
• 12:58   Re: current_role of caller of a DEFINER function Isaac Morland
• 12:58   Re: current_role of caller of a DEFINER function Dominique Devienne
• 13:15   Re: Autovacuum, dead tuples and bloat Ron Johnson
• 14:43   ERROR: could not attach to dynamic shared area Andrew Longwill
• 15:05   Re: Autovacuum, dead tuples and bloat Adrian Klaver
• 16:21   --frokbackend process satyajit patra
• 17:44   Dropping connections Tarras, Tim
• 18:35   Re: Dropping connections Adrian Klaver
• 19:56   RE: [External] Dropping connections Tarras, Tim
• 19:57   Re: --frokbackend process Justin
• 22:33   Re: [External] Dropping connections Adrian Klaver
• 23:22   Issue with installing postgres extension bhavani dba
• 23:43   Re: Issue with installing postgres extension Tom Lane

27 June 2024

• 01:08   Re: Issue with installing postgres extension bhavani dba
• 02:25   Re: Issue with installing postgres extension Tom Lane
• 02:46   Re: Issue with installing postgres extension bhavani dba
• 03:45   Re: Issue with installing postgres extension bhavani dba
• 03:47   Re: Dropping connections Kashif Zeeshan
• 03:51   Re: ERROR: could not attach to dynamic shared area Michael Paquier
• 04:19   Re: --frokbackend process Kashif Zeeshan
• 06:43   Re: --frokbackend process Michael Paquier
• 13:06   Re: Can any_value be used like first_value in an aggregate? Bruno Wolff III
• 15:20   A way to optimize sql about the last temporary-related row agharta82@gmail.com
• 15:27   Re: A way to optimize sql about the last temporary-related row Ron Johnson
• 15:32   dblink Future support vs FDW Dhritman Roy
• 15:33   Re: A way to optimize sql about the last temporary-related row agharta82@gmail.com
• 15:33   Re: A way to optimize sql about the last temporary-related row David G. Johnston
• 15:43   Re: A way to optimize sql about the last temporary-related row Ron Johnson
• 15:44   Re: dblink Future support vs FDW David G. Johnston
• 15:51   Re: A way to optimize sql about the last temporary-related row agharta82@gmail.com
• 16:00   Re: dblink Future support vs FDW Tom Lane
• 16:07   Alignment check Marthin Laubscher
• 16:16   Re: A way to optimize sql about the last temporary-related row David Rowley
• 17:03   Re: Alignment check Adrian Klaver
• 17:08   Re: dblink Future support vs FDW Adrian Klaver
• 17:26   Re: Alignment check Marthin Laubscher
• 17:34   Re: Alignment check Ron Johnson
• 17:40   Re: Alignment check Adrian Klaver

28 June 2024

• 07:20   Re: A way to optimize sql about the last temporary-related row agharta82@gmail.com
• 17:51   Re: A way to optimize sql about the last temporary-related row Richard Welty
• 19:07   Re: A way to optimize sql about the last temporary-related row agharta agharta

30 June 2024

• 22:39   Passing a dynamic interval to generate_series() Igal Sapir
• 22:51   Re: Passing a dynamic interval to generate_series() Tom Lane
• 23:17   Re: Passing a dynamic interval to generate_series() Igal Sapir