pgsql-general - August 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 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Aug. 1, 2020

Thread Author Time
12.3 replicas falling over during WAL redo Ben Chobot 14:55
Re: 12.3 replicas falling over during WAL redo Alvaro Herrera 16:35
Re: 12.3 replicas falling over during WAL redo Ben Chobot 16:58
Re: Apparent missed query optimization with self-join and inner grouping Michael Lewis 17:02
how reliable is pg_rewind? Curt Kolovson 17:35
Re: Apparent missed query optimization with self-join and inner grouping Tom Lane 18:31

Aug. 2, 2020

Thread Author Time
Re: bad JIT decision David Rowley 22:21

Aug. 3, 2020

Thread Author Time
Re: how reliable is pg_rewind? Michael Paquier 01:58
Re: 12.3 replicas falling over during WAL redo Kyotaro Horiguchi 04:39
How to get the name of the current database in C function/extention inside a trigger? alex m 05:04
Re: how reliable is pg_rewind? Paul Förster 05:29
Re: how reliable is pg_rewind? Curt Kolovson 06:25
Re: how reliable is pg_rewind? Paul Förster 06:44
Re: Out of memory with "create extension postgis" Daniel Westermann (DWE) 08:25
Re: Out of memory with "create extension postgis" Daniel Westermann (DWE) 09:37
Re: How to get the name of the current database in C function/extention inside a trigger? David Rowley 10:34
How can you find out what point logical replication is at? John Ashmead 14:38
Re: 12.3 replicas falling over during WAL redo Ben Chobot 14:41
Re: How to get the name of the current database in C function/extention inside a trigger? alex m 15:14
Keeping state in a foreign data wrapper Stelios Sfakianakis 16:23
How to rebuild index efficiently Konireddy Rajashekar 17:20
Re: How to rebuild index efficiently Christophe Pettus 17:58
Re: How to rebuild index efficiently Ron 18:04
Re: How to rebuild index efficiently Michael Lewis 18:14
Re: 12.3 replicas falling over during WAL redo Peter Geoghegan 18:25
Re: 12.3 replicas falling over during WAL redo Ben Chobot 19:11
Re: 12.3 replicas falling over during WAL redo Alvaro Herrera 19:34
Re: 12.3 replicas falling over during WAL redo Ben Chobot 19:55
Configuring only SSL in postgres docker image Shankar Bhaskaran 20:01
Re: 12.3 replicas falling over during WAL redo Ben Chobot 20:26
Re: 12.3 replicas falling over during WAL redo Ben Chobot 20:49
Re: 12.3 replicas falling over during WAL redo Alvaro Herrera 21:34
Re: 12.3 replicas falling over during WAL redo Peter Geoghegan 22:04
Re: 12.3 replicas falling over during WAL redo Ben Chobot 22:10
Re: 12.3 replicas falling over during WAL redo Ben Chobot 22:42
Re: How can you find out what point logical replication is at? -- or weird, slow, infinite loop John Ashmead 22:55
Re: 12.3 replicas falling over during WAL redo Alvaro Herrera 23:54

Aug. 4, 2020

Thread Author Time
Re: bad JIT decision David Rowley 01:33
Re: Keeping state in a foreign data wrapper Ian Lawrence Barwick 03:25
Re: Configuring only SSL in postgres docker image Paul Förster 05:32
Re: Keeping state in a foreign data wrapper Stelios Sfakianakis 05:54
Re: How to rebuild index efficiently Michael Paquier 06:07
Re: Keeping state in a foreign data wrapper Ian Lawrence Barwick 08:24
Unexplained disk usage in AWS Aurora Postgres Chris Borckholder 08:39
PostgreSQL transaction aborted on SQL error Urko Lekuona 08:44
Sv: PostgreSQL transaction aborted on SQL error Andreas Joseph Krogh 09:25
Re: PostgreSQL transaction aborted on SQL error Thomas Kellerer 09:28
Re: Unexplained disk usage in AWS Aurora Postgres Srinivasa T N 09:39
Re: Keeping state in a foreign data wrapper Stelios Sfakianakis 10:21
Re: Querying PostgreSQL / PostGIS Databases in Python Tony Shelver 12:09
Re: Querying PostgreSQL / PostGIS Databases in Python Tony Shelver 13:28
Re: 12.3 replicas falling over during WAL redo Alvaro Herrera 13:53
PostgreSQL-12 replication. Check replication lag Mariya Rampurawala 15:23
Postgres 12 - default value for text column Raj Gandhi 20:35
Logical replication from multiple masters - master starvation Dan shmidt 20:40
Re: Postgres 12 - default value for text column David Rowley 20:59
Re: Postgres 12 - default value for text column Raj Gandhi 21:50

Aug. 5, 2020

Thread Author Time
Re:ERROR: XX000: cannot update SecondarySnapshot during a parallel operation 📎 fight.mufasa 03:25
Re: 12.3 replicas falling over during WAL redo Kyotaro Horiguchi 05:42
Re: Track pgsql steps Pavel Stehule 09:28
ERROR: canceling statement due to user request FOUTE K. Jaurès 09:35
Re: ERROR: canceling statement due to user request Pavel Stehule 10:02
Re: ERROR: canceling statement due to user request Paul Förster 10:07
Re: ERROR: canceling statement due to user request Pavel Stehule 10:12
Re: ERROR: canceling statement due to user request FOUTE K. Jaurès 10:50
Re: ERROR: canceling statement due to user request Pavel Stehule 10:57
Re: ERROR: canceling statement due to user request Ron 12:21
Re: ERROR: canceling statement due to user request FOUTE K. Jaurès 16:42
RE: PostgreSQL-12 replication. Check replication lag Ahmed, Nawaz (Fuji Xerox Australia) 18:10
Re: [EXTERNAL] RE: PostgreSQL-12 replication. Check replication lag Mariya Rampurawala 18:36
Check replication lag Sreejith P 19:01
Postgres, High Availability, patching servers sequentially David Gauthier 21:36

Aug. 6, 2020

Thread Author Time
Re: Unexplained disk usage in AWS Aurora Postgres Mohamed Wael Khobalatte 01:18
Doubt in pgbase Rama Krishnan 02:10
Re: Doubt in pgbase Ian Barwick 02:21
Re: Doubt in pgbase Rama Krishnan 02:22
Re: Check replication lag Thomas Munro 02:28
Re: [EXTERNAL] RE: PostgreSQL-12 replication. Check replication lag Michael Paquier 02:39
Can PAF be used to provide zero downtime while primary and backup servers are being patched? David Gauthier 14:01
privileges oddity Scott Ribe 18:11
Re: privileges oddity Tom Lane 18:22
Re: privileges oddity Adrian Klaver 18:22
Re: privileges oddity Scott Ribe 18:35
Re: privileges oddity Scott Ribe 18:36
Re: privileges oddity Adrian Klaver 18:36
Re: privileges oddity Tom Lane 18:38
Re: privileges oddity Scott Ribe 18:39
Re: privileges oddity Adrian Klaver 18:41
Re: privileges oddity Scott Ribe 18:50
Re: privileges oddity Stephen Frost 18:53
Re: privileges oddity Scott Ribe 20:34
Re: privileges oddity Scott Ribe 21:48
Standard practices for granting privileges Lokesh Vij 22:03
Re: Can PAF be used to provide zero downtime while primary and backup servers are being patched? Bruce Momjian 22:18

Aug. 7, 2020

Thread Author Time
Advancing the archiver position safely Christophe Pettus 00:43
Re: Advancing the archiver position safely Jerry Sievers 01:45
Re: Advancing the archiver position safely Christophe Pettus 02:00
Re: Unexplained disk usage in AWS Aurora Postgres Chris Borckholder 12:34
Re: Unexplained disk usage in AWS Aurora Postgres Chris Borckholder 12:37
Re: Unexplained disk usage in AWS Aurora Postgres Adam Brusselback 13:03
Re: Unexplained disk usage in AWS Aurora Postgres Christoph Moench-Tegeder 14:22
Re: Unexplained disk usage in AWS Aurora Postgres Chris Borckholder 14:33
Re: Unexplained disk usage in AWS Aurora Postgres Ravi Krishna 14:57
Re: privileges oddity Scott Ribe 16:23
Re: privileges oddity Adrian Klaver 17:14
Re: privileges oddity Scott Ribe 17:31
Re: privileges oddity Scott Ribe 17:39
Re: privileges oddity Adrian Klaver 18:17
Re: privileges oddity Scott Ribe 18:25
Re: privileges oddity Adrian Klaver 18:27
Re: privileges oddity Scott Ribe 18:35
Re: privileges oddity Tom Lane 18:45
Re: privileges oddity Scott Ribe 18:56
Re: privileges oddity Adrian Klaver 19:08
Re: privileges oddity Scott Ribe 19:27
Re: privileges oddity Tom Lane 19:32
Re: privileges oddity Adrian Klaver 19:40
Re: privileges oddity Adrian Klaver 19:46
Re: privileges oddity Scott Ribe 19:51
Re: privileges oddity Scott Ribe 20:29
Re: privileges oddity Tom Lane 20:38

Aug. 9, 2020

Thread Author Time
Need help how to reproduce MySQL binary to PosgreSQL Condor 06:12
Re: Need help how to reproduce MySQL binary to PosgreSQL Ashesh Vashi 06:20
Re: Need help how to reproduce MySQL binary to PosgreSQL Condor 11:49
Re: Need help how to reproduce MySQL binary to PosgreSQL Geoff Winkless 12:41

Aug. 10, 2020

Thread Author Time
Need a depth information about bloat Rama Krishnan 03:01
Re: Need a depth information about bloat Adrian Klaver 04:17
Re: Need a depth information about bloat Rob Sargent 04:17
Re: Need a depth information about bloat Rama Krishnan 04:19
Re: Need a depth information about bloat Rama Krishnan 04:20
xact_start time set to very old value Virendra Kumar 06:05
UUID or auto-increment Ashkar Dev 15:53
SQL Question about like pgml@gmx.de 16:37
Re: UUID or auto-increment Ravi Krishna 16:38
Re: SQL Question about like Ron 16:48
Re: UUID or auto-increment Michael Lewis 16:49
Re: SQL Question about like Adrian Klaver 16:51
Re: UUID or auto-increment Ron 16:51
Re: UUID or auto-increment Stephen Frost 16:53
Re: UUID or auto-increment Adrian Klaver 16:58
Re: SQL Question about like Michael Nolan 17:01
Re: UUID or auto-increment Israel Brewster 17:10
Re: UUID or auto-increment Stephen Frost 17:16
Re: SQL Question about like Adrian Klaver 17:24
Re: UUID or auto-increment Adam Brusselback 17:38
Re: SQL Question about like Michael Nolan 17:44
Re: SQL Question about like Michael Nolan 17:49
Certficates Shankar Bhaskaran 17:53
Re: Certficates Martin Gainty 18:10
Re: UUID or auto-increment Peter J. Holzer 20:06
Re: Certficates David G. Johnston 20:08
Re: Certficates David G. Johnston 20:10
Re: Certficates Tom Lane 20:15
Re: UUID or auto-increment Israel Brewster 20:44
Re: UUID or auto-increment Rob Sargent 20:56
Re: UUID or auto-increment John W Higgins 21:30
serial + db key, or guid? Mark Phillips 22:19
Re: serial + db key, or guid? Christophe Pettus 22:21

Aug. 11, 2020

Thread Author Time
Re: Keeping state in a foreign data wrapper Ian Barwick 01:19
Re: Keeping state in a foreign data wrapper Ian Barwick 01:19
Re: ERROR: invalid memory alloc request size 18446744073709551613 Flaris Roland Feller 02:00
Re: ERROR: invalid memory alloc request size 18446744073709551613 Flaris Roland Feller 02:22
Re: ERROR: invalid memory alloc request size 18446744073709551613 Flaris Roland Feller 02:30
Re: Keeping state in a foreign data wrapper Laurenz Albe 09:05
Implement a new data type mohand oubelkacem makhoukhene 11:31
Re: Implement a new data type Laurenz Albe 12:00
Re: Implement a new data type Pavel Stehule 12:01
Re: Implement a new data type Miles Elam 13:38
Re: Implement a new data type Adrian Klaver 13:39
How is PG replication typically used to create a High Availability (HA) config ? David Gauthier 15:12
Re: How is PG replication typically used to create a High Availability (HA) config ? Paul Förster 15:47
Sizing PostgreSQL VM server sizing Samarendra Sahoo 16:19
Re: Certficates Shankar Bhaskaran 16:26
Re: serial + db key, or guid? Mark Phillips 16:37
Re: serial + db key, or guid? Christophe Pettus 16:40
Re: serial + db key, or guid? Christopher Browne 17:01
Re: serial + db key, or guid? Adam Brusselback 17:42
Re: How is PG replication typically used to create a High Availability (HA) config ? David Gauthier 20:57
Re: How is PG replication typically used to create a High Availability (HA) config ? Rob Sargent 21:05

Aug. 12, 2020

Thread Author Time
Re: Implement a new data type raf 00:01
pglogical 2.3.2 on 9.4 --> 12.3 CONFLICT: remote DELETE (tuple not found). Resolution: skip. milist ujang 03:50
Re: Sizing PostgreSQL VM server sizing Amul Sul 04:14
Re: Sizing PostgreSQL VM server sizing Samarendra Sahoo 04:30
Re: Implement a new data type Chris Travers 05:38
Re: How is PG replication typically used to create a High Availability (HA) config ? Paul Förster 08:11
Re: pglogical 2.3.2 on 9.4 --> 12.3 CONFLICT: remote DELETE (tuple not found). Resolution: skip. milist ujang 12:35
Postgres automatic minor version upgrade Shantanu Shekhar 12:46
insert on conflict postgres returning distinction pinker 14:23
Re: Postgres automatic minor version upgrade Adrian Klaver 14:26
Re: insert on conflict postgres returning distinction Adrian Klaver 16:01
Re: insert on conflict postgres returning distinction pinker 16:24
Re: Implement a new data type Philip Semanchuk 16:44
Re: Sizing PostgreSQL VM server sizing Michael Lewis 16:50
Re: insert on conflict postgres returning distinction pinker 18:52
Re: insert on conflict postgres returning distinction pinker 20:13
Re: Server goes to Recovery Mode when run a SQL PegoraroF10 20:47
psql and jdbc default sslmode Shankar Bhaskaran 20:54
Re: Server goes to Recovery Mode when run a SQL Tom Lane 22:09
Re: Implement a new data type raf 23:38
Re: How is PG replication typically used to create a High Availability (HA) config ? David Gauthier 23:43

Browse Archives

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