pgsql-general since 2019-02-27 00:00

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)

Browse Archives

Prev | Next

Feb. 27, 2019

Thread Author Time
crosstab function Martin Mueller 01:51
Re: crosstab function Adrian Klaver 02:04
Re: crosstab function Andrew Gierth 02:07
Re: crosstab function Martin Mueller 02:10
Re: crosstab function Adrian Klaver 03:33
Re: crosstab function Ron 04:42
Re: crosstab function Ron 04:52
Re: PostgreSQL DB Maintenance and Partitioning to keep data longer. github kran 05:51
Re: Channel binding not supported using scram-sha-256 passwords Peter Eisentraut 09:21
Re: Barman disaster recovery solution Achilleas Mantzios 09:39
Why can I not get lexemes for Hebrew but can get them for Armenian? Sam Saffron 10:11
why not using a mountpoint as PGDATA? Luca Ferrari 11:21
Re: why not using a mountpoint as PGDATA? Julien Rouhaud 11:33
Re: why not using a mountpoint as PGDATA? Luca Ferrari 11:52
Re: Barman disaster recovery solution Achilleas Mantzios 12:31
Re: Barman disaster recovery solution David Steele 14:16
cannot execute VACUUM during recovery github kran 14:43
Re: Barman disaster recovery solution Achilleas Mantzios 14:48
idle_in_transaction_session_timeout for a set of SQL statements Jeremy Finzel 14:55
Re: why not using a mountpoint as PGDATA? Peter J. Holzer 15:01
Re: Barman disaster recovery solution Edson Carlos Ericksson Richter 15:04
Re: Barman disaster recovery solution Achilleas Mantzios 15:12
Re: Barman disaster recovery solution Edson Carlos Ericksson Richter 15:19
Re: why not using a mountpoint as PGDATA? Tom Lane 15:42
Re: Why can I not get lexemes for Hebrew but can get them for Armenian? Tom Lane 15:51
Re: 9.0 standby - could not open file global/XXXXX Filip Rembiałkowski 16:00
Re: idle_in_transaction_session_timeout for a set of SQL statements Michael Lewis 16:44
Re: why not using a mountpoint as PGDATA? Peter J. Holzer 16:49
Re: idle_in_transaction_session_timeout for a set of SQL statements Jeremy Finzel 16:51
Re: Barman disaster recovery solution Mark Fletcher 16:52
Re: Barman disaster recovery solution David Steele 17:16
Re: query logging of prepared statements 📎 Justin Pryzby 18:06
Optimizing Database High CPU Scottix 18:08
Re: cannot execute VACUUM during recovery Stephen Eilert 18:39
Re: why not using a mountpoint as PGDATA? Joe Conway 18:43
Re: Update does not move row across foreign partitions in v11 Derek Hans 18:53
Re: why not using a mountpoint as PGDATA? Ron 18:59
Re: Update does not move row across foreign partitions in v11 Alvaro Herrera 19:31
Re: why not using a mountpoint as PGDATA? Tom Lane 19:37
Re: Optimizing Database High CPU Jeff Janes 20:33
automated refresh of dev from prod Julie Nishimura 21:15
RE: automated refresh of dev from prod Scot Kreienkamp 21:37
Re: automated refresh of dev from prod Ron 21:56
Re: Optimizing Database High CPU Michael Lewis 22:01
Re: replication topography Steve Crawford 22:22
Re: Optimizing Database High CPU Scottix 22:41
Re: why not using a mountpoint as PGDATA? raf 23:16

Feb. 28, 2019

Thread Author Time
Re: Channel binding not supported using scram-sha-256 passwords Michael Paquier 00:41
Re: cannot execute VACUUM during recovery Michael Paquier 02:29
create unique constraint on jsonb->filed during create table Andy Fan 04:32
Re: create unique constraint on jsonb->filed during create table David G. Johnston 04:47
Re: Barman disaster recovery solution Achilleas Mantzios 07:08
Re: Barman disaster recovery solution Achilleas Mantzios 07:21
Overloaded && operator from intarray module prevents index usage. Thomas Kellerer 07:47
Re: Barman disaster recovery solution David Steele 08:40
Re: Overloaded && operator from intarray module prevents index usage. Andrew Gierth 09:29
Re: Overloaded && operator from intarray module prevents index usage. Thomas Kellerer 10:22
Re: crosstab function Morris de Oryx 11:02
Where **not** to use PostgreSQL? Thomas Güttler 11:47
Re: Where **not** to use PostgreSQL? Pavel Stehule 12:08
Re: Where **not** to use PostgreSQL? Chris Travers 12:24
Re: Where **not** to use PostgreSQL? Nicolas Grilly 12:49
Re: Where **not** to use PostgreSQL? Chris Travers 13:12
Re: Where **not** to use PostgreSQL? Nicolas Grilly 13:27
Re: Where **not** to use PostgreSQL? Mark Moellering 13:59
Re: create unique constraint on jsonb->filed during create table Andy Fan 14:55
Pgbackrest Comparability issue chiru r 14:59
Re: Where **not** to use PostgreSQL? Ron 15:15
Re: Pgbackrest Comparability issue Adrian Klaver 15:15
Re: Where **not** to use PostgreSQL? Michel Pelletier 15:47
Re: automated refresh of dev from prod Stephen Frost 16:04
Re: Overloaded && operator from intarray module prevents index usage. Tom Lane 16:44
Re: Where **not** to use PostgreSQL? Raymond Brinzer 17:17
Re: Where **not** to use PostgreSQL? Michel Pelletier 17:30
Re: Pgbackrest Comparability issue chiru r 18:06
Question about pg_upgrade from 9.2 to X.X Perumal Raj 18:13
Re: Question about pg_upgrade from 9.2 to X.X Mahendra Singh 18:22
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 18:26
Re: Question about pg_upgrade from 9.2 to X.X Sergei Kornilov 18:27
Re: Pgbackrest Comparability issue Adrian Klaver 18:27
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 18:29
Re: Question about pg_upgrade from 9.2 to X.X Sergei Kornilov 19:04
specifying table in function args Rob Sargent 19:10
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 19:21
Re: automated refresh of dev from prod Ben Chobot 19:26
Re: specifying table in function args David G. Johnston 19:27
Re: Overloaded && operator from intarray module prevents index usage. Michael Lewis 20:23
Refresh Publication takes hours and doesn´t finish PegoraroF10 20:23
Re: Pgbackrest Comparability issue chiru r 20:28
Re: Overloaded && operator from intarray module prevents index usage. Thomas Kellerer 20:38
Re: specifying table in function args Rob Sargent 20:56
race condition when checking uniqueness between two tables Győző Papp 21:45
Re: specifying table in function args David G. Johnston 22:07
Re: Overloaded && operator from intarray module prevents index usage. Tom Lane 22:34
Re: race condition when checking uniqueness between two tables Tom Lane 22:50
Re: Overloaded && operator from intarray module prevents index usage. Michael Lewis 22:53
PostgreSQL (linux) configuration with GSSAPI to a Windows domain Jean-Philippe Chenel 22:53
Re: Pgbackrest Comparability issue Adrian Klaver 23:37
Re: Overloaded && operator from intarray module prevents index usage. Ron 23:57

March 1, 2019

Thread Author Time
Mind of its own? s400t 00:10
Re: Mind of its own? Ian Barwick 00:16
RE: Barman disaster recovery solution Ahmed, Nawaz 00:24
Re: Mind of its own? Tom Lane 00:24
Re: PostgreSQL (linux) configuration with GSSAPI to a Windows domain Andre Piwoni 01:19
Re: Overloaded && operator from intarray module prevents index usage. Michael Lewis 01:53
validation of hot standby Julie Nishimura 02:00
Re: Overloaded && operator from intarray module prevents index usage. Ron 02:19
Re: validation of hot standby Ron 02:22
Re: Overloaded && operator from intarray module prevents index usage. Michael Lewis 04:26
Re: Overloaded && operator from intarray module prevents index usage. Ron 04:56
Re: Overloaded && operator from intarray module prevents index usage. Michael Lewis 05:22
Pg_restore Nicola Contu 08:17
Re: Pg_restore Ron 08:38
Re: Pg_restore Nicola Contu 08:45
Re: Pgbackrest Comparability issue David Steele 09:31
Re: Overloaded && operator from intarray module prevents index usage. Andrew Gierth 09:32
Re: Barman disaster recovery solution David Steele 09:40
Thank you. Was: Where **not** to use PostgreSQL? Thomas Güttler Lists 13:54
Re: Where **not** to use PostgreSQL? Merlin Moncure 14:35
Performance comparison between Pgsql 10.5 and Pgsql 11.2 Nicola Contu 15:01
Re: Mind of its own? s400t 15:15
RE: PostgreSQL (linux) configuration with GSSAPI to a Windows domain Jean-Philippe Chenel 15:59
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 Ray O'Donnell 16:01
Re: PostgreSQL (linux) configuration with GSSAPI to a Windows domain Andre Piwoni 16:44
Re: PostgreSQL (linux) configuration with GSSAPI to a Windows domain Stephen Frost 16:54
Re: Future Non-server Windows support??? Bill Haught 19:11
Re: Methods to quickly spin up copies of an existing databases Kevin Wilkinson 19:57
Re: Methods to quickly spin up copies of an existing databases Kenneth Marshall 20:00
Methods to quickly spin up copies of an existing databases Arjun Ranade 20:08
Re: Future Non-server Windows support??? Adrian Klaver 20:28
RE: PostgreSQL (linux) configuration with GSSAPI to a Windows domain Jean-Philippe Chenel 20:46
RE: PostgreSQL (linux) configuration with GSSAPI to a Windows domain Jean-Philippe Chenel 20:52
Re: PostgreSQL (linux) configuration with GSSAPI to a Windows domain Stephen Frost 21:00
Re: Methods to quickly spin up copies of an existing databases Jerry Sievers 21:08
Re: Methods to quickly spin up copies of an existing databases Bruce Klein 21:28
Re: Methods to quickly spin up copies of an existing databases Arjun Ranade 21:51

March 2, 2019

Thread Author Time
how best to specify table constraints with "create table as <query>" Kevin Wilkinson 00:39
Re: Methods to quickly spin up copies of an existing databases Karsten Hilbert 13:16
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 14:23
Re: cannot execute VACUUM during recovery github kran 18:46
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 Thomas Munro 19:41
Re: Where **not** to use PostgreSQL? Steven Lembark 22:50

March 3, 2019

Thread Author Time
support for JSON Web Token Eugen Stan 00:08
regex DoS in postgresql? Stuart McGraw 04:11
Re: regex DoS in postgresql? Tom Lane 05:05
Re: Future Non-server Windows support??? Laurenz Albe 07:30
Re: Question about pg_upgrade from 9.2 to X.X Justin Pryzby 14:51
Re: Future Non-server Windows support??? George Neuner 16:44
FDW and remote cursor_tuple_fraction auxsvr 17:38
Re: FDW and remote cursor_tuple_fraction Jeff Janes 18:59
Re: support for JSON Web Token Michel Pelletier 20:18

March 4, 2019

Thread Author Time
Re: Future Non-server Windows support??? Michael Paquier 01:13
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 03:38
Re: Where **not** to use PostgreSQL? Thomas Kellerer 11:53
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 📎 Nicola Contu 12:13
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 Imre Samu 13:45
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 Nicola Contu 13:53
Re: Update does not move row across foreign partitions in v11 Derek Hans 14:00
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 Tom Lane 14:22
Re: query logging of prepared statements Arthur Zakirov 15:53
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 📎 Nicola Contu 16:01
Re: support for JSON Web Token Eugen Stan 16:42
Re: query logging of prepared statements 📎 Justin Pryzby 18:31
Re: Optimizing Database High CPU Jeff Janes 20:03
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 Thomas Munro 20:54
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 21:37
Re: Question about pg_upgrade from 9.2 to X.X Justin Pryzby 21:45
master-> 2 hot standbys Julie Nishimura 21:59
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 22:21
Re: Question about pg_upgrade from 9.2 to X.X Justin Pryzby 22:32

March 5, 2019

Thread Author Time
Re: master-> 2 hot standbys Ben Chobot 01:08
VACUUM FREEZE and replication lag Martín Fernández 01:53
Re: master-> 2 hot standbys Julie Nishimura 03:11
Re: Question about pg_upgrade from 9.2 to X.X Sergei Kornilov 07:42
Re: query logging of prepared statements Arthur Zakirov 10:30
Connection Drop from PostgreSQL Database Server Mohit Kumar Sahni 12:19
Slave server sometimes locks up Boris Sagadin 12:39
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 📎 Nicola Contu 15:22
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 16:09
LIMIT not showing all results Casey Deccio 16:10
Re: [External] LIMIT not showing all results Vijaykumar Jain 16:15
Re: Slave server sometimes locks up Thomas Munro 16:20
Re: [External] LIMIT not showing all results Casey Deccio 16:20
Re: Question about pg_upgrade from 9.2 to X.X Justin Pryzby 16:21
Re: [External] LIMIT not showing all results Tom Lane 16:46
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 Thomas Munro 16:47
Re: [External] LIMIT not showing all results Vijaykumar Jain 16:51
Re: [External] LIMIT not showing all results Andreas Kretschmer 17:37
Re: [External] LIMIT not showing all results Tom Lane 17:54
Re: [External] LIMIT not showing all results Andreas Kretschmer 18:06
Re: [External] LIMIT not showing all results Matthew Pounsett 18:09
Re: LIMIT not showing all results Casey Deccio 18:41
Re: [External] LIMIT not showing all results Andreas Kretschmer 18:43
Re: LIMIT not showing all results Andreas Kretschmer 18:44
Re: [External] LIMIT not showing all results Tom Lane 18:55
Server upgrade advice Rory Campbell-Lange 19:49
Re: Slave server sometimes locks up Boris Sagadin 20:21
Re: Server upgrade advice Kenneth Marshall 20:29
Re: Server upgrade advice Rory Campbell-Lange 21:07
Re: Server upgrade advice Kenneth Marshall 21:18

Browse Archives

Prev | Next