General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.
| Thread | Author | Time |
|---|---|---|
| Re: Emitting JSON to file using COPY TO 📎 | jian he | 06:16 |
| Direct Major Upgrade (13.7 → 17.6) with pg_upgrade: Clarifying the need for Intermediate Minor Fixes/Scripts | Vu Le (JData - HN) | 07:47 |
| Re: Downgrade pgsql 17 to pgsql 12 question | Ashish Mukherjee | 09:33 |
| Re: Direct Major Upgrade (13.7 → 17.6) with pg_upgrade: Clarifying the need for Intermediate Minor Fixes/Scripts | Greg Sabino Mullane | 11:26 |
| Re: Direct Major Upgrade (13.7 → 17.6) with pg_upgrade: Clarifying the need for Intermediate Minor Fixes/Scripts | Vu Le (JData - HN) | 14:14 |
| Re: Downgrade pgsql 17 to pgsql 12 question | Adrian Klaver | 15:23 |
| Thread | Author | Time |
|---|---|---|
| has_schema_privilege(), but taking inheritance into account | Dominique Devienne | 12:21 |
| Re: Clarification on Role Access Rights to Table Indexes | Nathan Bossart | 17:37 |
| Thread | Author | Time |
|---|---|---|
| Re: Downgrade pgsql 17 to pgsql 12 question | Pavan Kumar | 15:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Client/server certificates verification support on Android platform | Mathieu Pellerin | 09:19 |
| Thread | Author | Time |
|---|---|---|
| Does Java 8 support drivers 42.2.19 and 42.7.6? | Артем Романюк | 08:01 |
| Re: Does Java 8 support drivers 42.2.19 and 42.7.6? | Vladimir Sitnikov | 08:18 |
| Are SQL-language function lock ordering deadlocks solved in PostgreSQL 18? | Bernice Southey | 14:15 |
| Re: Does Java 8 support drivers 42.2.19 and 42.7.6? | Adrian Klaver | 14:54 |
| Re: Does Java 8 support drivers 42.2.19 and 42.7.6? | shammat | 14:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Are SQL-language function lock ordering deadlocks solved in PostgreSQL 18? | Merlin Moncure | 20:51 |
| Thread | Author | Time |
|---|---|---|
| JSONB subscripting initializes numeric keys as arrays instead of objects | Krrish Malhotra | 09:11 |
| Re: JSONB subscripting initializes numeric keys as arrays instead of objects | Adrian Klaver | 14:58 |
| Alerting on memory use and instance crash | sud | 15:42 |
| Re: Alerting on memory use and instance crash | Ron Johnson | 16:21 |
| Re: Alerting on memory use and instance crash | Adrian Klaver | 16:22 |
| Re: Alerting on memory use and instance crash | sud | 18:58 |
| Re: Alerting on memory use and instance crash | Ron Johnson | 19:06 |
| Option on `postgres` CLI to shutdown when there are no more active connections? | David Barsky | 19:39 |
| Re: Alerting on memory use and instance crash | sud | 19:50 |
| Re: Alerting on memory use and instance crash | Adrian Klaver | 19:54 |
| Thread | Author | Time |
|---|---|---|
| Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice | Vu Le (JData - HN) | 08:26 |
| Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice | Laurenz Albe | 09:01 |
| Re: Alerting on memory use and instance crash | Rahila Syed | 10:38 |
| RE: Index (primary key) corrupt? | Wim Rouquart | 12:28 |
| RE: Index (primary key) corrupt? | Wim Rouquart | 12:30 |
| Re: Index (primary key) corrupt? | Adrian Klaver | 15:03 |
| Re: Alerting on memory use and instance crash | sud | 15:27 |
| Re: Clarification on Role Access Rights to Table Indexes 📎 | Nathan Bossart | 16:26 |
| Re: Clarification on Role Access Rights to Table Indexes | Jeff Davis | 18:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Upgrade & Rollback plan: My customer requests rollback via old-version standby (13 ↔ 17) — need community advice | Vu Le (JData - HN) | 00:37 |
| Re: Index (primary key) corrupt? | Greg Sabino Mullane | 01:44 |
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | Ron Johnson | 02:56 |
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | Adrian Klaver | 03:21 |
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | Ron Johnson | 03:38 |
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | David Barsky | 22:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Clarification on Role Access Rights to Table Indexes | Jeff Davis | 02:23 |
| Re: Clarification on Role Access Rights to Table Indexes | Nathan Bossart | 16:05 |
| Re: Clarification on Role Access Rights to Table Indexes | Tom Lane | 16:30 |
| Re: Clarification on Role Access Rights to Table Indexes | Jeff Davis | 17:01 |
| Re: Clarification on Role Access Rights to Table Indexes 📎 | Nathan Bossart | 21:32 |
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | David Barsky | 21:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | Bird | 02:42 |
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | Thiemo Kellner | 05:47 |
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | Dominique Devienne | 09:51 |
| Re: Clarification on Role Access Rights to Table Indexes | Nathan Bossart | 15:39 |
| Re: Clarification on Role Access Rights to Table Indexes | Nathan Bossart | 17:54 |
| Re: Clarification on Role Access Rights to Table Indexes | Nathan Bossart | 21:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Enquiry about TDE with PgSQL | Greg Sabino Mullane | 22:04 |
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | Greg Sabino Mullane | 22:18 |
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | Tom Lane | 22:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Enquiry about TDE with PgSQL | Ron Johnson | 04:49 |
| Re: Option on `postgres` CLI to shutdown when there are no more active connections? | Ron Johnson | 04:53 |
| pg_running_stats - mergeable running statistics (Welford/Chan) extension for postgresql | Chanukya SDS | 05:53 |
| Re: Enquiry about TDE with PgSQL | Laurenz Albe | 07:01 |
| Re: Enquiry about TDE with PgSQL | Ron Johnson | 12:47 |
| Re: Enquiry about TDE with PgSQL | Greg Sabino Mullane | 13:12 |
| Re: Enquiry about TDE with PgSQL | rainer | 14:08 |
| Must to have and good to have extensions | veem v | 15:20 |
| Re: Must to have and good to have extensions | Adrian Klaver | 16:21 |
| Re: Clarification on Role Access Rights to Table Indexes | Nathan Bossart | 16:56 |
| Thread | Author | Time |
|---|---|---|
| Convert date and time colums to datetime | Rich Shepard | 14:43 |
| Re: Convert date and time colums to datetime | Adrian Klaver | 14:53 |
| Re: Convert date and time colums to datetime | Adrian Klaver | 14:56 |
| Re: Convert date and time colums to datetime | Rich Shepard | 16:35 |
| Re: Convert date and time colums to datetime | Isaac Morland | 16:46 |
| Re: Convert date and time colums to datetime | Adrian Klaver | 16:59 |
| Re: Convert date and time colums to datetime | Rich Shepard | 17:56 |
| Re: Convert date and time colums to datetime | Laurenz Albe | 18:09 |
| Re: Convert date and time colums to datetime | Rich Shepard | 19:08 |
| Re: Convert date and time colums to datetime | Rob Sargent | 19:40 |
| Re: Convert date and time colums to datetime | Rich Shepard | 20:38 |
| Arrays vs separate tables | Rich Shepard | 20:43 |
| Re: Arrays vs separate tables | Adrian Klaver | 20:50 |
| Re: Arrays vs separate tables | Ray O'Donnell | 20:53 |
| Re: Arrays vs separate tables | Rich Shepard | 21:44 |
| Re: Arrays vs separate tables | Rich Shepard | 21:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Extend CREATE POLICY to add IF EXISTS | Álvaro Herrera | 07:23 |
| RE: Extend CREATE POLICY to add IF EXISTS | Paul Austin | 14:08 |
| Re: Extend CREATE POLICY to add IF EXISTS | Ron Johnson | 14:26 |
| Thread | Author | Time |
|---|---|---|
| typo in the license ? | Achilleas Mantzios | 07:44 |
| Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Bala M | 09:03 |
| Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Chris Wilson | 12:30 |
| Re: typo in the license ? | Adrian Klaver | 14:27 |
| Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Adrian Klaver | 14:31 |
| Re: typo in the license ? | Álvaro Herrera | 15:19 |
| Re: typo in the license ? | Álvaro Herrera | 15:29 |
| Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Greg Sabino Mullane | 17:35 |
| Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Ron Johnson | 18:18 |
| Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Adrian Klaver | 18:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Greg Sabino Mullane | 15:20 |
| Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Adrian Klaver | 15:49 |
| Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Ron Johnson | 17:56 |
| Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Devrim Gündüz | 18:16 |
| Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | David Rowley | 19:37 |
| Re: Convert date and time colums to datetime | Peter J. Holzer | 19:52 |
| RE: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) | Scot Kreienkamp | 20:24 |
| could not stat file "pg_wal/RECOVERYHISTORY": No such file or director | Dmitry Litvintsev | 21:54 |
| Re: Convert date and time colums to datetime | Rob Sargent | 23:23 |