pgsql-general - September 2018

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

Sept. 1, 2018

Thread Author Time
Re: locate DB corruption Adrian Klaver 00:18
Re: using a plpgsql function argument as a table column. Shaun Savage 00:27
Re: using a plpgsql function argument as a table column. ss 00:28
Re: locate DB corruption Dave Peticolas 03:48
Rules and decision logic triggered by / acting on JSONB nodes in Postgres Amit Kothari 14:14
TR: redundant constraint_schema Olivier Leprêtre 15:50
Re: TR: redundant constraint_schema Andreas Kretschmer 16:27
Re: TR: redundant constraint_schema Adrian Klaver 16:41
Re: TR: redundant constraint_schema Adrian Klaver 16:44
Re: TR: redundant constraint_schema Andreas Kretschmer 16:47
RE: TR: redundant constraint_schema Olivier Leprêtre 16:47
Re: TR: redundant constraint_schema Adrian Klaver 16:52
Re: TR: redundant constraint_schema Andreas Kretschmer 17:00
RE: TR: redundant constraint_schema Olivier Leprêtre 17:13
Re: Rules and decision logic triggered by / acting on JSONB nodes in Postgres Guyren Howe 17:33
Re: very slow largeobject transfers through JDBC Dave Cramer 22:55
Re: locate DB corruption Dave Peticolas 23:45
error in vacuum Dave Peticolas 23:47
Re: error in vacuum Dave Peticolas 23:57

Sept. 2, 2018

Thread Author Time
Re: locate DB corruption Adrian Klaver 00:09
Re: error in vacuum Adrian Klaver 00:10
Re: error in vacuum Dave Peticolas 00:28
Re: locate DB corruption Dave Peticolas 00:53
Re: error in vacuum Dave Peticolas 01:31
Re: error in vacuum Tom Lane 01:56
Re: error in vacuum Dave Peticolas 02:02
Re: error in vacuum Andres Freund 02:24
Re: error in vacuum Dave Peticolas 02:40
pg_basebackup: could not receive data from WAL stream greigwise 04:06
Re: pg_basebackup: could not receive data from WAL stream greigwise 04:14
Re: locate DB corruption Stephen Frost 11:50
Re: pg_basebackup: could not receive data from WAL stream Adrian Klaver 13:41
Re: locate DB corruption Dave Peticolas 15:09
Re: pg_basebackup: could not receive data from WAL stream Kaixi Luo 21:32
WARNING: could not flush dirty data: Function not implemented Ravi Krishna 22:57
Re: WARNING: could not flush dirty data: Function not implemented Tom Lane 23:29
Re: WARNING: could not flush dirty data: Function not implemented Andres Freund 23:31

Sept. 3, 2018

Thread Author Time
dat names generated by pg_dump Ron 00:40
Re: dat names generated by pg_dump Adrian Klaver 01:41
Re: WARNING: could not flush dirty data: Function not implemented Ravi Krishna 02:05
Re: dat names generated by pg_dump Ron 02:07
Re: dat names generated by pg_dump Adrian Klaver 02:22
Re: dat names generated by pg_dump Tom Lane 02:26
Re: dat names generated by pg_dump Ron 02:47
Re: WARNING: could not flush dirty data: Function not implemented Andres Freund 03:04
Re: very slow largeobject transfers through JDBC Mate Varga 07:55
Re: very slow largeobject transfers through JDBC Dave Cramer 09:48
Re: very slow largeobject transfers through JDBC Mate Varga 09:52
Re: WARNING: could not flush dirty data: Function not implemented Ravi Krishna 11:59
Re: WARNING: could not flush dirty data: Function not implemented Tom Lane 13:33
Re: very slow largeobject transfers through JDBC Mate Varga 13:39
Re: WARNING: could not flush dirty data: Function not implemented Ravi Krishna 13:42
Re: very slow largeobject transfers through JDBC Dave Cramer 13:57
Re: WARNING: could not flush dirty data: Function not implemented Tom Lane 13:58
Re: very slow largeobject transfers through JDBC Mate Varga 14:38
Re: very slow largeobject transfers through JDBC Dave Cramer 14:40
Re: very slow largeobject transfers through JDBC Mate Varga 14:48
Re: very slow largeobject transfers through JDBC Dave Cramer 15:58
Re: timestamp arithmetics in C function Lutz Gehlen 16:11
Re: very slow largeobject transfers through JDBC Mate Varga 16:54
Re: very slow largeobject transfers through JDBC Mate Varga 16:59
Re: WARNING: could not flush dirty data: Function not implemented Dmitri Maziuk 17:32
Re: very slow largeobject transfers through JDBC Dave Cramer 17:35
Re: WARNING: could not flush dirty data: Function not implemented Austin Drenski 18:41
Re: WARNING: could not flush dirty data: Function not implemented Rob Sargent 19:19
Re: very slow largeobject transfers through JDBC Mate Varga 19:57
How to get shorter SERVER_VERSION in psql-prompt? Andreas Joseph Krogh 20:52
Re: How to get shorter SERVER_VERSION in psql-prompt? Alvaro Herrera 21:03
Re: How to get shorter SERVER_VERSION in psql-prompt? Christoph Moench-Tegeder 21:34
Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Andreas Joseph Krogh 21:39
Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Andreas Joseph Krogh 21:41
Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Alvaro Herrera 21:42
Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Rob Sargent 21:43
Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Christoph Moench-Tegeder 21:46
Sv: Re: Sv: Re: How to get shorter SERVER_VERSION in psql-prompt? Andreas Joseph Krogh 21:47
Re: WARNING: could not flush dirty data: Function not implemented Tim Cross 22:01
Re: WARNING: could not flush dirty data: Function not implemented Tim Cross 22:09

Sept. 4, 2018

Thread Author Time
Re: WARNING: could not flush dirty data: Function not implemented Michael Paquier 01:08
Re: Barman versus pgBackRest Ron 11:41
Re: Barman versus pgBackRest Thomas Poty 12:14
Re: Barman versus pgBackRest Ron 12:46
psqlODBC Kumar, Virendra 13:38
Re: Barman versus pgBackRest Thomas Poty 13:44
Re: psqlODBC Adrian Klaver 13:46
Re: Barman versus pgBackRest Ron 14:14
RE: psqlODBC Kumar, Virendra 14:18
Re: Barman versus pgBackRest Joshua D. Drake 14:24
Re: Barman versus pgBackRest Ron 14:52
increasing HA Thomas Poty 14:58
RE: increasing HA ROS Didier 15:09
Re: Barman versus pgBackRest Joshua D. Drake 15:24
Re: increasing HA Joshua D. Drake 15:25
Re: Barman versus pgBackRest Ron 15:51
Re: Barman versus pgBackRest David Steele 15:51
Re: Barman versus pgBackRest Ron 15:55
Re: Barman versus pgBackRest David Steele 16:00
Re: Barman versus pgBackRest Joshua D. Drake 16:01
Re: Barman versus pgBackRest David Steele 16:29
Re: Barman versus pgBackRest David Steele 16:33
PostgreSQL: Copy from File missing data error Holly Gibons 18:13
Re: PostgreSQL: Copy from File missing data error Ron 18:26
Re: PostgreSQL: Copy from File missing data error Dimitri Maziuk 18:46

Sept. 5, 2018

Thread Author Time
scram-sha-256 authentication broken in FIPS mode Alessandro Gherardi 03:29
Re: scram-sha-256 authentication broken in FIPS mode Michael Paquier 04:27
unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) Gunnlaugur Thor Briem 08:49
Re: increasing HA Jehan-Guillaume (ioguix) de Rorthais 09:38
Re: increasing HA Thomas Poty 11:23
Re: increasing HA Jehan-Guillaume (ioguix) de Rorthais 12:15
Re: increasing HA Thomas Poty 13:06
Re: scram-sha-256 authentication broken in FIPS mode Alessandro Gherardi 13:19
Re: increasing HA Jehan-Guillaume (ioguix) de Rorthais 13:44
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) Adrian Klaver 14:00
Re: increasing HA Thomas Poty 14:05
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) Gunnlaugur Thor Briem 14:06
Re: increasing HA Dmitri Maziuk 14:42
PostgreSQL intenal scheduler? Thiemo Kellner 15:06
Re: PostgreSQL intenal scheduler? Tim Clarke 15:09
Re: PostgreSQL intenal scheduler? Thomas Kellerer 15:31
Re: increasing HA Thomas Poty 15:45
Full table lock dropping a foreign key Paul Jungwirth 16:35
Re: increasing HA Dmitri Maziuk 16:39
Re: increasing HA Thomas Poty 17:04
Re: increasing HA Nicolas Karolak 17:05
Re: increasing HA Dimitri Maziuk 17:32
Max number of WAL files in pg_xlog directory for Postgres 9.2 version Raghavendra Rao J S V 17:39
RE: Max number of WAL files in pg_xlog directory for Postgres 9.2 version Johnes Castro 17:48
RE: Max number of WAL files in pg_xlog directory for Postgres 9.2 version Johnes Castro 17:53
Re: Full table lock dropping a foreign key Tom Lane 18:02
Re: Autovacuum degrades all other operations by keeping all buffers dirty? David Pacheco 18:06
Re: scram-sha-256 authentication broken in FIPS mode Michael Paquier 18:15
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) 📎 Tom Lane 19:03
Re: Max number of WAL files in pg_xlog directory for Postgres 9.2 version Ron 19:04
Re: Max number of WAL files in pg_xlog directory for Postgres 9.2 version Andreas Kretschmer 19:18
Re: PostgreSQL intenal scheduler? Thiemo Kellner 19:35
Re: PostgreSQL intenal scheduler? Ron 21:01
Re: PostgreSQL intenal scheduler? Thiemo Kellner 22:03
Re: PostgreSQL intenal scheduler? Thiemo Kellner 22:04
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) 📎 Tom Lane 22:37

Sept. 6, 2018

Thread Author Time
Re: PostgreSQL intenal scheduler? Jeremy Finzel 05:17
How to install pgAgent on windows for postresql-bigsql-10.5 jimmy 05:23
Re: Async replication: how to get an alert on failure pavan95 06:17
Re: PostgreSQL intenal scheduler? Thiemo Kellner 06:28
Re: very slow largeobject transfers through JDBC Mate Varga 07:46
Re: How to install pgAgent on windows for postresql-bigsql-10.5 Dave Page 07:57
Re:Re: How to install pgAgent on windows for postresql-bigsql-10.5 jimmy 08:41
Re: very slow largeobject transfers through JDBC Dave Cramer 08:55
Re: Re: How to install pgAgent on windows for postresql-bigsql-10.5 Dave Page 08:59
Re: very slow largeobject transfers through JDBC Mate Varga 09:03
Re: very slow largeobject transfers through JDBC Dave Cramer 09:04
Re: timestamp arithmetics in C function Adrian Klaver 13:27
Re: Re: How to install pgAgent on windows for postresql-bigsql-10.5 Adam Brusselback 15:57
nested query problem David Gauthier 20:59
Re: nested query problem Paul Jungwirth 21:10
Re: nested query problem Tom Lane 21:11
Re: nested query problem David Gauthier 21:15
Re: nested query problem David Gauthier 21:19
bad url in docs Rob Sargent 22:52
Re: bad url in docs Rob Sargent 22:57

Sept. 7, 2018

Thread Author Time
pgbackrest when data/base is symlinked to another volume Ron 06:21
Re: scram-sha-256 authentication broken in FIPS mode 📎 Alessandro Gherardi 06:27
Re:Re: Re: How to install pgAgent on windows for postresql-bigsql-10.5 jimmy 06:31
A Timeseries Case Study: InfluxDB VS PostgreSQL Fabio Pardi 08:07
Re: bad url in docs Arthur Zakirov 09:01
Re: A Timeseries Case Study: InfluxDB VS PostgreSQL Achilleas Mantzios 09:18
Re: A Timeseries Case Study: InfluxDB VS PostgreSQL Fabio Pardi 10:15
connection error Sonam Sharma 10:37
Re: A Timeseries Case Study: InfluxDB VS PostgreSQL Thomas Kellerer 10:58
Re: A Timeseries Case Study: InfluxDB VS PostgreSQL Benjamin Scherrey 11:08
Re: connection error amul sul 11:40
Re: connection error amul sul 11:45
Re: Re: Re: How to install pgAgent on windows for postresql-bigsql-10.5 Adam Brusselback 14:28
Re: A Timeseries Case Study: InfluxDB VS PostgreSQL Andrew Staller 19:08
Re: pgbackrest when data/base is symlinked to another volume David Steele 22:22
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) Bruce Momjian 22:32
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) Tom Lane 22:43
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) Bruce Momjian 22:56
Re: unaccent(text) fails depending on search_path (WAS: pg_upgrade fails saying function unaccent(text) doesn't exist) Tom Lane 23:05

Sept. 8, 2018

Thread Author Time
Re: pgbackrest when data/base is symlinked to another volume Ron 02:15
Re: pgbackrest when data/base is symlinked to another volume Ron 03:47
Re: pgbackrest when data/base is symlinked to another volume David Steele 20:07
Volume partitioning (was Re: pgbackrest when data/base is symlinked to another volume) Ron 20:26

Sept. 9, 2018

Thread Author Time
how to know current xlog location on standby after primary is down magodo 14:29
Conflict between recovery thread and client queries on a hot standby replica Kim Rose Carlsen 20:00
Conflict between recovery thread and client queries on a hot standby replica Kim Rose Carlsen 21:05

Sept. 10, 2018

Thread Author Time
RE: connection error Ahmed, Nawaz 04:19
Re: how to know current xlog location on standby after primary is down Michael Paquier 06:50
PG8.3->10 migration data differences Csaba Ragasits 08:22
Re: PG8.3->10 migration data differences Achilleas Mantzios 08:57
Re: PG8.3->10 migration data differences Peter J. Holzer 10:00
Why my query not doing index only scan Arup Rakshit 10:19
Re: Why my query not doing index only scan Stephen Frost 11:28
Re: Why my query not doing index only scan Arup Rakshit 11:53
Re: Why my query not doing index only scan Arup Rakshit 12:40
Re: Why my query not doing index only scan Stephen Frost 12:53
Re: Why my query not doing index only scan Laurenz Albe 13:12
Re: PG8.3->10 migration data differences Csaba Ragasits 13:43
Re: PG8.3->10 migration data differences Tom Lane 14:05
Re: PG8.3->10 migration data differences Adrian Klaver 14:09
Re: PG8.3->10 migration data differences Adrian Klaver 14:21
Re: Volume partitioning (was Re: pgbackrest when data/base is symlinked to another volume) David Steele 14:33

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