Mailing lists [pgsql-general]

1 October

• 10:47   Direct Major Upgrade (13.7 → 17.6) with pg_upgrade: Clarifying the need for Intermediate Minor Fixes/Scripts Vu Le (JData - HN)
• 12:33   Re: Downgrade pgsql 17 to pgsql 12 question Ashish Mukherjee
• 14:26   Re: Direct Major Upgrade (13.7 → 17.6) with pg_upgrade: Clarifying the need for Intermediate Minor Fixes/Scripts Greg Sabino Mullane
• 17:14   Re: Direct Major Upgrade (13.7 → 17.6) with pg_upgrade: Clarifying the need for Intermediate Minor Fixes/Scripts Vu Le (JData - HN)
• 18:23   Re: Downgrade pgsql 17 to pgsql 12 question Adrian Klaver

2 October

• 15:21   has_schema_privilege(), but taking inheritance into account Dominique Devienne

3 October

• 18:15   Re: Downgrade pgsql 17 to pgsql 12 question Pavan Kumar

5 October

• 12:19   Re: Client/server certificates verification support on Android platform Mathieu Pellerin

6 October

• 11:01   Does Java 8 support drivers 42.2.19 and 42.7.6? Артем Романюк
• 11:18   Re: Does Java 8 support drivers 42.2.19 and 42.7.6? Vladimir Sitnikov
• 17:15   Are SQL-language function lock ordering deadlocks solved in PostgreSQL 18? Bernice Southey
• 17:54   Re: Does Java 8 support drivers 42.2.19 and 42.7.6? Adrian Klaver
• 17:59   Re: Does Java 8 support drivers 42.2.19 and 42.7.6? shammat@gmx.net

7 October

• 23:51   Re: Are SQL-language function lock ordering deadlocks solved in PostgreSQL 18? Merlin Moncure

8 October

• 12:11   JSONB subscripting initializes numeric keys as arrays instead of objects Krrish Malhotra
• 17:58   Re: JSONB subscripting initializes numeric keys as arrays instead of objects Adrian Klaver
• 18:42   Alerting on memory use and instance crash sud
• 19:21   Re: Alerting on memory use and instance crash Ron Johnson
• 19:22   Re: Alerting on memory use and instance crash Adrian Klaver
• 21:58   Re: Alerting on memory use and instance crash sud
• 22:06   Re: Alerting on memory use and instance crash Ron Johnson
• 22:39   Option on `postgres` CLI to shutdown when there are no more active connections? David Barsky
• 22:50   Re: Alerting on memory use and instance crash sud
• 22:54   Re: Alerting on memory use and instance crash Adrian Klaver

9 October

• 10:06   Clarification on restart_lsn behavior in logical decoding Rajendra Kumar Dangwal
• 10:21   Pgbackrest changing RepoServer to new one KK CHN
• 12:03   High latency and profiling Roberto Nunnari
• 14:10   Are compression requirements needed when building only libraries? Uilian Ries
• 16:49   Re: Pgbackrest changing RepoServer to new one Ron Johnson
• 17:49   Re: Are compression requirements needed when building only libraries? Laurenz Albe
• 17:58   Re: Are compression requirements needed when building only libraries? Uilian Ries
• 18:21   Re: Alerting on memory use and instance crash veem v
• 20:25   High latency and profiling Roberto Nunnari
• 22:12   Re: Are compression requirements needed when building only libraries? Laurenz Albe
• 22:21   Re: High latency and profiling Laurenz Albe
• 23:54   Re: High latency and profiling Rob Sargent

10 October

• 11:26   Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice Vu Le (JData - HN)
• 12:01   Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice Laurenz Albe
• 13:38   Re: Alerting on memory use and instance crash Rahila Syed
• 15:28   RE: Index (primary key) corrupt? Wim Rouquart
• 15:30   RE: Index (primary key) corrupt? Wim Rouquart
• 18:03   Re: Index (primary key) corrupt? Adrian Klaver
• 18:27   Re: Alerting on memory use and instance crash sud

11 October

• 19:02   Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice Vu Le (JData - HN)
• 19:44   Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice Bruce Momjian
• 21:16   Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice Laurenz Albe
• 21:50   Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice Bruce Momjian

12 October

• 02:11   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Adrian Klaver
• 03:37   Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice Vu Le (JData - HN)
• 04:44   Re: Index (primary key) corrupt? Greg Sabino Mullane
• 05:56   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Ron Johnson
• 06:21   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Adrian Klaver
• 06:38   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Ron Johnson

13 October

• 01:10   Re: Option on `postgres` CLI to shutdown when there are no more active connections? David Barsky
• 05:00   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Rob Sargent
• 05:16   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Tom Lane
• 11:47   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Dominique Devienne
• 18:07   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Ron Johnson
• 18:15   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Dominique Devienne
• 18:37   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Tom Lane
• 18:55   Enquiry about TDE with PgSQL Ashish Mukherjee
• 19:43   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Dominique Devienne
• 22:19   Re: Option on `postgres` CLI to shutdown when there are no more active connections? David Barsky
• 23:19   Database in another drive Arbol One
• 23:21   Re: Database in another drive John McKown
• 23:27   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Ron Johnson
• 23:36   Re: Database in another drive Tim Gerber

14 October

• 00:57   Re: Database in another drive Ron Johnson
• 02:01   Re: Database in another drive Adrian Klaver

15 October

• 00:40   Re: Option on `postgres` CLI to shutdown when there are no more active connections? David Barsky
• 05:42   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Bird
• 08:47   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Thiemo Kellner
• 12:51   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Dominique Devienne

17 October

• 01:04   Re: Enquiry about TDE with PgSQL Greg Sabino Mullane
• 01:18   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Greg Sabino Mullane
• 01:22   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Tom Lane
• 07:49   Re: Enquiry about TDE with PgSQL Ron Johnson
• 07:53   Re: Option on `postgres` CLI to shutdown when there are no more active connections? Ron Johnson
• 08:53   pg_running_stats - mergeable running statistics (Welford/Chan) extension for postgresql Chanukya SDS
• 10:01   Re: Enquiry about TDE with PgSQL Laurenz Albe
• 15:47   Re: Enquiry about TDE with PgSQL Ron Johnson
• 16:12   Re: Enquiry about TDE with PgSQL Greg Sabino Mullane
• 17:08   Re: Enquiry about TDE with PgSQL rainer@ultra-secure.de
• 18:20   Must to have and good to have extensions veem v
• 19:21   Re: Must to have and good to have extensions Adrian Klaver

19 October

• 17:43   Convert date and time colums to datetime Rich Shepard
• 17:53   Re: Convert date and time colums to datetime Adrian Klaver
• 17:56   Re: Convert date and time colums to datetime Adrian Klaver
• 19:35   Re: Convert date and time colums to datetime Rich Shepard
• 19:46   Re: Convert date and time colums to datetime Isaac Morland
• 19:59   Re: Convert date and time colums to datetime Adrian Klaver
• 20:56   Re: Convert date and time colums to datetime Rich Shepard
• 21:09   Re: Convert date and time colums to datetime Laurenz Albe
• 22:08   Re: Convert date and time colums to datetime Rich Shepard
• 22:40   Re: Convert date and time colums to datetime Rob Sargent
• 23:38   Re: Convert date and time colums to datetime Rich Shepard
• 23:43   Arrays vs separate tables Rich Shepard
• 23:50   Re: Arrays vs separate tables Adrian Klaver
• 23:53   Re: Arrays vs separate tables Ray O'Donnell

20 October

• 00:44   Re: Arrays vs separate tables Rich Shepard
• 00:49   Re: Arrays vs separate tables Rich Shepard
• 05:32   Re: Convert date and time colums to datetime Rob Sargent
• 14:05   Re: Convert date and time colums to datetime Peter J. Holzer
• 14:28   Re: Arrays vs separate tables Peter J. Holzer
• 15:43   Re: Convert date and time colums to datetime Rob Sargent
• 15:45   Re: Convert date and time colums to datetime Rich Shepard
• 15:51   Re: Convert date and time colums to datetime Rich Shepard
• 15:53   Re: Convert date and time colums to datetime Rob Sargent
• 15:55   Re: Arrays vs separate tables Rich Shepard
• 15:58   Re: Convert date and time colums to datetime Rich Shepard
• 16:00   Re: Convert date and time colums to datetime Ron Johnson
• 16:26   Re: Convert date and time colums to datetime Rob Sargent
• 16:38   Re: Arrays vs separate tables Michał Kłeczek
• 17:07   Re: Arrays vs separate tables Rich Shepard
• 17:21   Re: Arrays vs separate tables Michał Kłeczek
• 17:25   Re: Arrays vs separate tables Ron Johnson
• 17:25   Re: Arrays vs separate tables Rich Shepard
• 17:32   Re: Arrays vs separate tables Rich Shepard
• 17:42   Re: Arrays vs separate tables Adrian Klaver
• 17:48   Re: Arrays vs separate tables Rob Sargent
• 17:50   Re: Arrays vs separate tables Michał Kłeczek
• 18:06   Re: Arrays vs separate tables Rich Shepard
• 18:41   Re: Arrays vs separate tables Michał Kłeczek

21 October

• 00:45   Extend CREATE POLICY to add IF EXISTS Paul Austin
• 00:49   RE: Extend CREATE POLICY to add IF EXISTS Paul Austin
• 00:51   Re: Extend CREATE POLICY to add IF EXISTS Adrian Klaver
• 01:19   Re: Extend CREATE POLICY to add IF EXISTS Paul Austin
• 10:23   Re: Extend CREATE POLICY to add IF EXISTS Álvaro Herrera
• 17:08   RE: Extend CREATE POLICY to add IF EXISTS Paul Austin
• 17:26   Re: Extend CREATE POLICY to add IF EXISTS Ron Johnson

22 October

• 10:44   typo in the license ? Achilleas Mantzios
• 12:03   Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Bala M
• 15:30   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Chris Wilson
• 17:27   Re: typo in the license ? Adrian Klaver
• 17:31   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Adrian Klaver
• 18:19   Re: typo in the license ? Álvaro Herrera
• 18:29   Re: typo in the license ? Álvaro Herrera
• 20:35   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Greg Sabino Mullane
• 21:18   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Ron Johnson
• 21:26   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Adrian Klaver

23 October

• 18:20   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Greg Sabino Mullane
• 18:49   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Adrian Klaver
• 20:56   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Ron Johnson
• 21:16   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Devrim Gündüz
• 22:37   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) David Rowley
• 22:52   Re: Convert date and time colums to datetime Peter J. Holzer
• 23:24   RE: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Scot Kreienkamp

24 October

• 00:54   could not stat file "pg_wal/RECOVERYHISTORY": No such file or director Dmitry Litvintsev
• 02:23   Re: Convert date and time colums to datetime Rob Sargent
• 07:59   Re: could not stat file "pg_wal/RECOVERYHISTORY": No such file or director Laurenz Albe
• 08:34   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Gregory Smith
• 14:01   Why is this query touching 4gb of buffers? hubert depesz lubaczewski
• 14:19   Re: Why is this query touching 4gb of buffers? hubert depesz lubaczewski
• 15:53   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Greg Sabino Mullane
• 15:54   Re: Why is this query touching 4gb of buffers? Tom Lane
• 15:56   Re: Why is this query touching 4gb of buffers? hubert depesz lubaczewski
• 15:58   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Greg Sabino Mullane
• 16:01   Re: Why is this query touching 4gb of buffers? Tom Lane
• 16:18   Re: Why is this query touching 4gb of buffers? hubert depesz lubaczewski
• 16:20   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Ron Johnson
• 17:54   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Adrian Klaver
• 18:00   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Ron Johnson
• 18:51   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Adrian Klaver
• 19:25   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Francisco Olarte

25 October

• 01:37   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) David Rowley
• 02:00   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) David G. Johnston
• 03:40   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Adrian Klaver
• 04:06   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) David Rowley
• 04:53   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Tom Lane
• 05:19   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) David Rowley
• 07:36   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Adrian Klaver
• 07:50   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) David Rowley
• 08:05   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Adrian Klaver
• 10:23   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Peter J. Holzer
• 10:47   Download statistics Peter J. Holzer
• 17:21   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Adrian Klaver
• 17:38   Re: Download statistics Tom Lane
• 17:39   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Ron Johnson
• 17:43   Re: Download statistics Ron Johnson
• 18:14   Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) Peter J. Holzer
• 18:31   Re: Download statistics Peter J. Holzer