pgsql-general - March 2019

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

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
Re: [External] LIMIT not showing all results Casey Deccio 21:53
Re: [External] LIMIT not showing all results Matthew Pounsett 23:03
Re: [External] LIMIT not showing all results Tom Lane 23:09
Re: [External] LIMIT not showing all results Matthew Pounsett 23:18
write on standby Julie Nishimura 23:34
Re: [External] LIMIT not showing all results Tom Lane 23:36
Re: [External] LIMIT not showing all results Adrian Klaver 23:39
Re: write on standby Adrian Klaver 23:49
Re: [External] LIMIT not showing all results Matthew Pounsett 23:52

March 6, 2019

Thread Author Time
Non-pausing table scan on 9.6 replica? Mark Fletcher 00:26
Re: Connection Drop from PostgreSQL Database Server Adrian Klaver 00:49
How to make PAF use psql to login with password 范国腾 01:57
Re: Update does not move row across foreign partitions in v11 📎 David Rowley 02:06
Re: Update does not move row across foreign partitions in v11 Amit Langote 02:26
Re: Update does not move row across foreign partitions in v11 David Rowley 02:29
Re: Update does not move row across foreign partitions in v11 📎 Amit Langote 02:34
Re: Update does not move row across foreign partitions in v11 Etsuro Fujita 03:29
Re: Update does not move row across foreign partitions in v11 David Rowley 03:47
Re: Update does not move row across foreign partitions in v11 Etsuro Fujita 04:04
Re: Update does not move row across foreign partitions in v11 📎 Amit Langote 04:18
Re: Update does not move row across foreign partitions in v11 Amit Langote 04:20
Re: Update does not move row across foreign partitions in v11 David Rowley 04:30
Re: Update does not move row across foreign partitions in v11 Amit Langote 04:53
Re: How to make PAF use psql to login with password Adrian Klaver 05:06
Re: Connection Drop from PostgreSQL Database Server Adrian Klaver 05:09
Re: write on standby Andreas Kretschmer 05:16
Re: Non-pausing table scan on 9.6 replica? Andreas Kretschmer 05:20
Re: write on standby Julie Nishimura 05:26
Re: write on standby Andreas Kretschmer 05:32
Re: Non-pausing table scan on 9.6 replica? Mark Fletcher 05:41
Re: Non-pausing table scan on 9.6 replica? Andreas Kretschmer 05:47
Re: Non-pausing table scan on 9.6 replica? Sameer Kumar 05:56
Re: Update does not move row across foreign partitions in v11 Etsuro Fujita 06:10
Re: Update does not move row across foreign partitions in v11 Etsuro Fujita 06:16
Re: Update does not move row across foreign partitions in v11 📎 Amit Langote 06:34
query has no destination for result data Rob Sargent 07:45
how to restrict dba to access sensitive data Patrizio Bassi 09:45
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 📎 Nicola Contu 10:14
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 📎 Nicola Contu 11:12
Monitor the ddl and dml activities in logs Nanda Kumar 13:58
Re: query has no destination for result data Tom Lane 14:29
Re: query has no destination for result data Ron 14:32
Re: query has no destination for result data Rob Sargent 14:37
Re: query has no destination for result data Rob Sargent 15:12
Re: query has no destination for result data Adrian Klaver 15:15
Re: query has no destination for result data Adrian Klaver 15:27
Re: query has no destination for result data Pavel Stehule 15:37
Re: query has no destination for result data Adrian Klaver 15:41
Re: query has no destination for result data Rob Sargent 16:19
EXCLUDE USING hash(i WITH =) Erwin Brandstetter 18:00
Re: query has no destination for result data Adrian Klaver 18:29
Re: Monitor the ddl and dml activities in logs Ben Chobot 19:12
Re: Monitor the ddl and dml activities in logs Adrian Klaver 19:18
Re: query has no destination for result data Rob Sargent 19:20
Re: write on standby Adrian Klaver 21:12
Re: Non-pausing table scan on 9.6 replica? Mark Fletcher 21:15
Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes 📎 Thomas Munro 21:45

March 7, 2019

Thread Author Time
python install location Alan Nilsson 00:12
Re: python install location Adrian Klaver 00:23
Re: Non-pausing table scan on 9.6 replica? Sameer Kumar 02:51
Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes Noah Misch 03:19
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 Thomas Munro 03:25
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 Thomas Munro 03:46
Re: Question about pg_upgrade from 9.2 to X.X Perumal Raj 05:44
partial data migration Julie Nishimura 07:54
Re: partial data migration Ron 07:57
Re: Performance comparison between Pgsql 10.5 and Pgsql 11.2 Nicola Contu 08:39
Re: Question about pg_upgrade from 9.2 to X.X Justin Pryzby 10:32
Re: Update does not move row across foreign partitions in v11 Etsuro Fujita 12:35
Resolved: Question about pg_upgrade from 9.2 to X.X Perumal Raj 13:39
Re: Update does not move row across foreign partitions in v11 Robert Haas 13:54
Connection pooling for differing databases? Arjun Ranade 19:27
Re: Connection pooling for differing databases? Fabrízio de Royes Mello 19:35
Re: Connection pooling for differing databases? Moreno Andreo 19:39
Re: Future Non-server Windows support??? Bill Haught 19:41
Re: Connection pooling for differing databases? Jerry Sievers 20:03
Re: Connection pooling for differing databases? Arjun Ranade 20:19
Re: Future Non-server Windows support??? Thomas Kellerer 20:29
Re: Future Non-server Windows support??? Bill Haught 20:58
Re: python install location Peter Eisentraut 21:04
Re: Future Non-server Windows support??? Adrian Klaver 21:06
Re: Property Graph Query Language proposed for SQL:2020 Peter Eisentraut 21:06
Tools to migrate data from Json files to PostgreSQL DB. github kran 21:21
Re: Tools to migrate data from Json files to PostgreSQL DB. Adrian Klaver 21:44
Re: Future Non-server Windows support??? Ron 22:26

March 8, 2019

Thread Author Time
Re: Update does not move row across foreign partitions in v11 Amit Langote 00:36
Re: partial data migration Julie Nishimura 01:53
Re: partial data migration Ron 01:59
Re: Update does not move row across foreign partitions in v11 📎 Amit Langote 02:06
Re: partial data migration Julie Nishimura 02:11
Re: partial data migration Ron 03:48
Re: partial data migration Julie Nishimura 03:54
Re: Tools to migrate data from Json files to PostgreSQL DB. Pavel Stehule 04:12
Re: partial data migration Adrian Klaver 06:12
Re: Tools to migrate data from Json files to PostgreSQL DB. Tony Shelver 07:33
Re: Update does not move row across foreign partitions in v11 David Rowley 10:29
Re: Connection pooling for differing databases? 📎 Moreno Andreo 10:36
Re: Update does not move row across foreign partitions in v11 Etsuro Fujita 11:09
Re: Update does not move row across foreign partitions in v11 David Rowley 11:21

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