Mailing lists [pgsql-general]

1 June 2019

• 05:52   Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx
• 05:53   Re: psql: FATAL: the database system is starting up Tom K
• 10:44   Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx
• 11:24   Re: Questions about btree_gin vs btree_gist for low cardinalitycolumns Gavin Flower
• 12:02   Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx
• 16:53   Re: Questions about btree_gin vs btree_gist for low cardinalitycolumns Peter J. Holzer
• 16:55   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 22:32   Re: psql: FATAL: the database system is starting up Tom K
• 22:42   Re: psql: FATAL: the database system is starting up Tom K
• 23:11   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 23:52   Re: psql: FATAL: the database system is starting up Adrian Klaver

2 June 2019

• 00:08   Re: psql: FATAL: the database system is starting up Tom K
• 00:24   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 00:30   Re: psql: FATAL: the database system is starting up Tom K
• 00:31   Re: psql: FATAL: the database system is starting up Tom K
• 00:46   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 00:51   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 01:05   Re: psql: FATAL: the database system is starting up Tom K
• 01:14   Re: psql: FATAL: the database system is starting up Tom K
• 01:36   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 01:39   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 01:48   Re: psql: FATAL: the database system is starting up Tom K
• 01:56   Re: psql: FATAL: the database system is starting up Tom K
• 02:10   Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx
• 02:12   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 02:22   Re: psql: FATAL: the database system is starting up Tom K
• 02:30   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 02:33   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 02:47   Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx
• 03:21   Re: psql: FATAL: the database system is starting up Tom K
• 03:25   Re: psql: FATAL: the database system is starting up Tom K
• 03:32   Re: psql: FATAL: the database system is starting up Tom K
• 03:36   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 03:50   Re: psql: FATAL: the database system is starting up Tom K
• 03:53   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 06:07   Re: psql: FATAL: the database system is starting up Tom K
• 10:37   Re: Questions about btree_gin vs btree_gist for low cardinalitycolumns Peter J. Holzer
• 11:03   Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx
• 18:46   Re: psql: FATAL: the database system is starting up Adrian Klaver
• 19:25   Re: Questions about btree_gin vs btree_gist for low cardinality columns Jeff Janes
• 21:14   Re: psql: FATAL: the database system is starting up Tom K
• 23:47   Re: psql: FATAL: the database system is starting up Adrian Klaver

3 June 2019

• 02:07   Re: Questions about btree_gin vs btree_gist for low cardinality columns Tom Lane
• 02:10   PG10 upgrade issue Zahir Lalani
• 02:18   Re: PG10 upgrade issue Tom Lane
• 02:52   Re: PG10 upgrade issue Zahir Lalani
• 03:24   Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx
• 07:48   Re: psql: FATAL: the database system is starting up Tom K
• 12:28   RE: Questions about btree_gin vs btree_gist for low cardinalitycolumns Steven Winfield
• 12:55   Cause: org.postgresql.util.PSQLException: ERROR: could not resizeshared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No spaceleft on device Daulat Ram
• 13:03   CREATE DATABASE ... TEMPLATE ... vs checksums Karsten Hilbert
• 13:11   Re: Questions about btree_gin vs btree_gist for low cardinality columns Morris de Oryx
• 13:33   RE: Questions about btree_gin vs btree_gist for low cardinalitycolumns Steven Winfield
• 17:10   Re: Postgresql backup via LVM snapshot? Bruno Lavoie
• 18:23   Re: Postgresql backup via LVM snapshot? Fabio Ugo Venchiarutti
• 19:00   One way replication in PostgreSQL PALAYRET Jacques
• 19:13   Re: One way replication in PostgreSQL Stephen Frost
• 19:18   Re: One way replication in PostgreSQL Fabio Pardi
• 20:06   Re: Cause: org.postgresql.util.PSQLException: ERROR: could not resizeshared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No spaceleft on device Thomas Munro

4 June 2019

• 01:56   Requirement PA-DSS 1.1.4 Jan Bilek
• 02:17   Re: Questions about btree_gin vs btree_gist for low cardinality columns Peter Geoghegan
• 02:39   Re: One way replication in PostgreSQL Frank Alberto Rodriguez
• 05:00   csvlog Behavior when log file missing Lesley Kimmel
• 05:05   Re: Questions about btree_gin vs btree_gist for low cardinality columns Jeff Janes
• 05:42   Fwd: SSL Error: Certificate verify fail Richard Webb
• 09:54   Re: csvlog Behavior when log file missing Laurenz Albe
• 10:02   Re: One way replication in PostgreSQL PALAYRET Jacques
• 10:33   Re: One way replication in PostgreSQL Guillaume Lelarge
• 11:04   Re: One way replication in PostgreSQL Achilleas Mantzios
• 11:50   psql \copy 
• 11:59   Re: psql \copy Pavel Stehule
• 12:00   Research on ?? operators Matteo Beccati
• 13:02   Two small questions re/ COPY CSV data into table Matthias Apitz
• 13:32   Re: Two small questions re/ COPY CSV data into table Andrew Gierth
• 13:38   Re: Research on ?? operators Andrew Gierth
• 13:49   Re: Research on ?? operators Steve Atkins
• 13:55   Re: Research on ?? operators Matteo Beccati
• 14:01   Re: Research on ?? operators Matteo Beccati
• 15:35   Re: Research on ?? operators Michael Lewis
• 15:40   Re: Research on ?? operators Matteo Beccati
• 15:44   Re: Research on ?? operators Steve Atkins
• 16:37   Re: Questions about btree_gin vs btree_gist for low cardinality columns Jeremy Finzel
• 18:03   Re: Two small questions re/ COPY CSV data into table Matthias Apitz
• 18:41   Re: Two small questions re/ COPY CSV data into table Andrew Gierth
• 18:54   Long running query - connection and keepalives enabled but query notcanceled Tomasz Ostrowski
• 19:24   Re: Long running query - connection and keepalives enabled butquery not canceled Laurenz Albe
• 19:26   Re: Two small questions re/ COPY CSV data into table Matthias Apitz
• 19:29   Re: One way replication in PostgreSQL Frank Alberto Rodriguez
• 19:54   Query very different speeds on seemingly similar data Rob Northcott
• 19:56   Re: Two small questions re/ COPY CSV data into table Andrew Gierth
• 20:18   Re: psql \copy 
• 20:20   Re: Two small questions re/ COPY CSV data into table Matthias Apitz
• 20:51   Re: Two small questions re/ COPY CSV data into table Andrew Gierth
• 22:12   Re: Two small questions re/ COPY CSV data into table Francisco Olarte
• 23:15   dump and restore ordered by schema or table name PegoraroF10
• 23:28   Re: dump and restore ordered by schema or table name Fabrízio de Royes Mello

5 June 2019

• 00:49   postgresql11-devel RPM is missing from "Direct RPM downloads" Dmitry O Litvintsev
• 01:29   Converting yes or no to one letter strings. Lou
• 02:01   Re: Converting yes or no to one letter strings. Rich Shepard
• 02:03   Re: Converting yes or no to one letter strings. Ray O'Donnell
• 02:23   Re: Converting yes or no to one letter strings. David G. Johnston
• 02:29   Re: Converting yes or no to one letter strings. David G. Johnston
• 02:44   Re: Converting yes or no to one letter strings. Rich Shepard
• 03:19   Re: Converting yes or no to one letter strings. Adrian Klaver
• 03:47   Re: Query very different speeds on seemingly similar data David Rowley
• 05:27   Re: Converting yes or no to one letter strings. Ron
• 09:11   granting right to create and delete just one database Chris Withers
• 10:04   Re: postgresql11-devel RPM is missing from "Direct RPM downloads" Jakub Olczyk
• 11:05   RE: Query very different speeds on seemingly similar data Rob Northcott
• 11:52   Re: granting right to create and delete just one database Laurenz Albe
• 11:56   Re: granting right to create and delete just one database Chris Withers
• 13:39   Re: Long running query - connection and keepalives enabled but querynot canceled Tomasz Ostrowski
• 13:48   pg_repack issue Prakash Ramakrishnan
• 14:14   Re: Long running query - connection and keepalives enabled but querynot canceled Dmitry Vasiliev
• 14:53   Re: pg_repack issue Peter Eisentraut
• 14:55   Re: pg_repack issue Prakash Ramakrishnan
• 15:07   Re: Two small questions re/ COPY CSV data into table Matthias Apitz
• 15:46   Re: pg_repack issue Sathish Kumar
• 15:46   Postgresql-11 confusing situtation Domen Šetar
• 15:48   Re: pg_repack issue Prakash Ramakrishnan
• 16:24   Re: pg_repack issue Sathish Kumar
• 17:07   Re: Long running query - connection and keepalives enabled but querynot canceled Dmitry Vasiliev
• 17:14   Re: Postgresql-11 confusing situtation Adrian Klaver
• 17:16   Re: pg_repack issue Prakash Ramakrishnan
• 17:20   Re: Converting yes or no to one letter strings. Adrian Klaver
• 17:38   Re: Postgresql-11 confusing situtation Achilleas Mantzios
• 17:47   verify checksums / CREATE DATABASE Karsten Hilbert
• 17:48   configure multiple repository path in pgbackrest Pavan Kumar
• 17:48   configure multiple repository path in pgbackrest Pavan Kumar
• 17:49   Re: verify checksums / CREATE DATABASE Magnus Hagander
• 18:00   Re: granting right to create and delete just one database Laurenz Albe
• 18:08   Advice on setting cost for function guyren@relevantlogic.com
• 18:09   Re: configure multiple repository path in pgbackrest Ron
• 20:01   Re: postgresql11-devel RPM is missing from "Direct RPM downloads" Dmitry O Litvintsev
• 20:12   Re: Converting yes or no to one letter strings. Christopher Browne
• 20:12   Flood Warning message : user=[iso-8859-1],db=[iso-8859-1],host= WARNING:pg_getnameinfo_all() failed: Temporary failure in name resolution Perumal Raj
• 21:07   Re: Flood Warning message : user=[iso-8859-1],db=[iso-8859-1],host=WARNING: pg_getnameinfo_all() failed: Temporary failure in name resolution Steve Crawford
• 22:43   Re: configure multiple repository path in pgbackrest Pavan Kumar
• 22:49   Re: configure multiple repository path in pgbackrest Stephen Frost
• 22:53   Re: configure multiple repository path in pgbackrest Ron

6 June 2019

• 02:19   Re: Flood Warning message : user=[iso-8859-1],db=[iso-8859-1],host=WARNING: pg_getnameinfo_all() failed: Temporary failure in name resolution bricklen
• 02:23   RE: Requirement PA-DSS 1.1.4 Jan Bilek
• 02:56   Re: Flood Warning message : user=[iso-8859-1],db=[iso-8859-1],host=WARNING: pg_getnameinfo_all() failed: Temporary failure in name resolution Perumal Raj
• 07:24   Re: Requirement PA-DSS 1.1.4 Pavel Stehule
• 07:41   Re: Requirement PA-DSS 1.1.4 Benjamin Scherrey
• 11:14   Re: Requirement PA-DSS 1.1.4 Karsten Hilbert
• 11:37   Re: Postgresql-11 confusing situtation Jakub Olczyk
• 13:30   Re: Table partition with primary key in 11.3 Alex V.
• 14:02   postgres 11 issue? Steve Rogerson
• 16:35   Re: postgres 11 issue? Adrian Klaver
• 16:50   pg_dump include/exclude data, was: verify checksums / CREATE DATABASE Karsten Hilbert
• 17:40   Postgres 10.7 Systemd Startup Issue Kelly, Kevin
• 17:47   Copyright and bundling the installer Kyle Lee
• 18:12   Re: postgres 11 issue? Steve Rogerson
• 18:47   Question about funding development Dan Collens
• 19:06   Re: postgres 11 issue? Alvaro Herrera
• 20:03   Re: Table partition with primary key in 11.3 Alvaro Herrera
• 20:25   Re: Flood Warning message : user=[iso-8859-1],db=[iso-8859-1],host=WARNING: pg_getnameinfo_all() failed: Temporary failure in name resolution Perumal Raj
• 20:44   Re: Postgres 10.7 Systemd Startup Issue Francisco Olarte
• 21:15   RE: Postgres 10.7 Systemd Startup Issue Kelly, Kevin
• 21:23   Re: Table partition with primary key in 11.3 Simon Riggs
• 23:48   Re: Table partition with primary key in 11.3 Peter Geoghegan

7 June 2019

• 01:00   Re: Table partition with primary key in 11.3 David Rowley
• 01:37   Re: postgres 11 issue? Adrian Klaver
• 02:51   RE: Requirement PA-DSS 1.1.4 Jan Bilek
• 03:19   Re: Postgres 10.7 Systemd Startup Issue Tom Lane
• 04:18   Re: Postgres 10.7 Systemd Startup Issue Christopher Browne
• 11:44   Re: Snowball Stemming Greek support not included in Release 12 beta Achilleas Mantzios
• 11:58   Re: Snowball Stemming Greek support not included in Release 12 beta Achilleas Mantzios
• 12:04   Re: Snowball Stemming Greek support not included in Release 12 beta Kostis Michail
• 13:01   delimeters psql /CSV 
• 13:12   Re: Snowball Stemming Greek support not included in Release 12 beta Adrien Nayrat
• 13:19   Re: Snowball Stemming Greek support not included in Release 12 beta Tasks
• 13:31   Re: Snowball Stemming Greek support not included in Release 12 beta Adrien Nayrat
• 13:55   Re: Postgres 10.7 Systemd Startup Issue Francisco Olarte
• 14:24   RE: Copyright and bundling the installer Kyle Lee
• 14:24   Re: delimeters psql /CSV Ron
• 14:58   Strange connection limit problem Ict Security
• 15:02   Re: delimeters psql /CSV Daniel Verite
• 15:30   SV: delimeters psql /CSV 
• 15:45   RE: Postgres 10.7 Systemd Startup Issue Lu, Dan
• 16:24   Re: Strange connection limit problem Laurenz Albe
• 16:28   Re: Strange connection limit problem Giuseppe Sacco
• 16:41   Re: Snowball Stemming Greek support not included in Release 12 beta Tom Lane
• 16:48   RE: Postgres 10.7 Systemd Startup Issue Lu, Dan
• 17:03   Re: Postgres 10.7 Systemd Startup Issue Tom Lane
• 17:10   RE: Postgres 10.7 Systemd Startup Issue Lu, Dan
• 17:11   Re: Postgres 10.7 Systemd Startup Issue Francisco Olarte
• 18:02   Re: pg_dump include/exclude data, was: verify checksums / CREATEDATABASE Adrian Klaver
• 18:41   Re: pg_dump include/exclude data, was: verify checksums / CREATE DATABASE Tom Lane
• 18:58   Re: Table partition with primary key in 11.3 Peter Geoghegan
• 19:09   Re: Table partition with primary key in 11.3 Alvaro Herrera
• 22:03   Re: Table partition with primary key in 11.3 Peter Geoghegan
• 22:18   Re: Table partition with primary key in 11.3 Alvaro Herrera
• 22:22   RE: Postgres 10.7 Systemd Startup Issue Lu, Dan
• 22:25   Re: Table partition with primary key in 11.3 Ravi Krishna
• 22:36   Re: Table partition with primary key in 11.3 Peter Geoghegan
• 22:43   Re: Table partition with primary key in 11.3 Alvaro Herrera
• 22:56   Re: Table partition with primary key in 11.3 Peter Geoghegan
• 23:21   Re: Table partition with primary key in 11.3 Alvaro Herrera

8 June 2019

• 00:13   Re: Table partition with primary key in 11.3 Peter Geoghegan
• 00:35   Re: Table partition with primary key in 11.3 Alvaro Herrera
• 02:58   Re: Table partition with primary key in 11.3 Peter Geoghegan
• 13:31   Re: Postgres 10.7 Systemd Startup Issue Peter J. Holzer
• 14:36   Re: Requirement PA-DSS 1.1.4 Peter J. Holzer

9 June 2019

• 18:28   Inserting into the blob Igor Korot
• 20:06   Re: Inserting into the blob Igor Korot
• 21:51   Connection refused (0x0000274D/10061) Sourav Majumdar
• 22:29   Re: Connection refused (0x0000274D/10061) Adrian Klaver
• 22:43   Re: Connection refused (0x0000274D/10061) Ray O'Donnell
• 22:49   Re: Connection refused (0x0000274D/10061) Sourav Majumdar
• 23:22   Re: unexpected lock waits (was Re: [GENERAL] Do not understand whythis happens) Martijn van Oosterhout
• 23:46   Re: Connection refused (0x0000274D/10061) Ray O'Donnell

10 June 2019

• 00:01   Re: Connection refused (0x0000274D/10061) Adrian Klaver
• 00:09   Re: Connection refused (0x0000274D/10061) Adrian Klaver
• 00:45   General question about OS Drexl Spivey
• 02:22   Re: General question about OS Andy Colson
• 02:33   Re: General question about OS Tim Cross
• 03:29   Re: General question about OS Gavin Flower
• 03:41   Re: General question about OS Adrian Klaver
• 04:15   Re: General question about OS Tom Lane
• 04:57   Re: General question about OS Thomas Kellerer
• 07:14   Re: Inserting into the blob Adrian Klaver
• 07:36   Upgrade from PostgreSQL 9.6 to 11 Pawan Sharma
• 09:00   Re: Upgrade from PostgreSQL 9.6 to 11 Achilleas Mantzios
• 09:36   Re: Upgrade from PostgreSQL 9.6 to 11 Michael Paquier
• 09:52   Re: Upgrade from PostgreSQL 9.6 to 11 Pawan Sharma
• 10:13   Re: Upgrade from PostgreSQL 9.6 to 11 Achilleas Mantzios
• 14:32   Re: Upgrade from PostgreSQL 9.6 to 11 Ron
• 15:40   Re: Inserting into the blob Igor Korot
• 16:38   Re: Inserting into the blob Adrian Klaver
• 17:48   found xmin * from before relfrozenxid * Evaldas Užpalis
• 19:16   Re: Inserting into the blob Igor Korot
• 19:30   Re: Inserting into the blob Igor Korot
• 19:35   Drive Architecture for new PostgreSQL Environment Hilbert, Karin
• 19:51   Re: Drive Architecture for new PostgreSQL Environment Andreas Kretschmer
• 20:08   Re: Inserting into the blob Matthias Apitz
• 20:08   Re: Inserting into the blob Daniel Verite
• 20:50   Re: found xmin * from before relfrozenxid * Jerry Sievers

11 June 2019

• 03:03   Re: Inserting into the blob Adrian Klaver
• 06:32   Re: Inserting into the blob Rob Sargent
• 06:45   Re: Inserting into the blob David G. Johnston
• 06:53   Re: Inserting into the blob Rob Sargent
• 10:15   Re: pg_dump include/exclude data, was: verify checksums / CREATEDATABASE Karsten Hilbert
• 10:27   Re: pg_dump include/exclude data, was: verify checksums / CREATEDATABASE Karsten Hilbert
• 17:16   Re: pg_dump include/exclude data, was: verify checksums / CREATEDATABASE Adrian Klaver
• 20:45   Featured Big Name Users of Postgres Igal Sapir
• 21:15   Aw: Re: pg_dump include/exclude data, was: verify checksums /CREATE DATABASE Karsten Hilbert
• 21:25   Re: Featured Big Name Users of Postgres Andreas Kretschmer
• 22:28   Re: Featured Big Name Users of Postgres Ireneusz Pluta/wp.pl

12 June 2019

• 00:11   Re: Featured Big Name Users of Postgres Chris Travers
• 02:54   Re: Aw: Re: pg_dump include/exclude data, was: verify checksums /CREATE DATABASE Adrian Klaver
• 03:58   Re: Featured Big Name Users of Postgres Igal Sapir
• 04:20   Re: Featured Big Name Users of Postgres Thomas Kellerer
• 14:33   how to upgrade production PostgreSQL from 9.4 to 11.3 Rahul Chordiya
• 16:31   Re: how to upgrade production PostgreSQL from 9.4 to 11.3 Andreas Kretschmer
• 16:52   Re: how to upgrade production PostgreSQL from 9.4 to 11.3 Avinash Kumar
• 20:49   Re: found xmin * from before relfrozenxid * Andrew Gierth

13 June 2019

• 03:36   Re: found xmin * from before relfrozenxid * Evaldas Užpalis
• 04:30   RE: how to upgrade production PostgreSQL from 9.4 to 11.3 Ahmed, Nawaz (Fuji Xerox Australia)
• 18:14   bug regclass::oid John Mikel
• 18:33   Re: bug regclass::oid Adrian Klaver
• 19:56   Re: Connection refused (0x0000274D/10061) Sourav Majumdar
• 21:46   Re: Advice on setting cost for function Tom Lane
• 22:10   RE: Drive Architecture for new PostgreSQL Environment Kevin Brannen
• 23:28   Re: Connection refused (0x0000274D/10061) Adrian Klaver

14 June 2019

• 10:38   How to connect to toad Edge with postgresql running with dockercontainer? Daulat Ram
• 14:09   How to return ARRAY from SQL function? Alexander Farber
• 14:17   Re: How to return ARRAY from SQL function? Laurenz Albe
• 16:25   Re: How to return ARRAY from SQL function? Tom Lane
• 16:47   Re: How to connect to toad Edge with postgresql running with dockercontainer? Adrian Klaver
• 17:01   checkpoints taking much longer than expected Tiemen Ruiten
• 17:20   Re: checkpoints taking much longer than expected Ravi Krishna
• 18:36   Re: checkpoints taking much longer than expected Stephen Frost
• 18:43   Re: checkpoints taking much longer than expected Stephen Frost
• 19:22   Re: checkpoints taking much longer than expected Peter J. Holzer
• 19:35   PostgreSQL 10 and OpenSSL 1.1 Shane Duan
• 21:05   Re: PostgreSQL 10 and OpenSSL 1.1 Adrian Klaver
• 21:23   Re: PostgreSQL 10 and OpenSSL 1.1 Shane Duan
• 21:52   Re: PostgreSQL 10 and OpenSSL 1.1 Adrian Klaver
• 22:55   vacuum/reindex Rob Sargent
• 23:13   Re: vacuum/reindex Ron
• 23:19   Re: vacuum/reindex Rob Sargent

15 June 2019

• 00:04   Copy Bulk Ignore Duplicated Leandro Guimarães
• 00:59   Re: Copy Bulk Ignore Duplicated Adrian Klaver
• 01:05   Re: Copy Bulk Ignore Duplicated Adrian Klaver
• 01:38   Re: Copy Bulk Ignore Duplicated Tim Cross
• 05:24   Re: Copy Bulk Ignore Duplicated Leandro Guimarães
• 05:26   Re: Copy Bulk Ignore Duplicated Leandro Guimarães
• 09:19   how to concat/concat_ws all fields without braces Jean Louis
• 09:32   arrays of composite types, and client drivers like JDBC Rob Nikander
• 11:49   Re: checkpoints taking much longer than expected Tiemen Ruiten
• 12:36   Re: how to concat/concat_ws all fields without braces Pavel Stehule
• 12:36   Re: how to concat/concat_ws all fields without braces Thomas Kellerer
• 13:47   Re: arrays of composite types, and client drivers like JDBC Dave Cramer
• 16:44   Re: Copy Bulk Ignore Duplicated Adrian Klaver
• 17:20   Re: how to concat/concat_ws all fields without braces Jean Louis
• 17:22   Re: how to concat/concat_ws all fields without braces Jean Louis
• 17:37   Re: how to concat/concat_ws all fields without braces Pavel Stehule

16 June 2019

• 03:35   Re: checkpoints taking much longer than expected Peter Geoghegan
• 17:22   Re: checkpoints taking much longer than expected Michael Loftis
• 19:03   Re: bug regclass::oid John Mikel
• 19:25   Re: checkpoints taking much longer than expected Jeff Janes
• 20:30   Re: checkpoints taking much longer than expected Stephen Frost
• 20:37   Re: checkpoints taking much longer than expected Stephen Frost
• 21:12   Re: bug regclass::oid Peter J. Holzer
• 21:32   Re: bug regclass::oid Tom Lane
• 21:35   Re: bug regclass::oid Tom Lane
• 21:57   Re: checkpoints taking much longer than expected Alvaro Herrera
• 23:17   Re: checkpoints taking much longer than expected Tiemen Ruiten
• 23:37   Re: checkpoints taking much longer than expected Stephen Frost
• 23:45   unexpected behavior with pglogical -- bug? Torsten Förtsch

17 June 2019

• 00:00   Re: checkpoints taking much longer than expected Alvaro Herrera
• 00:08   Re: checkpoints taking much longer than expected Tiemen Ruiten
• 00:09   Re: checkpoints taking much longer than expected Stephen Frost
• 00:16   Re: checkpoints taking much longer than expected Stephen Frost
• 00:30   Re: checkpoints taking much longer than expected Alvaro Herrera
• 00:31   Re: checkpoints taking much longer than expected Stephen Frost
• 08:09   Re: arrays of composite types, and client drivers like JDBC Rob Nikander
• 08:34   Async client libraries - not worth it?  Rob Nikander
• 11:58   Re: bug regclass::oid John Mikel
• 13:12   Re: Async client libraries - not worth it? Dave Cramer
• 14:35   Re: Async client libraries - not worth it?  Rob Nikander
• 15:29   Re: checkpoints taking much longer than expected Tiemen Ruiten
• 15:57   Re: Async client libraries - not worth it? Dave Cramer
• 16:43   Re: Async client libraries - not worth it?  Rob Nikander
• 17:00   Re: Async client libraries - not worth it? Dave Cramer
• 17:11   Re: bug regclass::oid Adrian Klaver
• 18:14   Re: Copy Bulk Ignore Duplicated Leandro Guimarães
• 18:45   Re: Copy Bulk Ignore Duplicated Adrian Klaver
• 18:59   psql timeout option Jesús Gómez
• 19:06   Re: psql timeout option Adrian Klaver
• 19:22   Re: Copy Bulk Ignore Duplicated Adrian Klaver
• 20:01   Re: Copy Bulk Ignore Duplicated Adrian Klaver
• 20:04   Re: Copy Bulk Ignore Duplicated Leandro Guimarães
• 20:43   Re: checkpoints taking much longer than expected Andres Freund
• 21:56   Re: Copy Bulk Ignore Duplicated Adrian Klaver
• 22:01   Re: Copy Bulk Ignore Duplicated Leandro Guimarães
• 23:50   perf tuning for 28 cores and 252GB RAM Michael Curry

18 June 2019

• 01:03   psql UPDATE field [tab] expands to DEFAULT? Ken Tanzer
• 02:04   Re: Copy Bulk Ignore Duplicated Adrian Klaver
• 02:24   Re: psql UPDATE field [tab] expands to DEFAULT? Adrian Klaver
• 02:33   Re: psql UPDATE field [tab] expands to DEFAULT? Ken Tanzer
• 02:45   Re: perf tuning for 28 cores and 252GB RAM Jeff Janes
• 02:54   Inserts restricted to a trigger Miles Elam
• 03:09   Re: psql UPDATE field [tab] expands to DEFAULT? Tim Cross
• 03:22   Re: psql UPDATE field [tab] expands to DEFAULT? Adrian Klaver
• 03:23   Re: psql UPDATE field [tab] expands to DEFAULT? Jeff Janes
• 03:29   Re: Inserts restricted to a trigger Adrian Klaver
• 03:34   Re: psql UPDATE field [tab] expands to DEFAULT? Jeff Janes
• 03:39   Re: psql UPDATE field [tab] expands to DEFAULT? Tom Lane
• 03:47   Re: Inserts restricted to a trigger raf@raf.org
• 03:52   Re: psql UPDATE field [tab] expands to DEFAULT? Tim Cross
• 11:06   Re: Connection refused (0x0000274D/10061) Sourav Majumdar
• 12:57   Re: Copy Bulk Ignore Duplicated Peter J. Holzer
• 15:20   Re: How to return ARRAY from SQL function? Alexander Farber
• 16:10   Re: How to return ARRAY from SQL function? Tom Lane
• 16:57   Re: Connection refused (0x0000274D/10061) Adrian Klaver
• 17:15   Re: Connection refused (0x0000274D/10061) Moreno Andreo
• 18:48   Re: perf tuning for 28 cores and 252GB RAM Michael Lewis
• 19:06   Re: perf tuning for 28 cores and 252GB RAM Merlin Moncure
• 19:13   Re: perf tuning for 28 cores and 252GB RAM Fabio Ugo Venchiarutti
• 19:18   Re: perf tuning for 28 cores and 252GB RAM Andres Freund
• 19:20   Is array_append O(n)? Rob Nikander
• 19:30   Re: Inserts restricted to a trigger Miles Elam
• 19:32   RE: Connection refused (0x0000274D/10061) Igor Neyman
• 19:33   Re: perf tuning for 28 cores and 252GB RAM Alvaro Herrera
• 19:37   Re: Is array_append O(n)? Alvaro Herrera
• 19:47   Re: Inserts restricted to a trigger Torsten Förtsch
• 19:48   Re: Is array_append O(n)? Rob Nikander
• 19:48   Re: perf tuning for 28 cores and 252GB RAM Andres Freund
• 20:14   Re: Inserts restricted to a trigger Miles Elam
• 20:47   Re: Is array_append O(n)? Tom Lane
• 21:02   delete inside for plpgsql loop on same relation? Rob Nikander
• 21:08   Re: perf tuning for 28 cores and 252GB RAM Michael Curry
• 21:10   Re: perf tuning for 28 cores and 252GB RAM Andres Freund
• 21:20   Re: delete inside for plpgsql loop on same relation? Tom Lane

19 June 2019

• 01:23   Re: psql UPDATE field [tab] expands to DEFAULT? Ken Tanzer
• 04:03   Re: psql UPDATE field [tab] expands to DEFAULT? Adrian Klaver
• 04:20   Re: Inserts restricted to a trigger Adrian Klaver
• 11:46   Re: unexpected behavior with pglogical -- bug? Achilleas Mantzios
• 19:06   Problem with row-level lock Job
• 22:31   First Time Starting Up PostgreSQL and Having Problems Brent Bates
• 22:51   Re: First Time Starting Up PostgreSQL and Having Problems Tom Lane
• 23:28   RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and HavingProblems Brent Bates
• 23:49   Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems Tom Lane

20 June 2019

• 00:00   Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and HavingProblems Rob Sargent
• 01:07   Re: Inserts restricted to a trigger Miles Elam
• 02:03   Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems Andrew Gierth
• 06:56   Row data is reflected in DETAIL message when constraints fail on insert/update William Denton
• 07:13   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Adrian Klaver
• 09:38   How can generate alter sequence and drop constraints statements viaora2pg Daulat Ram
• 12:23   Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and HavingProblems pbj@cmicdo.com
• 14:26   Re: Row data is reflected in DETAIL message when constraints fail on insert/update Shay Rojansky
• 14:45   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Karsten Hilbert
• 17:12   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Adrian Klaver
• 17:19   Detaching multiple partitions in 1 ALTER TABLE statement Ben Hood
• 17:26   Re: Row data is reflected in DETAIL message when constraints fail on insert/update Tom Lane
• 17:38   Re: Inserts restricted to a trigger Adrian Klaver
• 17:43   RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and HavingProblems Brent Bates
• 17:49   Re: Problem with row-level lock Adrian Klaver
• 17:55   Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems Tom Lane
• 18:01   Re: Inserts restricted to a trigger Adrian Klaver
• 18:22   Re: Row data is reflected in DETAIL message when constraints fail on insert/update Shay Rojansky
• 18:27   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Karsten Hilbert
• 18:34   Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and HavingProblems Ian Barwick
• 18:50   Re: Row data is reflected in DETAIL message when constraints fail on insert/update Shay Rojansky
• 19:00   Re: Detaching multiple partitions in 1 ALTER TABLE statement Simon Riggs
• 19:16   Re: Row data is reflected in DETAIL message when constraints fail on insert/update Tom Lane
• 19:27   Re: Row data is reflected in DETAIL message when constraints fail on insert/update Tom Lane
• 19:42   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Ravi Krishna
• 20:09   Re: Detaching multiple partitions in 1 ALTER TABLE statement Adrian Klaver
• 21:20   Re: Row data is reflected in DETAIL message when constraints fail on insert/update David G. Johnston
• 22:08   Re: Row data is reflected in DETAIL message when constraints fail on insert/update Tom Lane
• 23:03   Why does the pg_dumpall command have a database option? Espresso Beanies
• 23:13   Re: Why does the pg_dumpall command have a database option? Adrian Klaver

21 June 2019

• 00:13   Odd Update Behaviour Harry Ambrose
• 00:16   Re: Odd Update Behaviour David G. Johnston
• 00:32   Need create table statements from metadata David Gauthier
• 00:43   List tables for a specific schema David Gauthier
• 00:50   Re: List tables for a specific schema Adrian Klaver
• 00:59   Re: Need create table statements from metadata Adrian Klaver
• 01:06   Re: List tables for a specific schema Tom Lane
• 01:25   Re: Need create table statements from metadata Adrian Klaver
• 01:30   Re: Inserts restricted to a trigger Miles Elam
• 08:21   perl extension error Prakash Ramakrishnan
• 08:40   Index with new opclass not used for sorting Ancoron Luciferis
• 08:41   Re: perl extension error Ian Barwick
• 11:14   Active connections are terminated because of small wal_sender_timeout AYahorau@ibagroup.eu
• 11:40   R: Problem with row-level lock Job
• 12:57   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Karsten Hilbert
• 14:26   Builds of 11.4 for CentOS/RHEL 7 missing Gabríel Arthúr Pétursson
• 14:46   'too many range table entries' error with partitioned tables andaggregations Floris Van Nee
• 16:32   Re: Why does the pg_dumpall command have a database option? Espresso Beanies
• 16:36   Re: Index with new opclass not used for sorting Tom Lane
• 16:38   Re: Why does the pg_dumpall command have a database option? Ray O'Donnell
• 16:42   got stuck in pglogical upgrade on FreeBSD Rahul Chordiya
• 16:51   Re: Why does the pg_dumpall command have a database option? Adrian Klaver
• 17:04   Re: Builds of 11.4 for CentOS/RHEL 7 missing Adrian Klaver
• 17:12   Re: Builds of 11.4 for CentOS/RHEL 7 missing Gabríel Arthúr Pétursson
• 17:15   Re: got stuck in pglogical upgrade on FreeBSD Adrian Klaver
• 17:21   Re: Builds of 11.4 for CentOS/RHEL 7 missing Adrian Klaver
• 17:33   Re: Builds of 11.4 for CentOS/RHEL 7 missing Gabríel Arthúr Pétursson
• 17:34   Re: R: Problem with row-level lock Adrian Klaver
• 17:37   Re: Builds of 11.4 for CentOS/RHEL 7 missing Adrian Klaver
• 17:40   Re: How can generate alter sequence and drop constraints statementsvia ora2pg Adrian Klaver
• 18:45   Re: got stuck in pglogical upgrade on FreeBSD Rahul Chordiya
• 19:05   Re: got stuck in pglogical upgrade on FreeBSD Adrian Klaver
• 19:07   Re: got stuck in pglogical upgrade on FreeBSD Rahul Chordiya
• 19:11   Re: got stuck in pglogical upgrade on FreeBSD Adrian Klaver
• 19:25   Re: got stuck in pglogical upgrade on FreeBSD Rahul Chordiya
• 19:27   Re: got stuck in pglogical upgrade on FreeBSD Adrian Klaver
• 23:45   Logical decoding plus streaming replication fail-over Igor Polishchuk

22 June 2019

• 00:14   Re: Index with new opclass not used for sorting Ancoron Luciferis
• 02:02   Re: Inserts restricted to a trigger Adrian Klaver
• 13:00   Re: Row data is reflected in DETAIL message when constraints fail on insert/update William Denton
• 14:20   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Joe Conway
• 17:04   LDAP Search failing when i provide Multiple entry in pg_hba.conf Revana Siddu
• 19:40   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Peter J. Holzer
• 20:09   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Karsten Hilbert
• 20:41   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Adrian Klaver
• 23:07   Re: Row data is reflected in DETAIL message when constraints fail oninsert/update Peter J. Holzer

24 June 2019

• 00:28   Re: LDAP Search failing when i provide Multiple entry in pg_hba.conf Thomas Munro
• 12:01   sequences Karl Martin Skoldebrand
• 12:20   Re: got stuck in pglogical upgrade on FreeBSD Rahul Chordiya
• 12:28   Re: sequences Thiemo Kellner
• 13:14   Re: sequences Tim Clarke
• 13:59   Re: Row data is reflected in DETAIL message when constraints fail on insert/update Shay Rojansky
• 14:07   RE: sequences Karl Martin Skoldebrand
• 14:30   Re: got stuck in pglogical upgrade on FreeBSD Achilleas Mantzios
• 17:10   encryption of specific columns Matthias Apitz
• 20:27   RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and HavingProblems Kevin Brannen
• 23:31   Coalesce 2 Arrays Alex Magnum

25 June 2019

• 00:33   Re: Coalesce 2 Arrays Rob Sargent
• 01:25   Need a DB layout gui David Gauthier
• 01:32   Re: Need a DB layout gui Adrian Klaver
• 01:37   Re: Need a DB layout gui Rich Shepard
• 01:38   Re: Need a DB layout gui Adrian Klaver
• 01:44   Re: Need a DB layout gui Brent Wood
• 01:46   Re: Coalesce 2 Arrays Alex Magnum
• 01:55   Re: Need a DB layout gui Tim Clarke
• 02:11   Re: Coalesce 2 Arrays Rob Sargent
• 02:12   Re: Coalesce 2 Arrays Rob Sargent
• 02:19   Re: Coalesce 2 Arrays David G. Johnston
• 02:28   Re: Coalesce 2 Arrays Rob Sargent
• 04:42   minor upgrade Prakash Ramakrishnan
• 05:31   Function Volatility Stable vs Immutable Igal @ Lucee.org
• 05:38   Re: Function Volatility Stable vs Immutable David G. Johnston
• 05:54   Re: Function Volatility Stable vs Immutable Igal @ Lucee.org
• 07:13   Re: minor upgrade Adrian Klaver
• 11:28   Re: Need a DB layout gui Jakub Olczyk
• 12:01   RE: Need a DB layout gui Zahir Lalani
• 15:21   Re: Need a DB layout gui Thiemo Kellner
• 16:49   Connect is not available, request timeout after 30000ms. Pawan Sharma
• 16:55   Re: Connect is not available, request timeout after 30000ms. Adrian Klaver
• 17:06   Re: Connect is not available, request timeout after 30000ms. Pawan Sharma
• 17:14   Re: Connect is not available, request timeout after 30000ms. Adrian Klaver
• 17:24   Re: Connect is not available, request timeout after 30000ms. Pawan Sharma
• 17:33   Re: Connect is not available, request timeout after 30000ms. Adrian Klaver
• 17:43   Re: Connect is not available, request timeout after 30000ms. Pawan Sharma

26 June 2019

• 00:02   RE: Need a DB layout gui Kevin Brannen
• 00:37   Re: Need a DB layout gui David Gauthier
• 00:45   REINDEX : new parameter to preserve current average leaf density asnew implicit FILLFACTOR John Lumby
• 00:56   Re: REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR Tom Lane
• 00:58   Need a referential constraint to a non-unique record David Gauthier
• 01:06   Re: REINDEX : new parameter to preserve current average leaf densityas new implicit FILLFACTOR Peter Geoghegan
• 01:12   Re: REINDEX : new parameter to preserve current average leaf densityas new implicit FILLFACTOR Peter Geoghegan
• 01:18   Re: Need a referential constraint to a non-unique record David G. Johnston
• 03:19   Re: Need a referential constraint to a non-unique record Adrian Klaver
• 09:17   Max_connections limit Daulat Ram
• 10:00   RE: Max_connections limit Ahmed, Nawaz (Fuji Xerox Australia)
• 14:30   Re: How to return ARRAY from SQL function? Alexander Farber
• 16:42   migrating from Oracle to PostgreSQL 11 Hitesh Chadda
• 18:05   Re: REINDEX : new parameter to preserve current average leaf densityas new implicit FILLFACTOR John Lumby
• 18:05   pg_receivelwal vs synchronous Jesper Pedersen
• 18:32   Enabling checksums on a streaming replica Brad Nicholson
• 19:09   Re: REINDEX : new parameter to preserve current average leaf densityas new implicit FILLFACTOR Peter Geoghegan
• 19:37   Re: Enabling checksums on a streaming replica Grigory Smolkin
• 21:08   Re: Re: Enabling checksums on a streaming replica Brad Nicholson

27 June 2019

• 10:49   Re: migrating from Oracle to PostgreSQL 11 Enrico Pirozzi
• 11:28   Postgresql 12 Beta2 Crashes for any Insert/Update Mohsen Bande
• 11:34   patch 11.2 to 11.4 Prakash Ramakrishnan
• 15:37   Re: pg_receivelwal vs synchronous Magnus Hagander
• 15:47   Re: pg_receivelwal vs synchronous Jesper Pedersen
• 16:24   Re: migrating from Oracle to PostgreSQL 11 Steven Lembark
• 16:28   Re: patch 11.2 to 11.4 Fabrízio de Royes Mello
• 16:38   Re: patch 11.2 to 11.4 Prakash Ramakrishnan
• 16:46   In-depth commercial postgresql training Marcelo Lacerda
• 16:49   Re: In-depth commercial postgresql training Fabrízio de Royes Mello
• 19:47   Re: 9.6.11- could not truncate directory "pg_serial": apparent wraparound Pavel Suderevsky
• 20:09   Re: Postgresql 12 Beta2 Crashes for any Insert/Update Peter Geoghegan
• 20:48   pg_dump (COPY) hanging intermittently Ben Snaidero
• 21:34   Re: pg_dump (COPY) hanging intermittently Tom Lane
• 22:07   Re: pg_dump (COPY) hanging intermittently Ben Snaidero
• 22:19   Re: pg_dump (COPY) hanging intermittently Tom Lane

28 June 2019

• 00:46   Re: Need a referential constraint to a non-unique record Adrian Klaver
• 04:01   Re: patch 11.2 to 11.4 Prakash Ramakrishnan
• 06:17   Re: Re: Enabling checksums on a streaming replica Michael Paquier
• 09:35   PostgreSQL 11 Auto vacuum Pawan Sharma
• 14:43   Re: Re: Re: Enabling checksums on a streaming replica Brad Nicholson
• 15:16   Re: patch 11.2 to 11.4 Fabrízio de Royes Mello
• 15:22   Analyze command running for 2063 minutes so far tony@exquisiteimages.com
• 15:25   Re: patch 11.2 to 11.4 Prakash Ramakrishnan
• 17:15   Re: Analyze command running for 2063 minutes so far Tom Lane
• 18:06   Re: Analyze command running for 2063 minutes so far tony@exquisiteimages.com
• 18:09   how to understand checkpoint information in pg_control data Pavan Kumar
• 18:09   how to understand checkpoint information in pg_control data Pavan Kumar
• 22:04   Automatic Failover in PostgreSQL using PAF/repmgr Devendra Y
• 22:11   iterate over partitions Glenn Schultz
• 22:37   Re: PostgreSQL 11 Auto vacuum Michael Lewis

29 June 2019

• 02:41   create extension points to the wrong directory Benedict Holland
• 02:52   Re: create extension points to the wrong directory Rob Sargent
• 03:01   Re: create extension points to the wrong directory Adrian Klaver
• 05:27   Re: Re: Re: Enabling checksums on a streaming replica Michael Paquier
• 05:53   Trigger function does not modify the NEW value Igal @ Lucee.org
• 06:07   Re: Trigger function does not modify the NEW value David Rowley
• 06:13   Re: Trigger function does not modify the NEW value Igal @ Lucee.org
• 10:34   Azure Database for PostgreSQL - how to add pgbouncer or similar? Alexander Farber
• 14:09   Re: Automatic Failover in PostgreSQL using PAF/repmgr Jehan-Guillaume (ioguix) de Rorthais
• 16:59   Re: Azure Database for PostgreSQL - how to add pgbouncer or similar? Adrian Klaver
• 18:33   Re: Azure Database for PostgreSQL - how to add pgbouncer or similar? Alexander Farber
• 19:20   How to get non-existant values as NULL or 0? Pól Ua Laoínecháin
• 19:48   Re: How to get non-existant values as NULL or 0? Pól Ua Laoínecháin

30 June 2019

• 01:33   Re: How to get non-existant values as NULL or 0? Adrian Klaver
• 01:40   Re: Azure Database for PostgreSQL - how to add pgbouncer or similar? Adrian Klaver
• 06:13   Memory settings Daulat Ram
• 06:14   Memory settings Daulat Ram
• 09:04   Re: Memory settings Hans Schou
• 09:49   "Time of latest checkpoint" stays too old on both master and slave rihad
• 09:59   Re: "Time of latest checkpoint" stays too old on both master andslave rihad
• 10:07   Re: "Time of latest checkpoint" stays too old on both master andslave rihad
• 13:59   Re: Postgresql 12 Beta2 Crashes for any Insert/Update Mohsen Bande
• 15:47   Re: Postgresql 12 Beta2 Crashes for any Insert/Update Mohsen Bande
• 20:45   Re: "Time of latest checkpoint" stays too old on both master and slave Andrew Gierth
• 20:55   Re: "Time of latest checkpoint" stays too old on both master andslave rihad