pgsql-general - May 2020

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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

May 1, 2020

Thread Author Time
How to move a 11.4 cluster to another Linux host, but empty? Matthias Apitz 08:10
Re: How to move a 11.4 cluster to another Linux host, but empty? Paul Förster 08:23
Re: How to move a 11.4 cluster to another Linux host, but empty? Matthias Apitz 08:31
Re: How to move a 11.4 cluster to another Linux host, but empty? Paul Förster 08:59
Re: pg_stat_statements : how to catch non successfully finished statements ? legrand legrand 09:26
How to use pg_waldump? André Hänsel 10:47
Re: How to use pg_waldump? Paul Förster 12:12
RE: How to use pg_waldump? André Hänsel 12:33
Re: How to use pg_waldump? Paul Förster 12:37
RE: How to use pg_waldump? André Hänsel 13:46
Re: How to use pg_waldump? Paul Förster 13:56
RE: How to use pg_waldump? André Hänsel 14:03
Re: How to use pg_waldump? Paul Förster 14:09
Re: Pgbackrest restore options David Steele 17:08
Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade TalGloz 22:03
Re: Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade Adrian Klaver 22:11
Re: Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade Bruce Momjian 22:21
Re: Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade TalGloz 22:39
Re: Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade Adrian Klaver 22:45
Re: How to use pg_waldump? Alvaro Herrera 23:27

May 2, 2020

Thread Author Time
Re: Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade TalGloz 07:30
Re: How to move a 11.4 cluster to another Linux host, but empty? Matthias Apitz 10:23
Re: How to move a 11.4 cluster to another Linux host, but empty? Paul Förster 13:23
Re: How to move a 11.4 cluster to another Linux host, but empty? Matthias Apitz 14:30
Re: How to move a 11.4 cluster to another Linux host, but empty? Paul Förster 14:37
Re: How to move a 11.4 cluster to another Linux host, but empty? Adrian Klaver 14:59
Re: How to move a 11.4 cluster to another Linux host, but empty? Paul Förster 15:02
Re: How to move a 11.4 cluster to another Linux host, but empty? Adrian Klaver 15:23
Re: Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade Adrian Klaver 15:26
Re: Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade David G. Johnston 17:06
Re: How to move a 11.4 cluster to another Linux host, but empty? Matthias Apitz 18:58
Re: How to move a 11.4 cluster to another Linux host, but empty? Paul Förster 19:10
Re: How to move a 11.4 cluster to another Linux host, but empty? Adrian Klaver 19:19
Compiling C Extension Functions against PostgreSQL 12 TalGloz 19:28
Re: Compiling C Extension Functions against PostgreSQL 12 Adrian Klaver 19:31
Re: Compiling C Extension Functions against PostgreSQL 12 TalGloz 19:39
Re: Compiling C Extension Functions against PostgreSQL 12 Adrian Klaver 19:55
Re: Compiling C Extension Functions against PostgreSQL 12 TalGloz 20:03
Re: Compiling C Extension Functions against PostgreSQL 12 Adrian Klaver 20:05
Re: Compiling C Extension Functions against PostgreSQL 12 TalGloz 20:09
Re: Compiling C Extension Functions against PostgreSQL 12 Adrian Klaver 20:28
Re: Compiling C Extension Functions against PostgreSQL 12 TalGloz 20:52
Re: Compiling C Extension Functions against PostgreSQL 12 Tom Lane 21:18
Re: Compiling C Extension Functions against PostgreSQL 12 Adrian Klaver 21:23
Re: Compiling C Extension Functions against PostgreSQL 12 TalGloz 21:44
Re: Compiling C Extension Functions against PostgreSQL 12 Adrian Klaver 21:51
Re: Compiling C Extension Functions against PostgreSQL 12 TalGloz 23:03
Re: Compiling C Extension Functions against PostgreSQL 12 Adrian Klaver 23:24

May 3, 2020

Thread Author Time
Re: Compiling C Extension Functions against PostgreSQL 12 TalGloz 08:57
Re: Compiling C Extension Functions against PostgreSQL 12 Andrew Gierth 09:11
Re: Compiling C Extension Functions against PostgreSQL 12 TalGloz 09:42
Clustered Index in PG brajmohan saxena 11:25
Re: Compiling C Extension Functions against PostgreSQL 12 Tom Lane 14:26
Very frequent "Too many clients" eventually crashes postmaster Abraham, Danny 14:28
Re: Very frequent "Too many clients" eventually crashes postmaster Tom Lane 14:36
Re: Very frequent "Too many clients" eventually crashes postmaster Adrian Klaver 14:38
Re: Compiling C Extension Functions against PostgreSQL 12 TalGloz 14:48
RE: Re: Very frequent "Too many clients" eventually crashes postmaster Abraham, Danny 14:53
Re: How to move a 11.4 cluster to another Linux host, but empty? Peter J. Holzer 16:26
Upgrade Process Says "The database server was not shut down cleanly" but it was TalGloz 21:53
Re: Upgrade Process Says "The database server was not shut down cleanly" but it was Adrian Klaver 22:07
Re: Upgrade Process Says "The database server was not shut down cleanly" but it was TalGloz 22:11
Re: Upgrade Process Says "The database server was not shut down cleanly" but it was Adrian Klaver 22:19
Re: Upgrade Process Says "The database server was not shut down cleanly" but it was TalGloz 22:33
Re: Upgrade Process Says "The database server was not shut down cleanly" but it was Adrian Klaver 22:39

May 4, 2020

Thread Author Time
Re: Transition tables for column-specific UPDATE triggers Thomas Munro 05:36
12.2: Howto check memory-leak in worker? Peter 11:56
Re: Clustered Index in PG Laurenz Albe 12:08
Re: walreceiver termination Justin King 14:09
Re: 12.2: Howto check memory-leak in worker? Dilip Kumar 16:14
Re: 12.2: Howto check memory-leak in worker? Adrian Klaver 19:55
Thoughts on how to avoid a massive integer update. Fehrle, Brian 21:32
Re: Thoughts on how to avoid a massive integer update. Adrian Klaver 21:56
Re: Thoughts on how to avoid a massive integer update. Rob Sargent 21:57
Re: 12.2: Howto check memory-leak in worker? Peter 22:01
Re: 12.2: Howto check memory-leak in worker? Thomas Munro 22:57
Temporary table has become problematically persistent Ricky Ramirez 23:24
Installing Postgis25_11 Clifford Snow 23:40
Re: Thoughts on how to avoid a massive integer update. Rob Sargent 23:46
Re: Temporary table has become problematically persistent Tom Lane 23:54

May 5, 2020

Thread Author Time
Re: Temporary table has become problematically persistent Ricky Ramirez 00:21
Re: Installing Postgis25_11 Virendra Kumar 00:27
COPY blocking \dt+? pinker 01:05
Re: Temporary table has become problematically persistent Jerry Sievers 01:17
Re: COPY blocking \dt+? David Rowley 01:31
Re: COPY blocking \dt+? pinker 02:50
Re: COPY blocking \dt+? David Rowley 03:01
Migration from Oracle to Postgres Jean Claude 07:07
Re: Migration from Oracle to Postgres Paul Förster 07:18
Re: How to know if initial sync of logical subscription is finished Klaus Darilion 07:33
Re: How to know if initial sync of logical subscription is finished Laurenz Albe 08:15
Re: Installing Postgis25_11 Laurenz Albe 08:23
Re: Migration from Oracle to Postgres legrand legrand 10:14
Re: 12.2: Howto check memory-leak in worker? Peter 10:45
Lock Postgres account after X number of failed logins? Wolff, Ken L 14:13
Re: Lock Postgres account after X number of failed logins? Adrian Klaver 14:28
Re: Lock Postgres account after X number of failed logins? Allan Kamau 14:39
Re: Installing Postgis25_11 Clifford Snow 15:09
jsonb unique constraints Ted Toth 15:33
Re: Installing Postgis25_11 Adrian Klaver 15:37
Re: jsonb unique constraints David G. Johnston 15:38
Re: Installing Postgis25_11 Clifford Snow 15:53
Re: 12.2: Howto check memory-leak in worker? Tom Lane 15:59
Re: jsonb unique constraints Ted Toth 16:13
Re: Lock Postgres account after X number of failed logins? Wolff, Ken L 17:45
Re: 12.2: Howto check memory-leak in worker? Peter 17:54
Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;' Matthias Apitz 18:12
Re: Lock Postgres account after X number of failed logins? Tom Lane 19:11
Re: Thoughts on how to avoid a massive integer update. Peter J. Holzer 19:33
RETURNING to_jsonb(...) Miles Elam 20:11
Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;' Tom Lane 20:18
Re: RETURNING to_jsonb(...) Adrian Klaver 20:25
Re: Lock Postgres account after X number of failed logins? Stephen Frost 20:46
Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;' Matthias Apitz 22:13
Re: Lock Postgres account after X number of failed logins? Wolff, Ken L 22:24
Encoding conversion: Use replacement character instead of failing query with "ERROR: character with byte sequence 0xd0 0xad in encoding "UTF8" has no equivalent in encoding LATIN1" ? Christian Ramseyer 22:50
Re: Lock Postgres account after X number of failed logins? Tim Cross 23:05

May 6, 2020

Thread Author Time
Re: Encoding conversion: Use replacement character instead of failing query with "ERROR: character with byte sequence 0xd0 0xad in encoding "UTF8" has no equivalent in encoding LATIN1" ? Tom Lane 00:00
Wrong PostgreSQL Plan Virendra Kumar 01:15
Re: Wrong PostgreSQL Plan David G. Johnston 01:26
Re: Temporary table has become problematically persistent Ricky Ramirez 01:27
Re: Wrong PostgreSQL Plan Virendra Kumar 01:41
Re: Lock Postgres account after X number of failed logins? Christian Ramseyer 02:18
Re: Lock Postgres account after X number of failed logins? Geoff Winkless 08:33
Re: Lock Postgres account after X number of failed logins? Paul Förster 09:23
Abnormal Growth of Index Size - Index Size 3x large than table size. Ram Pratap Maurya 09:48
Re: Abnormal Growth of Index Size - Index Size 3x large than table size. Ravi Krishna 10:57
Re: Lock Postgres account after X number of failed logins? Guillaume Lelarge 11:48
Re: Lock Postgres account after X number of failed logins? Tim Cross 12:21
Re: Abnormal Growth of Index Size - Index Size 3x large than table size. Christian Ramseyer 12:36
pg_basebackup inconsistent performance Jasen Lentz 12:44
RE: Abnormal Growth of Index Size - Index Size 3x large than table size. Ram Pratap Maurya 13:21
Re: Lock Postgres account after X number of failed logins? Stephen Frost 13:28
Re: Encoding conversion: Use replacement character instead of failing query with "ERROR: character with byte sequence 0xd0 0xad in encoding "UTF8" has no equivalent in encoding LATIN1" ? Christian Ramseyer 13:29
Re: Abnormal Growth of Index Size - Index Size 3x large than table size. Michael Lewis 13:36
RE: EXTERNAL: Re: Lock Postgres account after X number of failed logins? Wolff, Ken L 13:36
Re: EXTERNAL: Re: Lock Postgres account after X number of failed logins? Stephen Frost 13:43
Re: pg_basebackup inconsistent performance Adrian Klaver 14:27
Re: pg_basebackup inconsistent performance Adrian Klaver 14:27
Re: Abnormal Growth of Index Size - Index Size 3x large than table size. Ravi Krishna 14:37
Re: Lock Postgres account after X number of failed logins? Peter J. Holzer 15:26
Re: Lock Postgres account after X number of failed logins? Magnus Hagander 15:28
Re: Abnormal Growth of Index Size - Index Size 3x large than table size. Ravi Krishna 15:37
Re: Lock Postgres account after X number of failed logins? Stephen Frost 15:48
White space affecting parsing of range values Thom Brown 16:00
RE: pg_basebackup inconsistent performance Jasen Lentz 16:08
Re: White space affecting parsing of range values Adrian Klaver 16:13
Re: White space affecting parsing of range values Thom Brown 16:19
Re: pg_basebackup inconsistent performance Stephen Frost 16:29
Re: White space affecting parsing of range values Adrian Klaver 16:30
Re: White space affecting parsing of range values Tom Lane 16:33
Re: White space affecting parsing of range values Thom Brown 16:51
Re: White space affecting parsing of range values Thom Brown 16:53
previous replication slot and new initdb Support 22:37
Re: Lock Postgres account after X number of failed logins? Geoff Winkless 23:46

May 7, 2020

Thread Author Time
New Role drop with Grant/Revokes stop working after subsequent runs AC Gomez 00:05
Re: New Role drop with Grant/Revokes stop working after subsequent runs David G. Johnston 00:20
pg_restore V12 fails consistently against piped pg_dumps Mohamed Wael Khobalatte 04:35
Re: pg_restore V12 fails consistently against piped pg_dumps Tom Lane 06:35
Could not launch new process for connection: Could not allocate memory Lisandro Rostagno 09:14
Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 11:19
RE: pg_basebackup inconsistent performance Jasen Lentz 12:37
RE: Abnormal Growth of Index Size - Index Size 3x large than table size. Ashish Chugh 13:34
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Adrian Klaver 14:40
Re: pg_restore V12 fails consistently against piped pg_dumps Mohamed Wael Khobalatte 15:04
Re: Lock Postgres account after X number of failed logins? Stephen Frost 15:14
Re: New Role drop with Grant/Revokes stop working after subsequent runs Stephen Frost 15:16
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) David G. Johnston 15:46
wal_sender_timeout default Jasen Lentz 15:56
Postgres 11.6-2 to 11.7 worth the upgrade? Jasen Lentz 15:58
Re: Postgres 11.6-2 to 11.7 worth the upgrade? Michael Lewis 16:01
Re: Postgres 11.6-2 to 11.7 worth the upgrade? David G. Johnston 16:01
Re: wal_sender_timeout default Michael Lewis 16:01
Re: wal_sender_timeout default Adrian Klaver 16:07
Re: wal_sender_timeout default David G. Johnston 16:08
Re: Abnormal Growth of Index Size - Index Size 3x large than table size. Michael Lewis 16:10
Re: wal_sender_timeout default Adrian Klaver 16:10
Re: Abnormal Growth of Index Size - Index Size 3x large than table size. Adrian Klaver 16:16
pg_dump negation regex Eudald Valcàrcel Lacasa 16:53
increase of xact_commit vs txid_current reg_pg_stefanz 17:01
Re: Lock Postgres account after X number of failed logins? Christian Ramseyer 17:01
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 17:36
Re: pg_dump negation regex Adrian Klaver 17:36
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 17:49
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 18:07
Re: increase of xact_commit vs txid_current Julien Rouhaud 18:22
AutoVacuum and growing transaction XID's github kran 18:23
Re: AutoVacuum and growing transaction XID's Michael Lewis 18:32
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Amarendra Konda 18:51
Odd postgres12 upgrade is changing or munging a password? Tory M Blue 18:55
Re: pg_dump negation regex Eudald Valcàrcel Lacasa 19:03
Re: Odd postgres12 upgrade is changing or munging a password? Adrian Klaver 19:08
Re: pg_dump negation regex Rob Sargent 19:16
Re: Odd postgres12 upgrade is changing or munging a password? Tory M Blue 19:24
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Adrian Klaver 19:25
Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) Virendra Kumar 19:30
Re: Odd postgres12 upgrade is changing or munging a password? Adrian Klaver 19:32
Re: pg_dump negation regex Eudald Valcàrcel Lacasa 19:54
Memory footprint diff between 9.5 and 12 Tory M Blue 20:33
Re: AutoVacuum and growing transaction XID's github kran 21:18

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31