Home > mailing lists

Mailing lists [pgsql-general]

1 July 2020

00:03 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device FOUTE K. Jaurès
00:36 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device Adrian Klaver
02:09 restart_lsn is not advancing Radoslav Nedyalkov
02:11 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device raf
04:02 Re: restart_lsn is not advancing Radoslav Nedyalkov
08:51 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device FOUTE K. Jaurès
08:57 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device FOUTE K. Jaurès
09:14 BDR node status stays as C, not ready Emrah Tema
10:43 Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC Rene de Gek
10:59 Re: BDR node status stays as C, not ready Vik Fearing
17:45 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device Adrian Klaver
19:11 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device Alvaro Herrera
19:50 Re: Can't seem to mix an inner and outer join in a query and get it to work right. David Gauthier
21:21 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device FOUTE K. Jaurès
21:25 Re: Can't seem to mix an inner and outer join in a query and get it to work right. David G. Johnston
21:25 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device FOUTE K. Jaurès

2 July 2020

00:15 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device Adrian Klaver
00:20 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device Adrian Klaver
00:21 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device FOUTE K. Jaurès
02:39 Different results from identical matviews Anders Steinlein
02:59 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device Adrian Klaver
03:02 Re: Different results from identical matviews Tom Lane
03:06 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device raf
03:59 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device Tom Lane
06:16 If crashes during VACUUM, will it recover from a checkpoint that is before the forzen transaction ID of VACUUM? Jialun Zhang
07:25 Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC Rene de Gek
07:33 Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC Virendra Kumar
13:12 Re: Different results from identical matviews Magnus Hagander
13:43 restore_command for postgresql streaming replication Brajendra Pratap Singh
14:26 Re: Different results from identical matviews Anders Steinlein
14:31 Re: Different results from identical matviews Anders Steinlein
14:36 Re: Different results from identical matviews Anders Steinlein
14:37 Check Replication lag status Brajendra Pratap Singh
15:55 Re: Different results from identical matviews Michael Lewis
16:01 Re: Different results from identical matviews Jeremy Smith
16:06 Re: Different results from identical matviews Anders Steinlein
16:08 Re: Different results from identical matviews Paul Förster
16:44 Re: Different results from identical matviews Tom Lane
16:54 Re: Different results from identical matviews David G. Johnston
17:57 Re: Different results from identical matviews Anders Steinlein
18:03 Catching errors with Perl DBI stan
18:06 Re: Different results from identical matviews Anders Steinlein
18:17 Re: Catching errors with Perl DBI Gianni Ceccarelli
18:18 Re: Catching errors with Perl DBI Francisco Olarte
18:25 Re: Different results from identical matviews David G. Johnston
18:32 Re: restore_command for postgresql streaming replication Stephen Frost
18:43 Re: Different results from identical matviews Tom Lane
18:54 survey: psql syntax errors abort my transactions Jeremy Schneider
19:02 Re: Different results from identical matviews David G. Johnston
19:28 Re: survey: psql syntax errors abort my transactions David G. Johnston
19:31 Re: survey: psql syntax errors abort my transactions Adrian Klaver
19:44 Re: survey: psql syntax errors abort my transactions Jeremy Schneider
19:52 Re: survey: psql syntax errors abort my transactions Adrian Klaver
19:56 Re: survey: psql syntax errors abort my transactions Adrian Klaver

3 July 2020

00:32 Re: Different results from identical matviews Anders Steinlein
00:44 Re: Different results from identical matviews Tom Lane
01:00 Does TOAST really compress the complete row? Thomas Kellerer
01:05 Re: Different results from identical matviews Anders Steinlein
01:15 Re: Does TOAST really compress the complete row? Tom Lane
01:25 Re: Different results from identical matviews Tom Lane
02:29 Re: Does TOAST really compress the complete row? Adam Brusselback
02:32 Re: Does TOAST really compress the complete row? Adrian Klaver
03:02 Re: Does TOAST really compress the complete row? Adam Brusselback
09:46 Re: survey: psql syntax errors abort my transactions Laurenz Albe
09:54 Re: survey: psql syntax errors abort my transactions Laurenz Albe
11:37 Unable to run psql on 9.5 after broken 12 remove Moreno Andreo
11:54 Re: Unable to run psql on 9.5 after broken 12 remove Moreno Andreo
14:37 [HELP] Regarding how to install libraries Praveen Kumar K S
17:21 Re: [HELP] Regarding how to install libraries Adrian Klaver
17:51 Re: Unable to run psql on 9.5 after broken 12 remove Adrian Klaver
17:54 Re: [HELP] Regarding how to install libraries Adrian Klaver
18:15 Re: Unable to run psql on 9.5 after broken 12 remove Moreno Andreo
18:21 Re: Unable to run psql on 9.5 after broken 12 remove Adrian Klaver
20:46 Re: survey: psql syntax errors abort my transactions Ron
21:41 Re: survey: psql syntax errors abort my transactions Julien Rouhaud
23:24 Degraded performance during table rewrite Mohamed Wael Khobalatte
23:46 Re: Degraded performance during table rewrite Mohamed Wael Khobalatte

4 July 2020

00:26 Re: Degraded performance during table rewrite Tom Lane
00:33 Re: Degraded performance during table rewrite Ron
05:16 Re: Degraded performance during table rewrite Mohamed Wael Khobalatte
05:26 Re: Degraded performance during table rewrite Mohamed Wael Khobalatte
05:31 Re: Degraded performance during table rewrite Tom Lane
06:30 Re: Degraded performance during table rewrite Mohamed Wael Khobalatte
22:34 Re: Degraded performance during table rewrite Mohamed Wael Khobalatte
22:58 Re: Degraded performance during table rewrite Tom Lane
23:13 Re: Degraded performance during table rewrite Mohamed Wael Khobalatte

5 July 2020

09:22 Application Level Encryption Zahir Lalani
14:45 Re: Application Level Encryption o1bigtenor
14:59 Re: Application Level Encryption sivapostgres@yahoo.com
18:59 Re: Application Level Encryption Michel Pelletier
20:14 RE: Application Level Encryption Zahir Lalani
21:40 Re: Application Level Encryption Michel Pelletier

6 July 2020

01:23 Re: Application Level Encryption Sam Gendler
01:32 Re: Application Level Encryption Michel Pelletier
01:42 RE: Application Level Encryption Zahir Lalani
04:04 Re: survey: psql syntax errors abort my transactions raf
11:15 Re: survey: psql syntax errors abort my transactions Laurenz Albe
12:43 PostgreSQL server does not increment a SERIAL internally Matthias Apitz
14:19 Using Postgres jdbc driver with Oracle SQL Developer Niels Jespersen
14:26 SV: Using Postgres jdbc driver with Oracle SQL Developer Niels Jespersen
14:36 Apply LIMIT when computation is logically irrelevant Robins Tharakan
14:58 Re: PostgreSQL server does not increment a SERIAL internally Sándor Daku
15:03 Re: Apply LIMIT when computation is logically irrelevant Francisco Olarte
15:27 Re: PostgreSQL server does not increment a SERIAL internally Matthias Apitz
15:43 Re: Apply LIMIT when computation is logically irrelevant Simon Riggs
16:33 Re: SV: Using Postgres jdbc driver with Oracle SQL Developer Tom Lane
16:41 Re: SV: Using Postgres jdbc driver with Oracle SQL Developer Dave Cramer
16:45 Re: PostgreSQL server does not increment a SERIAL internally Adrian Klaver
18:35 Re: SV: Using Postgres jdbc driver with Oracle SQL Developer legrand legrand
19:41 Pgbench : vacuum default behaviour history Christophe Courtois
19:43 Is postgres able to share sorts required by common partition window functions? Sebastien Arod
22:51 Re: Apply LIMIT when computation is logically irrelevant Michael Lewis
22:55 Re: Is postgres able to share sorts required by common partition window functions? Michael Lewis
23:28 Re: Is postgres able to share sorts required by common partition window functions? Sebastien Arod
23:49 Re: Apply LIMIT when computation is logically irrelevant David Rowley

7 July 2020

00:03 Re: Apply LIMIT when computation is logically irrelevant Simon Riggs
00:48 Re: Apply LIMIT when computation is logically irrelevant David Rowley
01:19 Re: Is postgres able to share sorts required by common partition window functions? Michael Lewis
01:40 Re: Is postgres able to share sorts required by common partition window functions? David G. Johnston
01:48 Re: Is postgres able to share sorts required by common partition window functions? David G. Johnston
05:06 Efficiently advancing a sequence without risking it going backwards. Paul McGarry
05:25 Re: Efficiently advancing a sequence without risking it going backwards. Adrian Klaver
06:18 Re: [HELP] Regarding how to install libraries Praveen Kumar K S
07:03 Re: libpq pipelineing Samuel Williams
10:08 SV: SV: Using Postgres jdbc driver with Oracle SQL Developer Niels Jespersen
13:50 Auto vacuum not reclaiming the space and disk utilization spike to 100% Ishan Joshi
14:13 Transaction control in SECURITY DEFINER procedures Chris Sterritt
14:40 Basic question about structuring SQL Robert Inder
16:14 Re: Basic question about structuring SQL Jason Wang
18:01 Re: Is postgres able to share sorts required by common partition window functions? Sebastien Arod
18:03 Re: Basic question about structuring SQL David G. Johnston
20:24 Re: Is postgres able to share sorts required by common partition window functions? Michael Lewis

8 July 2020

16:05 Is this a bug in pg_current_logfile() on Windows? Thomas Kellerer
16:45 Re: Is this a bug in pg_current_logfile() on Windows? Adrian Klaver
17:09 BigSerial and txid issuance Yorwerth, Adam
17:16 Re: Is this a bug in pg_current_logfile() on Windows? Adrian Klaver
18:01 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device FOUTE K. Jaurès
18:25 Re: BigSerial and txid issuance David G. Johnston
19:20 Re: BigSerial and txid issuance Adrian Klaver
19:41 Re: Is this a bug in pg_current_logfile() on Windows? Tom Lane
19:43 Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device Tom Lane
20:07 Re: Is this a bug in pg_current_logfile() on Windows? Thomas Kellerer
22:27 pg_dump / pg_restore option Luiz Hugo Ronqui
22:34 Re: pg_dump / pg_restore option Adrian Klaver

9 July 2020

10:05 Kerberos-Postgresql implementation for user authentication Brajendra Pratap Singh
10:35 Re: BigSerial and txid issuance Laurenz Albe
11:22 SV: Kerberos-Postgresql implementation for user authentication Niels Jespersen
11:28 Re: Kerberos-Postgresql implementation for user authentication Michael Holzman
11:58 Re: Kerberos-Postgresql implementation for user authentication Brajendra Pratap Singh
16:53 Clustering solution ? Laurent FAILLIE
16:55 Re: Clustering solution ? Petite Abeille
16:56 Re: Clustering solution ? Paul Förster
17:41 Re: Kerberos-Postgresql implementation for user authentication Christopher Browne
18:30 Re: Clustering solution ? Ron
18:47 Re: Clustering solution ? Laurent FAILLIE
19:59 Re: Efficiently advancing a sequence without risking it going backwards. Jeremy Schneider

10 July 2020

00:07 Re: Efficiently advancing a sequence without risking it going backwards. Christopher Browne
02:07 Re: Efficiently advancing a sequence without risking it going backwards. Tim Cross
02:10 invalid non-zero objectSubId for object class Michel Pelletier
02:18 Re: invalid non-zero objectSubId for object class Tom Lane
03:05 Safe switchover James Sewell
03:14 Re: invalid non-zero objectSubId for object class Michel Pelletier
03:26 Re: invalid non-zero objectSubId for object class Alvaro Herrera
03:27 Re: Efficiently advancing a sequence without risking it going backwards. Jeremy Schneider
03:32 Re: invalid non-zero objectSubId for object class Tom Lane
03:37 Re: invalid non-zero objectSubId for object class Michel Pelletier
03:40 Re: invalid non-zero objectSubId for object class Michel Pelletier
07:31 Re: invalid non-zero objectSubId for object class Michel Pelletier
08:29 Postgresql Backup Encryption Brajendra Pratap Singh
09:50 Postgresql-12 taking more time to execute the query Vishwa Kalyankar
10:18 Re: Safe switchover James Sewell
10:45 Re: Safe switchover Paul Förster
10:52 Re: Postgresql Backup Encryption Paul Förster
11:26 Wal_keep_segment value too high Brajendra Pratap Singh
11:54 Re: Postgresql-12 taking more time to execute the query Thomas Kellerer
15:14 Re: Wal_keep_segment value too high Andreas Kretschmer
15:37 Re: invalid non-zero objectSubId for object class Alvaro Herrera
16:02 Re: Wal_keep_segment value too high Brajendra Pratap Singh
16:53 Re: Postgresql-12 taking more time to execute the query Adrian Klaver
17:03 Issue with timestamp without time zone datatype with default value as now()/localtimestamp Deepika S Gowda
17:09 Re: Issue with timestamp without time zone datatype with default value as now()/localtimestamp Adrian Klaver
17:48 Re: Postgresql-12 taking more time to execute the query Vishwa Kalyankar
18:06 Re: invalid non-zero objectSubId for object class Michel Pelletier
18:10 Re: invalid non-zero objectSubId for object class Adrian Klaver
18:29 Re: Safe switchover Stephen Frost
18:31 Re: Safe switchover Paul Förster
18:45 Re: Safe switchover Stephen Frost
18:53 PG Admin 4 rwest
19:24 Re: PG Admin 4 Rob Sargent
19:33 Re: PG Admin 4 rwest
19:36 Re: PG Admin 4 rwest
21:22 How to do phrase search? Anto Aravinth
22:47 Re: PG Admin 4 Adrian Klaver
22:54 RE: PG Admin 4 Robert West
23:20 Re: PG Admin 4 Tim Clarke
23:26 Re: PG Admin 4 Adrian Klaver
23:30 Re: PG Admin 4 Susan Hurst
23:35 Re: PG Admin 4 Miles Elam

11 July 2020

02:02 Re: Postgresql-12 taking more time to execute the query Adrian Klaver
03:20 Re: Postgresql-12 taking more time to execute the query David Rowley
03:27 Re: Safe switchover Paul Förster
03:49 Re: Issue with timestamp without time zone datatype with default value as now()/localtimestamp Tim Cross
10:20 Re: How to do phrase search? Ivan E. Panchenko
12:17 Re: Issue with timestamp without time zone datatype with default value as now()/localtimestamp Deepika S Gowda
15:31 Re: Issue with timestamp without time zone datatype with default value as now()/localtimestamp Rob Sargent
15:58 Listen/Notify feedback Rita
18:23 Re: Issue with timestamp without time zone datatype with default value as now()/localtimestamp Adrian Klaver
20:20 Join optimization luis.roberto@siscobra.com.br
20:43 Re: Listen/Notify feedback Brian Dunavant
21:24 Re: Join optimization Fabrízio de Royes Mello
21:59 Re: Join optimization luis.roberto@siscobra.com.br

12 July 2020

11:29 Re: Join optimization David Rowley
14:39 Re: Listen/Notify feedback Rita
15:52 Re: Listen/Notify feedback Andrew Smith
17:16 Re: Listen/Notify feedback Tom Lane
18:50 Re: Listen/Notify feedback Rita
19:05 Re: Listen/Notify feedback Michel Pelletier
19:32 Anto Aravinth
23:53 Re: Join optimization luis.roberto@siscobra.com.br

13 July 2020

10:31 Doubt in mvcc Rama Krishnan
11:41 Re: Doubt in mvcc Francisco Olarte
11:52 Re: Doubt in mvcc Rama Krishnan
12:21 Interaction between ON CONFLICT index inference and prepared statement generic plans Bojan Petrovic
12:51 Re: Doubt in mvcc Ravi Krishna
12:52 Logical replication from 11.x to 12.x and "unique key violations" Thomas Kellerer
13:26 Re: Doubt in mvcc Francisco Olarte
16:46 PostgresQL 12 - could not connect to server: FATAL: the database system is in recovery mode FOUTE K. Jaurès
17:07 Re: PostgresQL 12 - could not connect to server: FATAL: the database system is in recovery mode Srinivasa T N
17:10 Re: Doubt in mvcc Adrian Klaver
18:47 Re: Safe switchover Stephen Frost
18:54 Re: Safe switchover Paul Förster
19:00 Re: Safe switchover Stephen Frost
19:05 Re: Safe switchover Paul Förster
19:07 Re: Safe switchover Stephen Frost
19:52 Re: Safe switchover Jehan-Guillaume de Rorthais
19:55 Re: Clustering solution ? Jehan-Guillaume de Rorthais
22:12 backup -restore question Julie Nishimura
22:32 Re: backup -restore question Adrian Klaver
23:14 Re: PostgresQL 12 - could not connect to server: FATAL: the database system is in recovery mode FOUTE K. Jaurès

14 July 2020

00:56 Re: backup -restore question Ron
02:42 Both side privileges Jean-Philippe Chenel
02:46 Re: Both side privileges David G. Johnston
03:37 Re: backup -restore question Adrian Klaver
05:32 Re: PostgresQL 12 - could not connect to server: FATAL: the database system is in recovery mode Adrian Klaver
07:18 Re: backup -restore question Ron
09:50 Re: Doubt in mvcc Laurenz Albe
12:27 Same query taking less time in low configuration machine Vishwa Kalyankar
14:50 psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" TALLURI Nareshkumar
15:34 JDBC driver version for a given Postgres version Shantanu Shekhar
15:46 Re: Same query taking less time in low configuration machine Philip Semanchuk
16:26 Re: JDBC driver version for a given Postgres version Thomas Kellerer
16:36 Re: Both side privileges Jean-Philippe Chenel
16:59 Re: Both side privileges Toomas Kristin
18:14 some random() clarification needed Marc Millas
18:24 Re: some random() clarification needed David G. Johnston
18:25 Surprising connection issue David Gasa i Castell
18:26 Re: some random() clarification needed Marc Millas
18:35 Re: Surprising connection issue David G. Johnston
18:57 Re: Same query taking less time in low configuration machine Vishwa Kalyankar
19:01 Re: some random() clarification needed Marc Millas
19:08 Re: some random() clarification needed David G. Johnston
19:36 how to "explain" some ddl Marc Millas
20:03 Problem with FDW wrapper errors Michael Nolan
20:05 Re: how to "explain" some ddl Tom Lane
20:29 single table - fighting a seq scan Radoslav Nedyalkov
21:43 Re: how to "explain" some ddl Marc Millas
21:45 Re: single table - fighting a seq scan Michael Lewis
22:31 Re: single table - fighting a seq scan Radoslav Nedyalkov
22:31 Re: how to "explain" some ddl Marc Millas
23:04 Re: Problem with FDW wrapper errors Adrian Klaver
23:04 Re: single table - fighting a seq scan Radoslav Nedyalkov
23:25 Issue executing query from container Eudald Valcàrcel Lacasa

15 July 2020

00:51 Re: Issue executing query from container Tom Lane
01:06 Re: single table - fighting a seq scan Tom Lane
01:55 Re: some random() clarification needed Adrian Klaver
02:24 Re: Problem with FDW wrapper errors Michael Nolan
02:25 Convert hot_standby 9.4 postgresql into standalone server Julie Nishimura
02:41 Re: Convert hot_standby 9.4 postgresql into standalone server David G. Johnston
02:44 Re: Convert hot_standby 9.4 postgresql into standalone server Tom Lane
02:53 Re: some random() clarification needed David Rowley
04:53 RE: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" TALLURI Nareshkumar
11:12 Re: Same query taking less time in low configuration machine Vishwa Kalyankar
11:27 Re: Issue executing query from container Eudald Valcàrcel Lacasa
12:19 Re: some random() clarification needed Marc Millas
12:31 How to enable TDE on Postgresql 12.3 deployed using Kubernetes Samarendra Sahoo
12:34 Cross-site cookies warnings Fabio
12:57 RE: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" Daniel Verite
15:22 Re: single table - fighting a seq scan Radoslav Nedyalkov
17:27 Re: Cross-site cookies warnings Adrian Klaver
17:42 Re: Issue executing query from container Tom Lane
17:58 Re: single table - fighting a seq scan Tom Lane
18:10 2 million queries against a table Adam Sanchez
18:28 Re: 2 million queries against a table Ron
18:38 Re: 2 million queries against a table Tom Lane
18:54 Re: Clustering solution ? Laurent FAILLIE
18:55 Re: 2 million queries against a table Rob Sargent
19:33 Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" Naresh Kumar
19:37 Re: Issue executing query from container Eudald Valcàrcel Lacasa
20:25 Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" Karsten Hilbert

16 July 2020

00:15 ownership of "/var/run/postgresql" Dmitry O Litvintsev
00:20 Re: ownership of "/var/run/postgresql" Christoph Moench-Tegeder
00:49 Re: Same query taking less time in low configuration machine Thomas Munro
01:29 Re: Same query taking less time in low configuration machine David Rowley
10:07 Re: Efficiently advancing a sequence without risking it going backwards. Paul McGarry
14:03 Re: Clustering solution ? Jehan-Guillaume de Rorthais
20:41 Capturing just slow queries Tiffany Thang
22:04 Fwd: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password? Devraj B
22:55 Re: Fwd: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password? Adrian Klaver
23:24 Re: Fwd: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password? Adrian Klaver
23:43 Re: Fwd: How to connect PostgreSQL (9.6.17) database from Macbook Pro Terminal using JumpCloud password? David G. Johnston

17 July 2020

04:32 Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" Naresh Kumar
04:34 Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" Christophe Pettus
05:08 Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" Naresh Kumar
05:12 Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" Christophe Pettus
06:06 Re: psql: FATAL: database "postgres" does not exist or ERROR: 23505: duplicate key value violates unique constraint "pg_namespace_nspname_index" Naresh Kumar
11:14 Re: Capturing just slow queries Wim Bertels
12:44 Re: Capturing just slow queries Tiffany Thang
17:05 Where Do I Find... Eugene Poole
17:10 Re: Where Do I Find... Paul Förster
17:48 About compress in pg_dump Edmundo Robles
18:07 Re: About compress in pg_dump David G. Johnston
18:12 Re: About compress in pg_dump Diego
18:44 Security Vulnerability on PostgreSQL VMs Hilbert, Karin
19:03 Re: Security Vulnerability on PostgreSQL VMs Ron
19:07 Re: Security Vulnerability on PostgreSQL VMs Diego
19:11 Re: Security Vulnerability on PostgreSQL VMs Magnus Hagander
19:16 PostgreSQL make too long to start. FOUTE K. Jaurès
19:26 Re: PostgreSQL make too long to start. David G. Johnston
22:08 DB Authentication with Label Security Ailleen Pace
22:44 python async with psycopg2 Rita
23:07 Re: python async with psycopg2 Daniele Varrazzo
23:18 Re: About compress in pg_dump Adrian Klaver
23:21 Re: About compress in pg_dump Adrian Klaver

18 July 2020

05:51 Errors after cloning OS to new disk under Hyper-V
05:55 Re: Errors after cloning OS to new disk under Hyper-V Rob Sargent
07:36 RE: Errors after cloning OS to new disk under Hyper-V
07:40 Re: Errors after cloning OS to new disk under Hyper-V Pavel Stehule
07:57 Re: Errors after cloning OS to new disk under Hyper-V Tom Lane

19 July 2020

00:01 Could not open file pg_xact/0E97 Radoslav Nedyalkov
00:18 Re: Could not open file pg_xact/0E97 Radoslav Nedyalkov
14:01 PG 9.5.5 cores on AIX 7.1 Abraham, Danny
18:04 Re: PG 9.5.5 cores on AIX 7.1 Tom Lane
21:04 RE: Re: PG 9.5.5 cores on AIX 7.1 Abraham, Danny
21:25 How to restore a dump containing CASTs into a database with a new user? Thorsten Schöning
21:37 Re: How to restore a dump containing CASTs into a database with a new user? Tom Lane
22:01 Re: Re: PG 9.5.5 cores on AIX 7.1 David G. Johnston
22:51 Re: How to restore a dump containing CASTs into a database with a new user? Thorsten Schöning
23:37 Re: How to restore a dump containing CASTs into a database with a new user? Tom Lane
23:42 Re: How to restore a dump containing CASTs into a database with a new user? Thorsten Schöning

20 July 2020

00:25 Re: How to restore a dump containing CASTs into a database with a new user? Thorsten Schöning
00:38 Re: How to restore a dump containing CASTs into a database with a new user? Christophe Pettus
01:34 Re: PG 9.5.5 cores on AIX 7.1 Thomas Munro
08:13 Re: How to restore a dump containing CASTs into a database with a new user? Thorsten Schöning
08:19 Re: How to restore a dump containing CASTs into a database with a new user? Christophe Pettus
10:01 Steps required for increasing disk size in EC2 instance with minimal downtime RAJAMOHAN
12:28 Re: How to restore a dump containing CASTs into a database with a new user? Thorsten Schöning
16:20 PGBench on Windows - connections are subprocesses? Durumdara
16:37 Re: Steps required for increasing disk size in EC2 instance with minimal downtime Adrian Klaver
16:38 Re: PGBench on Windows - connections are subprocesses? Tom Lane
16:38 Re: PGBench on Windows - connections are subprocesses? Durumdara
17:08 Re: PGBench on Windows - connections are subprocesses? Durumdara
17:22 Re: Logical replication from 11.x to 12.x and "unique key violations" Thomas Kellerer
17:28 Re: how to "explain" some ddl Michel Pelletier
17:34 Re: How to restore a dump containing CASTs into a database with a new user? Christophe Pettus
17:44 Re: Improvement for query planner? (no, not about count(*) again ;-)) Francisco Olarte
17:45 Re: Logical replication from 11.x to 12.x and "unique key violations" Adrian Klaver
18:10 Re: How to restore a dump containing CASTs into a database with a new user? Thorsten Schöning
18:47 Re: DB Authentication with Label Security Michel Pelletier
20:21 Re: How to restore a dump containing CASTs into a database with a new user? Christophe Pettus
20:47 Re: Logical replication from 11.x to 12.x and "unique key violations" Tom Lane
20:56 Re: Logical replication from 11.x to 12.x and "unique key violations" Adrian Klaver
21:04 Re: Logical replication from 11.x to 12.x and "unique key violations" Tom Lane
21:11 Re: Logical replication from 11.x to 12.x and "unique key violations" John Ashmead
23:13 Extension vs Implementing Wire Protocol Matthew Tamayo-Rios
23:36 Re: Extension vs Implementing Wire Protocol Thomas Kellerer
23:45 Re: Extension vs Implementing Wire Protocol Karsten Hilbert

21 July 2020

02:38 Re: Could not open file pg_xact/0E97 Jeremy Schneider
08:11 Pgpool in docker container Vasu Madhineni
08:42 Re: Logical replication from 11.x to 12.x and "unique key violations" Thomas Kellerer
08:46 Re: Logical replication from 11.x to 12.x and "unique key violations" Thomas Kellerer
08:48 Re: Logical replication from 11.x to 12.x and "unique key violations" Thomas Kellerer
10:24 Re: Could not open file pg_xact/0E97 Radoslav Nedyalkov
10:35 Re: Multitenent architecture Vasu Madhineni
10:39 Re: Logical replication from 11.x to 12.x and "unique key violations" Tom Lane
10:51 Re: Logical replication from 11.x to 12.x and "unique key violations" Thomas Kellerer
11:08 Re: How to restore a dump containing CASTs into a database with a new user? Thorsten Schöning
18:07 Re: Logical replication from 11.x to 12.x and "unique key violations" Adrian Klaver
18:30 Switching Primary Keys to BigInt Mohamed Wael Khobalatte
21:13 Re: Multitenent architecture Michel Pelletier
21:17 Re: Switching Primary Keys to BigInt Adrian Klaver
21:26 Re: Switching Primary Keys to BigInt Adrian Klaver
21:43 Re: Switching Primary Keys to BigInt Michael Lewis

22 July 2020

00:18 Re: Switching Primary Keys to BigInt Mohamed Wael Khobalatte
00:35 Problem with pg_service.conf Michał Lis
02:32 Re: Switching Primary Keys to BigInt Adrian Klaver
04:08 Re: Switching Primary Keys to BigInt Mohamed Wael Khobalatte
05:30 CASCADE/fkey order Samuel Nelson
08:11 Re: Pgpool in docker container Srinivasa T N
08:29 HA setup with pg pool in docker Vasu Madhineni
08:36 Re: Logical replication from 11.x to 12.x and "unique key violations" Thomas Kellerer
13:49 How to create function returning numeric from string containing percent character Andrus
14:10 Re: Logical replication from 11.x to 12.x and "unique key violations" Thomas Kellerer
16:27 Re: Switching Primary Keys to BigInt Daniel Verite
17:39 Re: Switching Primary Keys to BigInt Mohamed Wael Khobalatte
17:42 Re: Logical replication from 11.x to 12.x and "unique key violations" Adrian Klaver
18:13 Re: Switching Primary Keys to BigInt Daniel Verite
18:23 Re: Logical replication from 11.x to 12.x and "unique key violations" Thomas Kellerer
18:30 Re: CASCADE/fkey order David G. Johnston
18:59 Re: Problem with pg_service.conf Ron
19:03 Re: CASCADE/fkey order Samuel Nelson
19:14 Re: Problem with pg_service.conf Adrian Klaver
20:21 Re: Problem with pg_service.conf Michał Lis
20:24 Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 Surya Widyanto
21:06 Re: Transaction control in SECURITY DEFINER procedures Bruce Momjian
21:23 Re: Switching Primary Keys to BigInt Mohamed Wael Khobalatte
21:32 Re: Doubt in mvcc Bruce Momjian
22:07 Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 Adrian Klaver
22:14 Re: Switching Primary Keys to BigInt Michael Lewis
23:11 Re: Switching Primary Keys to BigInt Mohamed Wael Khobalatte
23:12 Re: Switching Primary Keys to BigInt Mohamed Wael Khobalatte
23:44 pglogical, replication_slots and going back in time MirrorX
23:45 Re: Switching Primary Keys to BigInt Ireneusz Pluta/wp.pl
23:52 Re: Switching Primary Keys to BigInt Mohamed Wael Khobalatte

23 July 2020

00:43 Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 Surya Widyanto
00:54 Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 Adrian Klaver
01:26 Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 Adrian Klaver
01:36 Re: CASCADE/fkey order David G. Johnston
01:44 Re: How to create function returning numeric from string containing percent character David G. Johnston
01:58 Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 Surya Widyanto
02:12 Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 Rob Sargent
02:49 Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 Surya Widyanto
03:01 psql \r changed behavior in pg10 Emanuel Araújo
03:14 Re: psql \r changed behavior in pg10 David G. Johnston
03:36 Re: psql \r changed behavior in pg10 David G. Johnston
03:54 Re: psql \r changed behavior in pg10 Tom Lane
13:06 Re: How to enable TDE on Postgresql 12.3 deployed using Kubernetes Samarendra Sahoo
18:05 Re: Problem with pg_service.conf David G. Johnston
18:55 Re: HA setup with pg pool in docker Bo Peng
19:07 Re: Pgpool in docker container Bo Peng
20:51 ERROR: out of overflow pages in hash index Adam Scott

24 July 2020

02:16 Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 Adrian Klaver
07:01 Row estimates for empty tables Christophe Pettus
07:56 Re: Row estimates for empty tables David Rowley
16:48 Re: Row estimates for empty tables Tom Lane
17:38 Re: Row estimates for empty tables Christophe Pettus
19:38 TDE implementation in postgres which is in docker container Vasu Madhineni
19:42 Re: CASCADE/fkey order Michel Pelletier
22:14 Re: Row estimates for empty tables Pavel Stehule
22:34 when is RLS policy applied Ted Toth
22:35 Re: Row estimates for empty tables Christophe Pettus
23:04 Re: when is RLS policy applied Adrian Klaver
23:15 Re: when is RLS policy applied Tom Lane
23:40 Re: when is RLS policy applied Ted Toth
23:46 bad JIT decision Scott Ribe

25 July 2020

00:09 Re: Row estimates for empty tables Tom Lane
00:12 Re: when is RLS policy applied Ted Toth
00:15 Re: when is RLS policy applied Adrian Klaver
00:16 Re: when is RLS policy applied Tom Lane
00:29 Re: when is RLS policy applied Adrian Klaver
00:54 Re: Row estimates for empty tables Christophe Pettus
01:26 Re: bad JIT decision David Rowley
01:32 Re: bad JIT decision Scott Ribe
01:37 Re: bad JIT decision Tom Lane
01:42 Re: bad JIT decision David Rowley
01:46 Re: bad JIT decision Scott Ribe
01:49 is JIT available Scott Ribe
03:16 Re: bad JIT decision Andres Freund
04:51 Re: bad JIT decision Andres Freund
06:55 Re: is JIT available Pavel Stehule
09:33 How does vacuum works in postgresql Rama Krishnan
09:58 Re: bad JIT decision David Rowley
15:04 Re: is JIT available Scott Ribe
15:21 Re: is JIT available Pavel Stehule
15:33 Re: is JIT available Scott Ribe
15:39 Re: is JIT available Pavel Stehule
16:48 Format generation_expression Nils Bergmann
17:02 Re: is JIT available Christoph Moench-Tegeder
17:17 Re: bad JIT decision Tom Lane
17:23 Re: bad JIT decision Tom Lane
17:54 Re: bad JIT decision Tom Lane
18:24 Re: TDE implementation in postgres which is in docker container Ron

26 July 2020

00:41 plphyton function - return each list value as a row ? karsten
00:50 RE: plphyton function - return each list value as a row ? karsten
02:53 Re: bad JIT decision David Rowley
03:03 Re: bad JIT decision David Rowley
03:04 Re: bad JIT decision David Rowley
04:17 Re: [SOLUTION] Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10 Surya Widyanto
21:15 Re: Switching Primary Keys to BigInt Mohamed Wael Khobalatte
21:25 shp2pgsql is missing Susan Hurst
22:27 Re: shp2pgsql is missing Adrian Klaver
22:58 Re: shp2pgsql is missing Christoph Moench-Tegeder

27 July 2020

03:08 Re: TDE implementation in postgres which is in docker container raf
18:21 Re: is JIT available Philip Semanchuk
18:24 Re: shp2pgsql is missing Susan Hurst
19:18 Re: is JIT available Scott Ribe
22:14 Re: How does vacuum works in postgresql Michael Lewis
23:03 Re: Format generation_expression Michael Lewis

28 July 2020

01:00 Re: bad JIT decision Alvaro Herrera
01:24 Re: bad JIT decision Scott Ribe
02:00 Re: bad JIT decision Andres Freund
02:02 Re: bad JIT decision Alvaro Herrera
02:54 Re: bad JIT decision David Rowley
03:04 Re: is JIT available David Rowley
03:08 postgres stats on the new primary Ayub M
04:53 Re: postgres stats on the new primary Ian Barwick
06:33 Re: is JIT available Tom Lane
06:55 Re: is JIT available David Rowley
11:42 Out of memory with "create extension postgis" Daniel Westermann (DWE)
13:54 Issues of slow running queries when dealing with Big Data Shaozhong SHI
13:57 Re: is JIT available David Rowley
14:31 Re: Issues of slow running queries when dealing with Big Data Gavin Flower
15:26 Re: is JIT available Scott Ribe
15:28 Re: is JIT available Scott Ribe
16:57 Re: Out of memory with "create extension postgis" Tom Lane
16:59 Re: Issues of slow running queries when dealing with Big Data Shaozhong SHI
17:47 Re: Out of memory with "create extension postgis" Daniel Westermann (DWE)
17:55 Re: Out of memory with "create extension postgis" Tom Lane
18:04 Re: Out of memory with "create extension postgis" Daniel Westermann (DWE)
18:41 Re: Issues of slow running queries when dealing with Big Data Michael Lewis
18:45 Re: determine what column(s) form the primary key, in C extention alex maslakov
18:51 Re: Issues of slow running queries when dealing with Big Data Shaozhong SHI
19:40 Need free PG odbc driver for Windows 10 David Gauthier
19:47 Re: Need free PG odbc driver for Windows 10 Igor Korot
20:19 Re: bad JIT decision Andres Freund
20:27 Re: Need free PG odbc driver for Windows 10 Thomas Kellerer
20:49 Re: Need free PG odbc driver for Windows 10 Adrian Klaver
22:35 Re: Issues of slow running queries when dealing with Big Data Gavin Flower
22:47 Re: bad JIT decision Tom Lane
23:51 Re: Issues of slow running queries when dealing with Big Data Shaozhong SHI

29 July 2020

00:07 Re: bad JIT decision Andres Freund
00:18 Is upper_inc ever true for dateranges? Ken Tanzer
00:23 Re: Is upper_inc ever true for dateranges? David G. Johnston
00:26 Re: Is upper_inc ever true for dateranges? Ken Tanzer
00:28 Re: bad JIT decision Andres Freund
00:43 Re: Issues of slow running queries when dealing with Big Data Michael Lewis
02:00 Re: Issues of slow running queries when dealing with Big Data Shaozhong SHI
04:01 Re: determine what column(s) form the primary key, in C extention David Rowley
04:19 Re: is JIT available David Rowley
13:53 pg_dump / pg_restore version confusion Zwettler Markus (OIZ)
14:49 Re: pg_dump / pg_restore version confusion Bruce Momjian
15:33 AW: pg_dump / pg_restore version confusion Zwettler Markus (OIZ)
15:54 Re: pg_dump / pg_restore version confusion Bruce Momjian
16:38 AW: pg_dump / pg_restore version confusion Zwettler Markus (OIZ)
16:44 Re: pg_dump / pg_restore version confusion Adrian Klaver
16:55 Re: AW: pg_dump / pg_restore version confusion Adrian Klaver
17:15 Re: AW: pg_dump / pg_restore version confusion Tom Lane
17:49 Re: Out of memory with "create extension postgis" Daniel Westermann (DWE)
18:05 Re: Out of memory with "create extension postgis" Tom Lane
18:16 Re: How to create function returning numeric from string containing percent character Ben Madin
18:44 Track pgsql steps Olivier Leprêtre
20:58 Re: Track pgsql steps Adrian Klaver

30 July 2020

02:56 Transaction prevention Steve Baldwin
03:23 Re: Transaction prevention Tom Lane
03:50 Re: Transaction prevention Steve Baldwin
04:10 Re: Transaction prevention Tom Lane
10:56 PSQLException: An I/O error occurred while sending to the backend. Argha Deep Ghoshal
11:27 Re: Doubt in mvcc Naresh gandi
11:57 Re: Out of memory with "create extension postgis" Daniel Westermann (DWE)
13:18 Re: Track pgsql steps Julien Rouhaud
13:33 How to find out why user processes are using so much memory? Zwettler Markus (OIZ)
16:11 RE: Track pgsql steps Olivier Leprêtre
16:54 Questions about Logical Replication - Issue ??? FOUTE K. Jaurès
17:03 Re: Track pgsql steps Diego
17:26 Re: PSQLException: An I/O error occurred while sending to the backend. Tom Lane
18:10 Re: How to find out why user processes are using so much memory? Pavel Stehule
18:17 Re: Out of memory with "create extension postgis" Tom Lane
18:59 Re: PSQLException: An I/O error occurred while sending to the backend. Argha Deep Ghoshal
20:20 Costs of Heap Fetches in Postgres 13 Jens.Wilke@parcIT.de

31 July 2020

04:13 Re: Questions about Logical Replication - Issue ??? Kyotaro Horiguchi
05:02 Re: Costs of Heap Fetches in Postgres 13 David Rowley
12:29 Querying PostgreSQL / PostGIS Databases in Python Shaozhong SHI
12:39 Re: Questions about Logical Replication - Issue ??? FOUTE K. Jaurès
13:50 Re: Querying PostgreSQL / PostGIS Databases in Python Allan Kamau
18:07 Apparent missed query optimization with self-join and inner grouping Zack Weinberg