Home > mailing lists

Mailing lists [pgsql-general]

1 February 2019

00:00 Re: Date calculation Andrew Gierth
17:01 FK Constraint with ON DELETE SET DEFAULT cascading as table owner Brad Leupen
17:34 Re: pgexpress 4.60 vita voom ceuro

2 February 2019

07:17 Re: FK Constraint with ON DELETE SET DEFAULT cascading as tableowner rob stone
07:59 FK Constraint with ON DELETE SET DEFAULT cascading as table owner David G. Johnston

3 February 2019

11:43 Re: Revoke SQL doesn't take effect Jason W
18:53 Server goes to Recovery Mode when run a SQL PegoraroF10
19:05 Re: Server goes to Recovery Mode when run a SQL PegoraroF10
19:08 Re: Server goes to Recovery Mode when run a SQL Adrian Klaver
19:32 Re: Server goes to Recovery Mode when run a SQL PegoraroF10
21:05 Re: Server goes to Recovery Mode when run a SQL Adrian Klaver

4 February 2019

04:07 Re: Server goes to Recovery Mode when run a SQL Michael Paquier
08:34 JSONB Array of Strings (with GIN index) versus Split Rows (B-TreeIndex) Syed Jafri
08:57 Re: Server goes to Recovery Mode when run a SQL rob stone
10:14 FDW, too long to run explain Vijaykumar Jain
13:10 Need details on 9.6 version of postgres A H S Phanindra
14:13 Re: Server goes to Recovery Mode when run a SQL PegoraroF10
18:06 Re: Need details on 9.6 version of postgres Adrian Klaver
18:09 Re: Server goes to Recovery Mode when run a SQL Adrian Klaver
18:22 Re: Need details on 9.6 version of postgres Andreas Kretschmer
18:33 Re: Server goes to Recovery Mode when run a SQL PegoraroF10
18:53 Re: Server goes to Recovery Mode when run a SQL Adrian Klaver

5 February 2019

00:44 Re: JSONB Array of Strings (with GIN index) versus Split Rows(B-Tree Index) Ian Zimmerman
01:02 Re: JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index) David G. Johnston
01:05 Re: Server goes to Recovery Mode when run a SQL rob stone
12:27 Re: oracle_fwd - is it safe or not? Peter Eisentraut
12:48 Connection issue Maximilian Tyrtania
17:57 Re: Connection issue Adrian Klaver
18:18 Re: Connection issue Maximilian Tyrtania
18:44 Re: Connection issue Adrian Klaver
20:47 Auto close idle connections for specific user (not by pg_cancelcommand) Emi
20:51 Re: Auto close idle connections for specific user (not by pg_cancel command) Pavel Stehule
20:59 Re: Auto close idle connections for specific user (not by pg_cancel command) Thomas Poty
21:23 Re: Auto close idle connections for specific user (not by pg_cancel command) Thomas Poty
21:37 Re: Auto close idle connections for specific user (not by pg_cancel command) Thomas Poty

6 February 2019

02:19 RE: Connection issue Ricardo Martin Gomez
18:18 Re: Connection issue Maximilian Tyrtania
19:14 Calling rest service from postgresql functions and stored proc mahesh.sp
19:19 Re: Connection issue Adrian Klaver
19:30 Re: Connection issue Maximilian Tyrtania
19:43 Re: Connection issue Adrian Klaver
21:56 Re: Implementing an expanded object in C Michel Pelletier
23:37 How to find out tables that are frequently read/ write? Jason W

7 February 2019

05:12 Re: Connection issue Ricardo Martin Gomez
12:57 Re: Calling rest service from postgresql functions and stored proc Magnus Hagander
13:00 Re: Calling rest service from postgresql functions and stored proc Pavel Stehule
13:25 Re: Connection issue Maximilian Tyrtania
13:39 How to add a new psql command ? Quentin Di-Fant
14:02 Re: How to add a new psql command ? Pavel Stehule
19:28 Odd messages on reloading DB table Steve Wampler
19:38 Re: Odd messages on reloading DB table Steve Wampler
20:16 Re: How to add a new psql command ? Michel Pelletier

8 February 2019

01:24 Re: Odd messages on reloading DB table David G. Johnston
01:44 Full text search parser dictionary Eugene Podshivalov
16:29 query logging of prepared statements Justin Pryzby

9 February 2019

00:11 Re: Server goes to Recovery Mode when run a SQL PegoraroF10
00:22 Re: [EXTERNAL]Re: Server goes to Recovery Mode when run a SQL Jeremiah Bauer
00:23 Re: Server goes to Recovery Mode when run a SQL Adrian Klaver
13:08 Trigger function always logs postgres as user name Alexander Reichstadt
14:39 Re: FDW, too long to run explain auxsvr
15:44 Re: Trigger function always logs postgres as user name Francisco Olarte

10 February 2019

00:46 Re: Server goes to Recovery Mode when run a SQL Justin Pryzby
04:57 Re: query logging of prepared statements Justin Pryzby
07:15 Re: Server goes to Recovery Mode when run a SQL rob stone
11:19 Unused files in the database directory after crashed VACUUM FULL Hannes Erven
18:41 Re: Unused files in the database directory after crashed VACUUM FULL Tom Lane
18:53 Re: Unused files in the database directory after crashed VACUUM FULL Andrew Gierth
20:32 Promote replica before being able to accept connections Martín Fernández

11 February 2019

01:49 Re: Unused files in the database directory after crashed VACUUM FULL Hannes Erven
01:57 Shared hosting with FDW on AWS RDS auxsvr
02:19 Re: Shared hosting with FDW on AWS RDS Paul Jungwirth
02:20 Re: Unused files in the database directory after crashed VACUUM FULL Tom Lane
07:03 Re: Unused files in the database directory after crashed VACUUM FULL Thomas Munro
12:10 Re: tsvector field length limitation AJG
13:18 bdr replication breaks down Daniel Fink (PDF)
13:55 Re: Promote replica before being able to accept connections Laurenz Albe
14:09 Postgresql Duplicate DB Sathish Kumar
14:16 RE: Postgresql Duplicate DB Alvaro Aguayo Garcia-Rada
14:16 Re: Postgresql Duplicate DB Laurenz Albe
16:21 Re: bdr replication breaks down Alvaro Aguayo Garcia-Rada
16:23 Implementing pgaudit extension on Microsoft Windows Niels Jespersen
17:32 RE: bdr replication breaks down Daniel Fink (PDF)
17:37 Re: Implementing pgaudit extension on Microsoft Windows Pavel Stehule
17:43 Re: Implementing pgaudit extension on Microsoft Windows Tom Lane
17:47 Re: Implementing pgaudit extension on Microsoft Windows Pavel Stehule
17:59 Re: Promote replica before being able to accept connections Martín Fernández
19:00 Copy entire schema A to a different schema B Tiffany Thang
19:07 Re: Copy entire schema A to a different schema B Adrian Klaver
19:10 Re: Copy entire schema A to a different schema B Ron
19:30 Re: Copy entire schema A to a different schema B Tiffany Thang
19:53 Re: Copy entire schema A to a different schema B Adrian Klaver
22:29 Re: Odd messages on reloading DB table Steve Wampler
23:03 Re: Odd messages on reloading DB table David G. Johnston

12 February 2019

00:14 Aurora Postgresql RDS DB Latency github kran
00:29 Re: Aurora Postgresql RDS DB Latency Michael Lewis
01:44 Blank, nullable date column rejected by psql Rich Shepard
01:49 Re: Blank, nullable date column rejected by psql Ron
01:49 Re: Blank, nullable date column rejected by psql Adrian Klaver
01:50 Re: Blank, nullable date column rejected by psql Tom Lane
01:58 Re: Blank, nullable date column rejected by psql David G. Johnston
02:30 Re: Blank, nullable date column rejected by psql Rich Shepard
02:32 Re: Blank, nullable date column rejected by psql Rich Shepard
02:41 Re: Blank, nullable date column rejected by psql Ron
02:43 Re: Blank, nullable date column rejected by psql Rich Shepard
02:44 Re: Blank, nullable date column rejected by psql Rich Shepard
02:55 Re: Blank, nullable date column rejected by psql Ken Tanzer
03:00 Re: Aurora Postgresql RDS DB Latency github kran
03:05 Re: Blank, nullable date column rejected by psql Rich Shepard
03:29 Re: Blank, nullable date column rejected by psql Ken Tanzer
03:42 Re: Blank, nullable date column rejected by psql Ron
06:17 Re: Promote replica before being able to accept connections Michael Paquier
06:24 Re: Server goes to Recovery Mode when run a SQL Michael Paquier
10:57 SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen
10:59 Re: Implementing pgaudit extension on Microsoft Windows Pavel Stehule
11:00 Re: Implementing pgaudit extension on Microsoft Windows Pavel Stehule
11:20 Re: Blank, nullable date column rejected by psql Laurenz Albe
12:34 SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen
14:22 Re: Implementing pgaudit extension on Microsoft Windows Pavel Stehule
16:07 Re: Aurora Postgresql RDS DB Latency github kran
16:42 Re: Blank, nullable date column rejected by psql Rich Shepard
17:14 Re: SV: Implementing pgaudit extension on Microsoft Windows Tom Lane
17:52 BDR 1.0: background worker wants to start that should not be there Daniel Fink (PDF)
18:12 Re: postgresql v11.1 Segmentation fault: signal 11: by runningSELECT... JIT Issue? Justin Pryzby
18:14 Re: BDR 1.0: background worker wants to start that should not bethere Alvaro Aguayo Garcia-Rada
19:20 Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child Vikas Sharma
19:31 Re: postgresql v11.1 Segmentation fault: signal 11: by runningSELECT... JIT Issue? pabloa98
19:32 pg_dump on a standby for a very active master Arjun Ranade
19:39 Re: Out of memory: Kill process nnnn (postmaster) score nn orsacrifice child Adrian Klaver
20:10 Re: Copy entire schema A to a different schema B Tiffany Thang
20:36 RE: pg_dump on a standby for a very active master Scot Kreienkamp
20:59 Re: pg_dump on a standby for a very active master Stephen Frost
21:02 Re: pg_dump on a standby for a very active master Arjun Ranade
21:06 Re: pg_dump on a standby for a very active master Stephen Frost
21:18 Re: pg_dump on a standby for a very active master Arjun Ranade
21:27 Postgresql RDS DB Latency Chossing Hash join Plan github kran
21:30 Temp tables and replication identities Michael Lewis
21:33 Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis
21:55 Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran

13 February 2019

01:23 Subquery to select max(date) value Rich Shepard
01:29 Re: Subquery to select max(date) value David G. Johnston
01:32 Re: Subquery to select max(date) value [RESOLVED] Rich Shepard
01:43 Re: Subquery to select max(date) value Rich Shepard
01:48 Re: Subquery to select max(date) value Rich Shepard
01:55 Re: Subquery to select max(date) value Matt Zagrabelny
01:58 Re: Subquery to select max(date) value Adrian Klaver
01:59 Re: Subquery to select max(date) value Ken Tanzer
02:02 Re: Subquery to select max(date) value Rich Shepard
02:20 Re: Subquery to select max(date) value Rich Shepard
02:36 Getting wrong time using now() Om Prakash Jaiswal
02:36 Getting wrong time using now() Om Prakash Jaiswal
02:38 Re: Subquery to select max(date) value Ken Tanzer
02:40 Re: Getting wrong time using now() Adrian Klaver
02:40 Re: Getting wrong time using now() Adrian Klaver
02:46 Re: Getting wrong time using now() Tom Lane
02:46 Re: Getting wrong time using now() Tom Lane
02:48 Re: Subquery to select max(date) value Rich Shepard
03:44 Re: Subquery to select max(date) value Andrew Gierth
11:32 SV: SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen
12:48 Is the ring buffer not used for index blocks Daniel Westermann
13:32 Re: Subquery to select max(date) value Jan Kohnert
14:41 Re: Server goes to Recovery Mode when run a SQL PegoraroF10
15:29 Re: Server goes to Recovery Mode when run a SQL rob stone
15:32 Re: Server goes to Recovery Mode when run a SQL PegoraroF10
15:40 Re: Out of memory: Kill process nnnn (postmaster) score nn orsacrifice child Vikas Sharma
16:34 Re: Subquery to select max(date) value Rich Shepard
16:41 Re: Server goes to Recovery Mode when run a SQL rob stone
17:15 Re: Server goes to Recovery Mode when run a SQL PegoraroF10
17:17 Re: SV: SV: Implementing pgaudit extension on Microsoft Windows Joe Conway
17:28 Re: Subquery to select max(date) value Rich Shepard
17:48 Re: Subquery to select max(date) value Adrian Klaver
18:37 Re: Subquery to select max(date) value Rich Shepard
18:46 Re: Subquery to select max(date) value Adrian Klaver
18:49 Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran
19:01 Re: Subquery to select max(date) value Adrian Klaver
19:13 Re: Subquery to select max(date) value Rich Shepard
20:06 Re: Subquery to select max(date) value Rich Shepard
20:29 Re: Subquery to select max(date) value Adrian Klaver
20:37 Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis
20:38 Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child Andreas Kretschmer
21:09 Re: Subquery to select max(date) value Rich Shepard
23:25 Re: Subquery to select max(date) value Adrian Klaver
23:58 Re: Subquery to select max(date) value Andrew Gierth

14 February 2019

00:04 Postgrest over foreign data wrapper adrien ruffie
00:36 Re: Postgrest over foreign data wrapper Adrian Klaver
00:36 Re: Postgrest over foreign data wrapper Michael Lewis
00:43 Re: Postgrest over foreign data wrapper Adrian Klaver
00:54 Re: Postgrest over foreign data wrapper Michael Lewis
01:21 Problem linking to libpq.lib on Windows Roberto de Figueiredo Ribeiro
01:24 Re: Subquery to select max(date) value Rich Shepard
01:49 Streaming replication - invalid resource manager ID Maeldron T.
01:52 Re: Subquery to select max(date) value Adrian Klaver
02:13 Re: Subquery to select max(date) value Rich Shepard
02:33 Re: SV: SV: Implementing pgaudit extension on Microsoft Windows Joe Conway
02:51 Re: Subquery to select max(date) value Brent Wood
03:26 Re: Subquery to select max(date) value Rich Shepard
11:06 SV: SV: SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen
11:41 SV: SV: SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen
12:51 logical replication suganthi Sekar
13:59 Re: Problem linking to libpq.lib on Windows Dmitry Igrishin
14:43 RES: Problem linking to libpq.lib on Windows Roberto de Figueiredo Ribeiro
14:45 Re: [External] logical replication Vijaykumar Jain
15:06 Re: [External] logical replication suganthi Sekar
16:19 Re: Streaming replication - invalid resource manager ID Laurenz Albe
18:10 Re: [External] logical replication Vijaykumar Jain
18:47 Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran
19:06 How to setup only one connection for the whole event loop? Dominic Gua�a
20:01 Version 11.2 for SLES 12? Lu, Dan
21:43 Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis

15 February 2019

01:11 Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran
01:58 Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis
02:04 Correct setup for 3+ node cluster with streaming replication and WAL archiving Andre Piwoni
03:17 loading plpython error Alan Nilsson
03:27 Re: loading plpython error Adrian Klaver
03:33 WSL (windows subsystem on linux) users will need to turn fsync off asof 11.2 Bruce Klein
03:34 Re: loading plpython error Adrian Klaver
03:39 Re: loading plpython error Adrian Klaver
03:42 Re: loading plpython error Tom Lane
03:46 Re: loading plpython error Alan Hodgson
03:48 Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2 Tom Lane
04:19 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Bruce Klein
04:55 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Bruce Klein
05:56 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Thomas Munro
06:14 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Thomas Munro
06:21 Re: Shared hosting with FDW on AWS RDS Bruce Momjian
07:28 Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2 Tom Lane
08:06 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Thomas Munro
16:55 PostgreSql Version Compatibility With Apache ActiveMQ Rameshbabu Paulsamy (UST, IND)
18:05 Re: Shared hosting with FDW on AWS RDS Bruno Lavoie
18:28 Problems pushing down WHERE-clause to underlying view Nicklas Avén
18:44 Re: PostgreSql Version Compatibility With Apache ActiveMQ Adrian Klaver
19:06 Re: Problems pushing down WHERE-clause to underlying view Adrian Klaver
19:08 Re: How to setup only one connection for the whole event loop? Adrian Klaver
19:33 RE: PostgreSql Version Compatibility With Apache ActiveMQ Rameshbabu Paulsamy (UST, IND)
19:33 Size estimation of postgres core files Jeremy Finzel
19:36 Re: Size estimation of postgres core files Alvaro Herrera
20:06 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Andres Freund
20:13 Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2 Tom Lane
20:17 Re: loading plpython error Alan Nilsson
20:21 Using NOTIFY from a java application. Philippe Ebersohl
20:27 Re: Problems pushing down WHERE-clause to underlying view Nicklas Avén
20:41 Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2 Andres Freund
20:44 Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2 Tom Lane
20:49 Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2 Andres Freund
21:05 Re: PostgreSql Version Compatibility With Apache ActiveMQ Adrian Klaver
21:18 Re: Size estimation of postgres core files Jeremy Finzel
21:23 Promoted slave tries to archive previously archived WAL file Andre Piwoni
21:27 Re: Size estimation of postgres core files Andrew Gierth
21:31 Re: Problems pushing down WHERE-clause to underlying view Adrian Klaver
22:01 Re: Size estimation of postgres core files Jeremy Finzel
23:03 Re: Promoted slave tries to archive previously archived WAL file Andre Piwoni
23:38 Re: Subquery to select max(date) value Rich Shepard
23:41 Channel binding not supported using scram-sha-256 passwords Hugh Ranalli
23:43 Re: Problems pushing down WHERE-clause to underlying view Nicklas Avén
23:46 Re: Trigger function always logs postgres as user name Alexander Reichstadt
23:53 Re: Subquery to select max(date) value Andrew Gierth

16 February 2019

00:07 Re: Subquery to select max(date) value Rich Shepard
00:14 Re: Channel binding not supported using scram-sha-256 passwords Bruce Momjian
00:18 Re: Channel binding not supported using scram-sha-256 passwords Hugh Ranalli
00:20 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Thomas Munro
00:33 Re: Subquery to select max(date) value Rich Shepard
00:56 Re: Subquery to select max(date) value Andrew Gierth
01:04 Re: Subquery to select max(date) value Rich Shepard
01:04 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Bruce Klein
03:08 Re: Problems pushing down WHERE-clause to underlying view Adrian Klaver
06:16 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Ron
08:02 Re: Problems pushing down WHERE-clause to underlying view Tom Lane
11:27 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Hans Schou
13:35 Re: How to setup only one connection for the whole event loop? Francisco Olarte
13:47 Re: Problems pushing down WHERE-clause to underlying view Nicklas Avén
18:56 Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2 Tom Lane

17 February 2019

13:29 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Thomas Munro
13:57 Re: FDW, too long to run explain auxsvr
14:32 Re: [External] Re: FDW, too long to run explain Vijaykumar Jain
19:06 Re: WSL (windows subsystem on linux) users will need to turn fsync off as of11.2 Ravi Krishna
20:03 Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran
20:41 Re: FDW, too long to run explain Jeff Janes
21:51 Re: [External] Re: FDW, too long to run explain Vijaykumar Jain
21:54 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Andres Freund
21:58 Re: FDW, too long to run explain Jeff Janes
22:09 Re: FDW, too long to run explain Tom Lane
22:26 Re: [External] Re: FDW, too long to run explain Jeff Janes
22:26 Re: [External] Re: FDW, too long to run explain Vijaykumar Jain
22:36 Re: [External] Re: FDW, too long to run explain Vijaykumar Jain
22:43 Re: FDW, too long to run explain auxsvr

18 February 2019

00:00 Re: [External] Re: FDW, too long to run explain Jeff Janes
00:14 Re: [External] Re: FDW, too long to run explain Vijaykumar Jain
00:36 Re: [External] Re: FDW, too long to run explain Jeff Janes
00:52 pg_stat_statements doesn't track commit from pl/pgsql blocks legrand legrand
01:11 Table Inheritance and Foreign Keys Riaan Stander
01:58 Re: Table Inheritance and Foreign Keys Tom Lane
04:06 Re: Channel binding not supported using scram-sha-256 passwords Michael Paquier
04:19 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Michael Paquier
04:27 Re: Promoted slave tries to archive previously archived WAL file Michael Paquier
05:34 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Thomas Munro
11:57 Re: Slot issues hvjunk
13:22 Re: [External] Re: FDW, too long to run explain Vijaykumar Jain
14:09 Slony and triggers on slavenodes. Gustavsson Mikael
14:31 Re: Slony and triggers on slavenodes. Achilleas Mantzios
15:05 Cannot vacuum even in single-user mode after xidStopLimit is reached Jahwan Kim
15:06 BEFORE ... Statement-level trigger Jitendra Loyal
15:11 Statement-level trigger results in recursion Jitendra Loyal
15:35 SV: Slony and triggers on slavenodes. Gustavsson Mikael
16:49 Re: Cannot vacuum even in single-user mode after xidStopLimit isreached Arthur Zakirov
17:18 Re: Cannot vacuum even in single-user mode after xidStopLimit is reached Jahwan Kim
18:11 Re: Cannot vacuum even in single-user mode after xidStopLimit isreached Arthur Zakirov
18:19 Re: Cannot vacuum even in single-user mode after xidStopLimit is reached Jahwan Kim
18:33 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Ravi Krishna
19:01 Re: Statement-level trigger results in recursion Adrian Klaver
19:12 Re: BEFORE ... Statement-level trigger Adrian Klaver
19:20 Re: BEFORE ... Statement-level trigger Jitendra Loyal
19:23 Re: Statement-level trigger results in recursion Jitendra Loyal
19:29 Re: Statement-level trigger results in recursion Adrian Klaver
19:31 Re: BEFORE ... Statement-level trigger Adrian Klaver
19:38 Re: Statement-level trigger results in recursion Jitendra Loyal
19:44 Re: Statement-level trigger results in recursion Adrian Klaver
20:01 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Andres Freund
20:07 Re: Statement-level trigger results in recursion Jitendra Loyal
20:11 Re: BEFORE ... Statement-level trigger Jitendra Loyal
20:20 HAVING query structured wrong Chuck Martin
20:37 Re: HAVING query structured wrong Andrew Gierth
20:52 Re: Channel binding not supported using scram-sha-256 passwords Hugh Ranalli
23:08 PG Upgrade with hardlinks, when to start/stop master and replicas Martín Fernández
23:20 Re: PG Upgrade with hardlinks, when to start/stop master andreplicas Laurenz Albe
23:32 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Hellmuth Vargas
23:41 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Martín Fernández

19 February 2019

00:49 Re: Statement-level trigger results in recursion Adrian Klaver
00:55 Re: BEFORE ... Statement-level trigger Adrian Klaver
01:14 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Thomas Munro
02:39 Re: Statement-level trigger results in recursion Jitendra Loyal
02:46 Re: BEFORE ... Statement-level trigger Jitendra Loyal
03:50 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 James Sewell
04:06 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Andres Freund
05:59 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 James Sewell
07:16 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 James Sewell
07:31 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Thomas Munro
14:11 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Stephen Frost
16:40 Plpythonu extension Vincent Predoehl
17:07 Re: HAVING query structured wrong Chuck Martin
17:19 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Hellmuth Vargas
18:05 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Stephen Frost
18:39 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Hellmuth Vargas
19:20 Re: PG Upgrade with hardlinks, when to start/stop master andreplicas Martín Fernández
19:37 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Stephen Frost
19:51 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Martín Fernández
19:57 Re: Promoted slave tries to archive previously archived WAL file Andre Piwoni
20:11 Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis
20:25 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Stephen Frost
23:31 procedures and transactions Rob Nikander
23:38 Re: procedures and transactions David G. Johnston
23:41 Re: procedures and transactions Adrian Klaver
23:41 Partial index on JSON column Samuel Williams
23:51 PG 9.6 managed fail over of master, how do i manage a pg_logicalsubscriber Reid Thompson

20 February 2019

00:14 Re: Partial index on JSON column Tom Lane
00:24 Re: Partial index on JSON column Samuel Williams
00:25 Re: Partial index on JSON column Michael Lewis
00:28 Re: Partial index on JSON column Michael Lewis
00:29 Re: Partial index on JSON column Samuel Williams
00:48 Re: procedures and transactions Rob Nikander
01:34 Re: procedures and transactions Adrian Klaver
02:02 adding more space to the existing 9.6 cluster Julie Nishimura
02:17 Re: Partial index on JSON column Tom Lane
03:39 Re: Partial index on JSON column Samuel Williams
13:12 LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes Mike Yeap
13:58 RE: Implementing pgaudit extension on Microsoft Windows Niels Jespersen
14:58 Re: LDAP authenticated session terminated by signal 11:Segmentation fault, PostgresSQL server terminates other active serverprocesses Laurenz Albe
14:59 Re: Implementing pgaudit extension on Microsoft Windows Joe Conway
17:16 Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes Tom Lane
17:46 Plpythonu extension Vincent Predoehl
18:53 Re: Channel binding not supported using scram-sha-256 passwords Peter Eisentraut
19:01 Re: Plpythonu extension Peter Eisentraut
19:01 Re: Plpythonu extension Adrian Klaver
19:06 Re: Plpythonu extension Vincent Predoehl
19:07 Re: procedures and transactions Peter Eisentraut
19:13 Re: Plpythonu extension Adrian Klaver
19:21 Long statement execution. Data fetch by client Pavel Suderevsky
19:45 Re: procedures and transactions Rob Nikander
20:10 Re: Plpythonu extension Anthony DeBarros
23:18 adding more space to the existing 9.6 cluster Julie Nishimura
23:37 Re: adding more space to the existing 9.6 cluster Ron

21 February 2019

01:22 Re: Copy entire schema A to a different schema B Tiffany Thang
01:28 Re: Plpythonu extension Vincent Predoehl
01:36 Re: Copy entire schema A to a different schema B Rob Sargent
02:21 Re: Copy entire schema A to a different schema B Tiffany Thang
03:02 Re: Copy entire schema A to a different schema B Rob Sargent
03:16 Re: Copy entire schema A to a different schema B Adrian Klaver
03:26 Re: Plpythonu extension Adrian Klaver
03:40 Re: Copy entire schema A to a different schema B Ron
04:42 Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes Mike Yeap
05:03 Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes Tom Lane
05:49 Re: Plpythonu extension Vincent Predoehl
07:10 Connection string for Java to connect to PostgreSQL, using clientcertificates
07:14 Re: Copy entire schema A to a different schema B Jiří Fejfar
07:41 Re: Connection string for Java to connect to PostgreSQL, usingclient certificates rob stone
07:47 Re: Channel binding not supported using scram-sha-256 passwords Michael Paquier
08:12 Re: Plpythonu extension Adrian Klaver
09:09 Re: Plpythonu extension Vincent Predoehl
10:17 Barman disaster recovery solution Julie Nishimura
10:28 Re: Barman disaster recovery solution Achilleas Mantzios
11:18 Re: adding more space to the existing 9.6 cluster Thomas Boussekey
11:27 Re: adding more space to the existing 9.6 cluster Julie Nishimura
11:54 Re: Barman disaster recovery solution Andreas Kretschmer
15:11 Running from 9.6 backups sometimes fails with fatal error Sergey Burladyan
17:27 Re: Barman disaster recovery solution Edson Carlos Ericksson Richter
17:49 Re: adding more space to the existing 9.6 cluster Ron
17:53 Re: Barman disaster recovery solution Stephen Frost
22:30 Re: procedures and transactions Peter Eisentraut
22:32 Re: Channel binding not supported using scram-sha-256 passwords Peter Eisentraut
22:52 Re: Copy entire schema A to a different schema B Tiffany Thang
22:59 Hot_standby_feedback = on dangal
23:23 Re: Copy entire schema A to a different schema B Adrian Klaver

22 February 2019

00:07 Re: [GENERAL] Modified rows are not marked as dead and as such vacuumis unable to clean them up Tamás András Kálmán
01:24 Re: Connection string for Java to connect to PostgreSQL, usingclient certificates
02:09 Re: Copy entire schema A to a different schema B Melvin Davidson
05:00 Re: pg_stat_statements doesn't track commit from pl/pgsql blocks Bruce Momjian
05:07 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Bruce Momjian
05:31 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Stephen Frost
05:33 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Bruce Momjian
07:57 Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran
08:03 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Tom Lane
08:08 How many billion rows of data I can store in PostgreSQL RDS. github kran
08:14 Re: How many billion rows of data I can store in PostgreSQL RDS. Adrian Klaver
08:28 Re: Channel binding not supported using scram-sha-256 passwords Michael Paquier
08:30 Re: How many billion rows of data I can store in PostgreSQL RDS. Michael Paquier
10:53 RECURSIVE allowed only ONCE in a CTE Jitendra Loyal
13:06 Re: RECURSIVE allowed only ONCE in a CTE Andrew Gierth
13:23 Re: RECURSIVE allowed only ONCE in a CTE Jitendra Loyal
13:31 Re: RECURSIVE allowed only ONCE in a CTE mariusz
13:54 Re: RECURSIVE allowed only ONCE in a CTE Jitendra Loyal
14:46 Re: How many billion rows of data I can store in PostgreSQL RDS. Samuel Teixeira Santos
14:48 Re: How many billion rows of data I can store in PostgreSQL RDS. Samuel Teixeira Santos
15:46 Re: How many billion rows of data I can store in PostgreSQL RDS. github kran
16:29 Partition and Functions Leandro Guimarães
17:44 Update does not move row across foreign partitions in v11 Derek Hans
18:18 Re: How many billion rows of data I can store in PostgreSQL RDS. Adrian Klaver
19:46 streaming replication authentication Zachary Hanson-Hart
19:52 Re: PG Upgrade with hardlinks, when to start/stop master and replicas Martín Fernández
22:14 Re: Running from 9.6 backups sometimes fails with fatal error Sergey Burladyan
23:47 RE: pg_stat_statements doesn't track commit from pl/pgsql blocks legrand legrand

23 February 2019

00:00 Re: Copy entire schema A to a different schema B Tiffany Thang
00:46 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Thomas Munro
02:09 Re: streaming replication authentication Stephen Frost

24 February 2019

00:28 Foreign table & Connection reset by peer Lukáš Sobotka
00:48 Re: Foreign table & Connection reset by peer Adrian Klaver
03:29 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Bruce Klein
13:16 Re: WSL (windows subsystem on linux) users will need to turn fsyncoff as of 11.2 Thomas Munro
13:25 Re: Foreign table & Connection reset by peer Lukáš Sobotka
15:05 Future Non-server Windows support??? Bill Haught
15:08 Re: Size estimation of postgres core files Peter J. Holzer
19:09 Re: Future Non-server Windows support??? Tom Lane
20:18 Re: Future Non-server Windows support??? Adrian Klaver
20:46 Re: Foreign table & Connection reset by peer Adrian Klaver
21:38 Re: Future Non-server Windows support??? Jeff Janes
23:10 Re: Future Non-server Windows support??? Adrian Klaver

25 February 2019

00:04 Re: Future Non-server Windows support??? Jeff Janes
00:41 Re: Future Non-server Windows support??? Adrian Klaver
01:39 Recommended way to enable data-checksums on Centos 7? Ken Tanzer
03:09 Property Graph Query Language proposed for SQL:2020 Stefan Keller
04:03 Re: Recommended way to enable data-checksums on Centos 7? Adrian Klaver
09:52 Logical replication very slow Boris Sagadin
10:08 Re: Logical replication very slow Achilleas Mantzios
10:16 Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes Mike Yeap
10:59 Re: Logical replication very slow Boris Sagadin
11:05 Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes Thomas Munro
11:51 Re: Logical replication very slow Achilleas Mantzios
15:06 Re: Logical replication very slow Boris Sagadin
15:19 Re: Logical replication very slow Achilleas Mantzios
21:26 RE: BDR 1.0: background worker wants to start that should not be there Daniel Fink (PDF)
21:30 RE: bdr replication breaks down Daniel Fink (PDF)
21:42 update table with suppress_redundant_updates_trigger() wambacher@posteo.de
22:06 9.0 standby - could not open file global/XXXXX Filip Rembiałkowski
22:19 Re: Recommended way to enable data-checksums on Centos 7? Ken Tanzer

26 February 2019

00:35 Re: Recommended way to enable data-checksums on Centos 7? Adrian Klaver
00:41 Re: update table with suppress_redundant_updates_trigger() Adrian Klaver
01:05 Re: Recommended way to enable data-checksums on Centos 7? Ken Tanzer
01:15 Re: Recommended way to enable data-checksums on Centos 7? Adrian Klaver
01:45 Re: 9.0 standby - could not open file global/XXXXX Stephen Frost
01:59 PostgreSQL DB Maintenance and Partitioning to keep data longer. github kran
02:03 atomically replace partition of range partitioned table Kevin Wilkinson
04:39 Re: 9.0 standby - could not open file global/XXXXX Andres Freund
06:44 Re: atomically replace partition of range partitioned table David Rowley
10:17 Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes Mike Yeap
11:11 Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes Thomas Munro
12:10 Re: update table with suppress_redundant_updates_trigger() wambacher@posteo.de
12:37 Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes Mike Yeap
12:41 Replication Sonam Sharma
12:43 Re: 9.0 standby - could not open file global/XXXXX Filip Rembiałkowski
13:18 Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes Thomas Munro
13:59 Re: Replication Andreas Kretschmer
14:39 Re: Replication Filip Rembiałkowski
14:45 Re: 9.0 standby - could not open file global/XXXXX Filip Rembiałkowski
14:48 Re: Replication Steve Atkins
15:24 Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes Stephen Frost
17:16 Re: Channel binding not supported using scram-sha-256 passwords Peter Eisentraut
17:57 Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes Tom Lane
18:04 Re: Channel binding not supported using scram-sha-256 passwords Tom Lane

27 February 2019

00:32 Re: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes Thomas Munro
01:28 Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes Tom Lane
01:35 Re: Channel binding not supported using scram-sha-256 passwords Michael Paquier
01:40 replication topography Julie Nishimura
02:38 Re: replication topography Steve Crawford
02:56 Re: replication topography Adrian Klaver
04:51 crosstab function Martin Mueller
05:04 Re: crosstab function Adrian Klaver
05:07 Re: crosstab function Andrew Gierth
05:10 Re: crosstab function Martin Mueller
06:33 Re: crosstab function Adrian Klaver
07:42 Re: crosstab function Ron
07:52 Re: crosstab function Ron
12:21 Re: Channel binding not supported using scram-sha-256 passwords Peter Eisentraut
12:39 Re: Barman disaster recovery solution Achilleas Mantzios
13:11 Why can I not get lexemes for Hebrew but can get them for Armenian? Sam Saffron
14:21 why not using a mountpoint as PGDATA? Luca Ferrari
14:33 Re: why not using a mountpoint as PGDATA? Julien Rouhaud
14:52 Re: why not using a mountpoint as PGDATA? Luca Ferrari
15:31 Re: Barman disaster recovery solution Achilleas Mantzios
17:16 Re: Barman disaster recovery solution David Steele
17:43 cannot execute VACUUM during recovery github kran
17:48 Re: Barman disaster recovery solution Achilleas Mantzios
17:55 idle_in_transaction_session_timeout for a set of SQL statements Jeremy Finzel
18:01 Re: why not using a mountpoint as PGDATA? Peter J. Holzer
18:04 Re: Barman disaster recovery solution Edson Carlos Ericksson Richter
18:12 Re: Barman disaster recovery solution Achilleas Mantzios
18:19 Re: Barman disaster recovery solution Edson Carlos Ericksson Richter
18:42 Re: why not using a mountpoint as PGDATA? Tom Lane
18:51 Re: Why can I not get lexemes for Hebrew but can get them for Armenian? Tom Lane
19:00 Re: 9.0 standby - could not open file global/XXXXX Filip Rembiałkowski
19:44 Re: idle_in_transaction_session_timeout for a set of SQL statements Michael Lewis
19:49 Re: why not using a mountpoint as PGDATA? Peter J. Holzer
19:51 Re: idle_in_transaction_session_timeout for a set of SQL statements Jeremy Finzel
19:52 Re: Barman disaster recovery solution Mark Fletcher
20:16 Re: Barman disaster recovery solution David Steele
21:08 Optimizing Database High CPU Scottix
21:39 Re: cannot execute VACUUM during recovery Stephen Eilert
21:43 Re: why not using a mountpoint as PGDATA? Joe Conway
21:53 Re: Update does not move row across foreign partitions in v11 Derek Hans
21:59 Re: why not using a mountpoint as PGDATA? Ron
22:31 Re: Update does not move row across foreign partitions in v11 Alvaro Herrera
22:37 Re: why not using a mountpoint as PGDATA? Tom Lane
23:33 Re: Optimizing Database High CPU Jeff Janes

28 February 2019

00:15 automated refresh of dev from prod Julie Nishimura
00:37 RE: automated refresh of dev from prod Scot Kreienkamp
00:56 Re: automated refresh of dev from prod Ron
01:01 Re: Optimizing Database High CPU Michael Lewis
01:22 Re: replication topography Steve Crawford
01:41 Re: Optimizing Database High CPU Scottix
02:16 Re: why not using a mountpoint as PGDATA? raf@raf.org
03:41 Re: Channel binding not supported using scram-sha-256 passwords Michael Paquier
05:29 Re: cannot execute VACUUM during recovery Michael Paquier
07:32 create unique constraint on jsonb->filed during create table Andy Fan
07:47 Re: create unique constraint on jsonb->filed during create table David G. Johnston
10:08 Re: Barman disaster recovery solution Achilleas Mantzios
10:21 Re: Barman disaster recovery solution Achilleas Mantzios
10:47 Overloaded && operator from intarray module prevents index usage. Thomas Kellerer
11:40 Re: Barman disaster recovery solution David Steele
12:29 Re: Overloaded && operator from intarray module prevents index usage. Andrew Gierth
13:22 Re: Overloaded && operator from intarray module prevents index usage. Thomas Kellerer
14:02 Re: crosstab function Morris de Oryx
14:47 Where **not** to use PostgreSQL? Thomas Güttler
15:08 Re: Where **not** to use PostgreSQL? Pavel Stehule
15:24 Re: Where **not** to use PostgreSQL? Chris Travers
15:49 Re: Where **not** to use PostgreSQL? Nicolas Grilly
16:12 Re: Where **not** to use PostgreSQL? Chris Travers
16:27 Re: Where **not** to use PostgreSQL? Nicolas Grilly
16:59 Re: Where **not** to use PostgreSQL? Mark Moellering
17:55 Re: create unique constraint on jsonb->filed during create table Andy Fan
17:59 Pgbackrest Comparability issue chiru r
18:15 Re: Where **not** to use PostgreSQL? Ron
18:15 Re: Pgbackrest Comparability issue Adrian Klaver
18:47 Re: Where **not** to use PostgreSQL? Michel Pelletier
19:04 Re: automated refresh of dev from prod Stephen Frost
19:44 Re: Overloaded && operator from intarray module prevents index usage. Tom Lane
20:17 Re: Where **not** to use PostgreSQL? Raymond Brinzer
20:30 Re: Where **not** to use PostgreSQL? Michel Pelletier
21:06 Re: Pgbackrest Comparability issue chiru r
21:27 Re: Pgbackrest Comparability issue Adrian Klaver
22:10 specifying table in function args Rob Sargent
22:26 Re: automated refresh of dev from prod Ben Chobot
22:27 Re: specifying table in function args David G. Johnston
23:23 Re: Overloaded && operator from intarray module prevents index usage. Michael Lewis
23:23 Refresh Publication takes hours and doesn´t finish PegoraroF10
23:28 Re: Pgbackrest Comparability issue chiru r
23:38 Re: Overloaded && operator from intarray module prevents index usage. Thomas Kellerer
23:56 Re: specifying table in function args Rob Sargent