[go: up one dir, main page]

pgsql-general - May 2024

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.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

May 1, 2024

Thread Author Time
Re: Linked directory or explicit reference Ron Johnson 00:31
Posgresql 14 and CarbonBlack on RHEL8? Ron Johnson 01:21
Re: Posgresql 14 and CarbonBlack on RHEL8? Tom Lane 02:07
Re: Posgresql 14 and CarbonBlack on RHEL8? Ron Johnson 08:44

May 2, 2024

Thread Author Time
Table data migration from single server to Flexi server Bagesh kamar singh 03:24
Re: Table data migration from single server to Flexi server Kashif Zeeshan 03:45
Re: Linked directory or explicit reference Senor Cervesa 04:50
Prevent users from executing pg_dump against tables RAJAMOHAN 05:46
Re: Prevent users from executing pg_dump against tables Kashif Zeeshan 06:11
Re: How to interpret 'depends on' errors in pg_restore? Fire Emerald 09:20
Re: Linked directory or explicit reference Ron Johnson 09:24
Listing only the user defined types (with owners) Durumdara 11:39
Re: Listing only the user defined types (with owners) Kashif Zeeshan 12:06
Re: Prevent users from executing pg_dump against tables David G. Johnston 12:24
Re: Listing only the user defined types (with owners) Thom Brown 12:28
Re: Prevent users from executing pg_dump against tables Ron Johnson 12:32
Re: Listing only the user defined types (with owners) Tom Lane 14:15
Re: How to interpret 'depends on' errors in pg_restore? Adrian Klaver 14:43
Restore of a reference database kills the auto analyze processing. HORDER Philip 15:52
Re: Restore of a reference database kills the auto analyze processing. Adrian Klaver 16:59
Re: Restore of a reference database kills the auto analyze processing. Adrian Klaver 18:41

May 3, 2024

Thread Author Time
Ora2pg Delta Migration: Oracle to PostgreSQL Amit Sharma 00:28
Re: Preallocation changes in Postgresql 16 Riku Iki 03:11
Re: Ora2pg Delta Migration: Oracle to PostgreSQL Ron Johnson 03:12
Re: Table data migration from single server to Flexi server Justin Clift 04:13
Re: Ora2pg Delta Migration: Oracle to PostgreSQL Muhammad Ikram 07:24
Re: Ora2pg Delta Migration: Oracle to PostgreSQL Avinash Vallarapu 09:38
Identity column data type difference in PostgreSQL and Oracle Muhammad Ikram 10:57
Re: Identity column data type difference in PostgreSQL and Oracle Peter Eisentraut 11:09
Re: Identity column data type difference in PostgreSQL and Oracle Muhammad Ikram 11:11
I have ansible for postgres-etcd-patroni Iman Bakhtiari 12:11
Re: Ora2pg Delta Migration: Oracle to PostgreSQL Amit Sharma 14:19
\dt shows table but \d <table> says the table doesn't exist ? David Gauthier 20:58
Re: \dt shows table but \d <table> says the table doesn't exist ? Magnus Hagander 21:06
Re: \dt shows table but \d <table> says the table doesn't exist ? Adrian Klaver 21:06
Re: \dt shows table but \d <table> says the table doesn't exist ? Adrian Klaver 21:08
Re: \dt shows table but \d <table> says the table doesn't exist ? Magnus Hagander 21:13
Re: \dt shows table but \d <table> says the table doesn't exist ? David G. Johnston 21:13
Re: \dt shows table but \d <table> says the table doesn't exist ? Tom Lane 21:15
Re: \dt shows table but \d <table> says the table doesn't exist ? Tom Lane 21:28
Re: \dt shows table but \d <table> says the table doesn't exist ? Isaac Morland 22:08
How to Build Postgres in a Portable / Relocatable fashion? AJ ONeal 22:57
Re: How to Build Postgres in a Portable / Relocatable fashion? Adrian Klaver 23:09
Re: How to Build Postgres in a Portable / Relocatable fashion? AJ ONeal 23:27
Re: How to Build Postgres in a Portable / Relocatable fashion? Tom Lane 23:44

May 4, 2024

Thread Author Time
Re: How to Build Postgres in a Portable / Relocatable fashion? Bruce Momjian 00:07
Re: How to Build Postgres in a Portable / Relocatable fashion? AJ ONeal 00:12
Re: How to Build Postgres in a Portable / Relocatable fashion? Adrian Klaver 00:29
Re: How to Build Postgres in a Portable / Relocatable fashion? Bruce Momjian 00:35
Re: How to Build Postgres in a Portable / Relocatable fashion? Adrian Klaver 02:35
Re: How to Build Postgres in a Portable / Relocatable fashion? Tom Lane 02:44
Re: Question regarding how databases support atomicity Siddharth Jain 03:02
Re: Question regarding how databases support atomicity David G. Johnston 03:10
Re: Question regarding how databases support atomicity David G. Johnston 03:13
Re: Question regarding how databases support atomicity Christophe Pettus 03:20
Re: Question regarding how databases support atomicity Tom Lane 03:29
Re: \dt shows table but \d <table> says the table doesn't exist ? jian he 03:40
Re: \dt shows table but \d <table> says the table doesn't exist ? Tom Lane 03:51
Re: \dt shows table but \d <table> says the table doesn't exist ? David G. Johnston 04:06
Re: \dt shows table but \d <table> says the table doesn't exist ? Tom Lane 04:14
Re: \dt shows table but \d <table> says the table doesn't exist ? Adrian Klaver 04:22
Re: \dt shows table but \d <table> says the table doesn't exist ? David G. Johnston 04:47
Re: \dt shows table but \d <table> says the table doesn't exist ? Tom Lane 04:57
Re: How to Build Postgres in a Portable / Relocatable fashion? grimy.outshine830 17:56
Re: I have ansible for postgres-etcd-patroni Vijaykumar Jain 20:35

May 5, 2024

Thread Author Time
Re: \dt shows table but \d <table> says the table doesn't exist ? hubert depesz lubaczewski 08:32

May 6, 2024

Thread Author Time
Re: I have ansible for postgres-etcd-patroni Kashif Zeeshan 04:00
Clarification Needed on Postgresql License Requirement for Hybrid Environment Cluster Configuration Prasanna Chavan 08:15
Extension uninstall issue with PGXS 📎 Philippe BEAUDOIN 08:29
problem loading shared lib pg_tde.so Matthias Apitz 11:05
Re: Clarification Needed on Postgresql License Requirement for Hybrid Environment Cluster Configuration Alvaro Herrera 12:09
Re: problem loading shared lib pg_tde.so Adrian Klaver 14:42
Re: problem loading shared lib pg_tde.so Adrian Klaver 14:45

May 7, 2024

Thread Author Time
Re: problem loading shared lib pg_tde.so Matthias Apitz 05:07
Re: problem loading shared lib pg_tde.so Matthias Apitz 05:53
RE: Restore of a reference database kills the auto analyze processing. HORDER Philip 09:30
RE: Restore of a reference database kills the auto analyze processing. HORDER Philip 09:38
pg_basebackup "Permission denied" error when initiating streaming replication Frans Simmelvuo (Papula-Nevinpat) 10:28
Forcing INTERVAL days display, even if the interval is less than one day Ron Johnson 15:08
Re: Restore of a reference database kills the auto analyze processing. Adrian Klaver 15:24
Re: Restore of a reference database kills the auto analyze processing. Adrian Klaver 15:28
Re: Question regarding how databases support atomicity Siddharth Jain 16:48
Re: Forcing INTERVAL days display, even if the interval is less than one day Tom Lane 16:57
Re: Question regarding how databases support atomicity Tom Lane 17:04
Re: Question regarding how databases support atomicity Adrian Klaver 17:15
Re: Forcing INTERVAL days display, even if the interval is less than one day Greg Sabino Mullane 19:47
Using GIN Index to see if a nested key exists in JSONB Mike Jarmy 21:04

May 8, 2024

Thread Author Time
Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour. buggedme 00:20
Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour. Greenhorn 01:20
Re-2: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour. Sacha Kerres 03:37
Unexpected data when subscribing to logical replication slot Daniel McKenzie 09:17
Re: Unexpected data when subscribing to logical replication slot Tomas Vondra 11:32
How to change NUMERIC type under a domain without rewriting a table? Marcin Barczyński 13:41
Re: Need help migrating MSSQL2008R2 tables into PGSQL & make PGSQL mimic MSSQL behaviour. Laurenz Albe 14:55
Re: Unexpected data when subscribing to logical replication slot Adrian Klaver 15:17
Re: Unexpected data when subscribing to logical replication slot Daniel McKenzie 15:24
Re: Unexpected data when subscribing to logical replication slot Adrian Klaver 16:28

May 9, 2024

Thread Author Time
Postgresql active-active nodes in cluster Vidyashree H S 06:54
Re: Unexpected data when subscribing to logical replication slot Daniel McKenzie 07:32
Re: Postgresql active-active nodes in cluster Kashif Zeeshan 10:58
Re: Unexpected data when subscribing to logical replication slot Adrian Klaver 15:07
Re: Unexpected data when subscribing to logical replication slot Torsten Förtsch 15:14
Re: Unexpected data when subscribing to logical replication slot Torsten Förtsch 15:16
Re: Unexpected data when subscribing to logical replication slot Adrian Klaver 16:45
Re: Postgresql active-active nodes in cluster Greg Sabino Mullane 22:33
Re: Postgresql active-active nodes in cluster Bruce Momjian 23:23

May 10, 2024

Thread Author Time
Question on roles and privileges yudhi s 04:33
Re: Postgresql active-active nodes in cluster Vidyashree H S 05:18
Re: Question on roles and privileges Lok P 06:01
Re: Question on roles and privileges yudhi s 06:05
Scenarios that Replication Slot will be Marked as Active = false Avi Weinberg 11:18
Re: Unexpected data when subscribing to logical replication slot Daniel McKenzie 12:11
SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 18:38
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 19:24
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 19:35
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Tom Lane 20:22

May 11, 2024

Thread Author Time
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 01:10
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Tom Lane 01:33
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions David Rowley 01:35
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions David Rowley 01:37
Unnecessary buffer usage with multicolumn index, row comparison, and equility constraint WU Yan 03:27
Re: Unnecessary buffer usage with multicolumn index, row comparison, and equility constraint Ron Johnson 04:05
Re: Unnecessary buffer usage with multicolumn index, row comparison, and equility constraint Tom Lane 04:18
Feature Request: Option for TLS no SSLRequest with psql AJ ONeal 15:19
Feature Request: Add "pg" as TLS-ALPN AJ ONeal 15:34
Re: Feature Request: Option for TLS no SSLRequest with psql Tom Lane 15:59
Re: Feature Request: Option for TLS no SSLRequest with psql Joe Conway 15:59
Re: Feature Request: Option for TLS no SSLRequest with psql Joe Conway 16:01

May 13, 2024

Thread Author Time
Re: Postgresql active-active nodes in cluster Vidyashree H S 06:38
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 12:27
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 12:41
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 12:46
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions David Rowley 13:22
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions David Rowley 13:32
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions David Rowley 13:34
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 13:52
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 14:07
how to completely turn off statement error logging Zwettler Markus (OIZ) 14:10
Re: Postgresql active-active nodes in cluster Greg Sabino Mullane 14:13
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions David Rowley 14:15
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions David Rowley 14:22
Re: how to completely turn off statement error logging Tom Lane 14:26
AW: [Extern] Re: how to completely turn off statement error logging Zwettler Markus (OIZ) 15:00
Re: how to completely turn off statement error logging David G. Johnston 15:14
UTC is not a time zone? Christophe Pettus 17:37
Re: UTC is not a time zone? Adrian Klaver 17:48
Re: UTC is not a time zone? Christophe Pettus 17:50
Re: UTC is not a time zone? Erik Wienhold 17:53
Re: UTC is not a time zone? Christophe Pettus 17:58
Re: UTC is not a time zone? Adrian Klaver 17:58
Re: UTC is not a time zone? Christophe Pettus 18:02
Re: UTC is not a time zone? Adrian Klaver 18:07
Re: UTC is not a time zone? Christophe Pettus 18:09
Re: UTC is not a time zone? Tom Lane 18:17
Re: UTC is not a time zone? Christophe Pettus 18:18
Re: UTC is not a time zone? Adrian Klaver 18:26
Re: UTC is not a time zone? Christophe Pettus 18:27
Re: UTC is not a time zone? Tom Lane 18:27
Re: UTC is not a time zone? Tom Lane 18:36

May 14, 2024

Thread Author Time
Valid until Rama Krishnan 07:57
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 12:55
Re: Valid until Adrian Klaver 15:27
Re: Valid until Tom Lane 15:45
Re: Valid until Muhammad Imtiaz 15:52
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 16:14
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 18:11
Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions Dimitrios Apostolou 18:26
Adding constraints faster sud 19:59
Using ALTER TABLE DETACH PARTITION CONCURRENTLY inside a procedure Dirschel, Steve 20:24
pg_stat_io clarifications: background worker, writes and reads Dimitrios Apostolou 20:26
Re: Using ALTER TABLE DETACH PARTITION CONCURRENTLY inside a procedure Alvaro Herrera 20:45

May 15, 2024

Thread Author Time
Re: Adding constraints faster sud 03:02
Re: pg_stat_io clarifications: background worker, writes and reads Kashif Zeeshan 04:03
Re: pg_stat_io clarifications: background worker, writes and reads Muhammad Imtiaz 04:21
Sequence values change during upgrade Danut Soare 08:03
problem with query Sašo Gantar 08:07
RE: Restore of a reference database kills the auto analyze processing. 📎 HORDER Philip 08:08
Re: Sequence values change during upgrade Laurenz Albe 11:01
Re: problem with query David Rowley 11:23
Re: Sequence values change during upgrade Danut Soare 12:17
Re: pg_stat_io clarifications: background worker, writes and reads Dimitrios Apostolou 12:59
Re: Sequence values change during upgrade Laurenz Albe 14:29
Re: pg_stat_io clarifications: background worker, writes and reads Kashif Zeeshan 14:32
Re: Restore of a reference database kills the auto analyze processing. Adrian Klaver 15:11
Seeing new stuff in log after upgrading from 11 to 15 Dmitry O Litvintsev 23:27
Re: Seeing new stuff in log after upgrading from 11 to 15 Tom Lane 23:50

May 16, 2024

Thread Author Time
Re: Seeing new stuff in log after upgrading from 11 to 15 Dmitry O Litvintsev 00:00
db was corrupted, ERROR: cannot freeze committed xmax; fix by deleting rows in catalog tables milist ujang 04:01
Re: [UNVERIFIED SENDER] pg_upgrade can result in early wraparound on databases with high transaction load 📎 Daniel Gustafsson 06:11
Re: Restore of a reference database kills the auto analyze processing. HORDER Philip 10:08
Re: Restore of a reference database kills the auto analyze processing. Adrian Klaver 14:28
Re: Restore of a reference database kills the auto analyze processing. HORDER Philip 14:38
Re: Restore of a reference database kills the auto analyze processing. Adrian Klaver 15:39
Re: Restore of a reference database kills the auto analyze processing. HORDER Philip 15:59
Re: Restore of a reference database kills the auto analyze processing. Adrian Klaver 16:13
Re: [UNVERIFIED SENDER] pg_upgrade can result in early wraparound on databases with high transaction load Tom Lane 17:47

May 17, 2024

Thread Author Time
Do we have any email discussions related to SQL rate limiting? Benjamin Mitchell 06:59
Re: Do we have any email discussions related to SQL rate limiting? Laurenz Albe 11:56
Re: [UNVERIFIED SENDER] pg_upgrade can result in early wraparound on databases with high transaction load Daniel Gustafsson 12:35
utf8 vs UTF-8 Troels Arvin 12:44

Browse Archives

Prev | Next