pgsql-general - November 2022

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

Nov. 1, 2022

Thread Author Time
Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Bryn Llewellyn 01:27
Delete a table automatic? 黄宁 01:44
Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Bryn Llewellyn 03:19
Re: Autovacuum on Partitioned Tables Ron 03:27
Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should David G. Johnston 03:36
Re: Autovacuum on Partitioned Tables Tom Lane 04:05
Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Bryn Llewellyn 04:43
Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn 05:03
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" David G. Johnston 05:48
Re: empty pg_stat_progress_vacuum Michael Paquier 06:01
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Laurenz Albe 06:48
Re: Autovacuum on Partitioned Tables Laurenz Albe 06:51
Re: Autovacuum on Partitioned Tables Ron 07:54
Re: PQconsumeinput() may close the fd 📎 Vasily Kulikov 08:09
Re: Delete a table automatic? jian he 09:31
Re: Delete a table automatic? Rob Sargent 13:41
Re: Delete a table automatic? Peter J. Holzer 14:16
Re: Delete a table automatic? Adrian Klaver 14:35
Re: Delete a table automatic? MuraliPD@GMail 15:11
Re: Autovacuum on Partitioned Tables Ryan Ruenroeng 15:11
Re: Delete a table automatic? Tom Lane 15:23
Re: Autovacuum on Partitioned Tables Ron 16:05
SSL/TLS encryption without Ron 16:13
Aw: Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Karsten Hilbert 16:15
Re: SSL/TLS encryption without Peter J. Holzer 17:55
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn 20:20
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" David G. Johnston 20:39
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" David G. Johnston 21:50
Re: Support logical replication of DDLs vignesh C 23:43

Nov. 2, 2022

Thread Author Time
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Adrian Klaver 00:40
Migrating postgres client(libpq) library from 12.10 to 14(Need some information) M Tarkeshwar Rao 04:11
Reducing bandwidth usage of database replication Sascha Zenglein 14:56
Re: Reducing bandwidth usage of database replication Ron 16:29
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn 22:31
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Adrian Klaver 23:39

Nov. 3, 2022

Thread Author Time
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" David G. Johnston 01:22
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" David G. Johnston 01:41
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Rob Sargent 03:26
unable to install postgreql 13.4 shashidhar Reddy 06:48
Re: unable to install postgreql 13.4 Julien Rouhaud 06:59
Re: unable to install postgreql 13.4 shashidhar Reddy 07:08
Re: unable to install postgreql 13.4 Julien Rouhaud 07:22
Re: unable to install postgreql 13.4 shashidhar Reddy 07:39
Re: Support logical replication of DDLs Peter Smith 07:40
AW: Reducing bandwidth usage of database replication Sascha Zenglein 08:40
Postgres to edb AS, need conversion? milist ujang 09:44
Would postgresql add a pg_sleep_backend() method lz ma 11:43
Re: Postgres to edb AS, need conversion? Abdul Sayeed 13:04
Re: unable to install postgreql 13.4 Ron 13:10
pg_restore error on function Post Gresql 14:28
Re: pg_restore error on function Adrian Klaver 14:43
Re: pg_restore error on function Ron 14:45
Re: pg_restore error on function Adrian Klaver 14:57
Re: Reducing bandwidth usage of database replication Ben Chobot 15:28
Re: pg_restore error on function Post Gresql 15:35
Re: pg_restore error on function Post Gresql 15:38
Re: pg_restore error on function David G. Johnston 15:52
Re: pg_restore error on function Adrian Klaver 16:01
Re: pg_restore error on function Tom Lane 16:32
Re: pg_restore error on function Ron 16:34
Some questions about Postgres Siddharth Jain 17:38
Re: Some questions about Postgres Christophe Pettus 17:42
Re: Some questions about Postgres Siddharth Jain 18:17
shutdown Postgres (standby) host causing timeout on other servers in replication Joanna Xu 20:55
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn 21:49
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn 21:49
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Adrian Klaver 22:37
Re: shutdown Postgres (standby) host causing timeout on other servers in replication Tom Lane 22:49
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Peter J. Holzer 23:01

Nov. 4, 2022

Thread Author Time
Re: shutdown Postgres (standby) host causing timeout on other servers in replication Ron 01:46
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Bryn Llewellyn 01:50
autovacuum hung on simple tables senor 02:50
Re: Postgres to edb AS, need conversion? milist ujang 04:12
Re: Postgres to edb AS, need conversion? Ron 04:41
Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all" Adrian Klaver 04:42
Unable to use pg_verify_checksums shashidhar Reddy 06:11
How to avoid intstantiating multiple JVM instances across different sessions to use FDW? ganggewang (王刚) 06:46
Re: Unable to use pg_verify_checksums Guillaume Lelarge 07:18
Re: autovacuum hung on simple tables Laurenz Albe 08:50
Re: Some questions about Postgres Laurenz Albe 08:55
Re: Reducing bandwidth usage of database replication Simon Riggs 09:16
Calculating average block write time Thomas Kellerer 09:19
Re: Reducing bandwidth usage of database replication Simon Riggs 09:20
AW: Reducing bandwidth usage of database replication Sascha Zenglein 09:25
Re: Support logical replication of DDLs vignesh C 09:36
Re: Unable to use pg_verify_checksums shashidhar Reddy 10:08
Setting up replication on Windows, v9.4 Brad White 22:59
Is there a guide to use PostgresSQL as alternative to MariaDB/MySQL in OpenStack? Larry Sevilla 23:14

Nov. 5, 2022

Thread Author Time
Re: Setting up replication on Windows, v9.4 Ian Lawrence Barwick 01:02
Re: Setting up replication on Windows, v9.4 Ian Lawrence Barwick 01:08
Re: Setting up replication on Windows, v9.4 Ron 04:55
Re: Is there a guide to use PostgresSQL as alternative to MariaDB/MySQL in OpenStack? Tony Shelver 06:50
Re: Postgres 15 upgrades and template1 public schema Bruno Wolff III 12:18
an difficult SQL Rafal Pietrak 15:10
Re: an difficult SQL Thiemo Kellner 18:05

Nov. 6, 2022

Thread Author Time
Re: Is there a guide to use PostgresSQL as alternative to MariaDB/MySQL in OpenStack? Larry Sevilla 07:30
server process (PID 2964738) was terminated by signal 11: Segmentation fault Stefan Froehlich 11:18
Re: an difficult SQL Rafal Pietrak 12:48
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Tom Lane 14:13
Re: an difficult SQL Erik Wienhold 14:23
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Stefan Froehlich 14:35
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Tom Lane 14:48
Re: an difficult SQL Rafal Pietrak 15:48
Re: Some questions about Postgres Siddharth Jain 19:05

Nov. 7, 2022

Thread Author Time
Re: AW: Reducing bandwidth usage of database replication Kyotaro Horiguchi 05:21
postgres replication without pg_basebackup? postgres 13.3 Pilar de Teodoro 10:02
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Stefan Froehlich 10:17
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Laurenz Albe 11:19
Re: postgres replication without pg_basebackup? postgres 13.3 Laurenz Albe 11:21
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Mladen Gogala 13:17
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Stefan Froehlich 13:47
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Tom Lane 14:02
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Stefan Froehlich 14:05
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Ron 14:40
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Tom Lane 15:43
Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault Ron 15:51
AW: AW: Reducing bandwidth usage of database replication Sascha Zenglein 16:16
copy file from a client app to remote postgres isntance Вадим Самохин 16:57
Re: copy file from a client app to remote postgres isntance Rob Sargent 17:29
Segmentation Fault PG 14 Willian Colognesi 17:33
Re: copy file from a client app to remote postgres isntance Вадим Самохин 17:51
Re: copy file from a client app to remote postgres isntance Rob Sargent 18:05
Re: Segmentation Fault PG 14 Tom Lane 18:08
My account was locked in pgadmin4 William Torrez Corea 18:14
Re: copy file from a client app to remote postgres isntance Adrian Klaver 18:24
Re: Segmentation Fault PG 14 Willian Colognesi 18:36
Re: Segmentation Fault PG 14 Adrian Klaver 18:49
Re: Segmentation Fault PG 14 Willian Colognesi 18:57
Re: Segmentation Fault PG 14 Adrian Klaver 19:00
Re: Segmentation Fault PG 14 Willian Colognesi 19:03
Re: Segmentation Fault PG 14 Adrian Klaver 19:36
Re: Segmentation Fault PG 14 Tom Lane 19:38
Re: Segmentation Fault PG 14 Willian Colognesi 20:15
Re: Segmentation Fault PG 14 Adrian Klaver 20:25
Re: Segmentation Fault PG 14 Willian Colognesi 20:29
Re: copy file from a client app to remote postgres isntance Ron 20:40
Re: Setting up replication on Windows, v9.4 Brad White 20:59
Re: Segmentation Fault PG 14 Tom Lane 21:09
Re: Setting up replication on Windows, v9.4 Rob Sargent 21:42
Feature suggestions for backup and replication da avory 22:03
Re: postgres replication without pg_basebackup? postgres 13.3 Pilar de Teodoro 22:11
Re: Segmentation Fault PG 14 Willian Colognesi 22:45
Re: Segmentation Fault PG 14 Tom Lane 23:05
Re: Segmentation Fault PG 14 Jeffrey Walton 23:47

Nov. 8, 2022

Thread Author Time
PCI:SSF - Safe SQL Query & operators filter Jan Bilek 01:24
Re: PCI:SSF - Safe SQL Query & operators filter Christophe Pettus 01:29
Re: PCI:SSF - Safe SQL Query & operators filter Jan Bilek 01:43
Re: PCI:SSF - Safe SQL Query & operators filter Christophe Pettus 01:50
Re: PCI:SSF - Safe SQL Query & operators filter David G. Johnston 01:51
Re: PCI:SSF - Safe SQL Query & operators filter Jeffrey Walton 02:06
Re: PCI:SSF - Safe SQL Query & operators filter Laurenz Albe 03:19
Re: postgres replication without pg_basebackup? postgres 13.3 Laurenz Albe 03:27
Re: Support logical replication of DDLs 📎 Ajin Cherian 04:03
Re: PCI:SSF - Safe SQL Query & operators filter Jan Bilek 04:14
Re: My account was locked in pgadmin4 Ashesh Vashi 04:15
Re: PCI:SSF - Safe SQL Query & operators filter Laurenz Albe 07:03
Re: Segmentation Fault PG 14 Thomas Munro 07:10
Re: PCI:SSF - Safe SQL Query & operators filter Jan Bilek 07:35
for integer/bigint type while format to scientific notation, automatically get the correct number of precision jian he 08:49
Information to CVE-2022-42889 Cedric Aaron Towstyka 10:50
Re: Segmentation Fault PG 14 Willian Colognesi 11:21
Re: Information to CVE-2022-42889 Erik Wienhold 11:27
Aw: Information to CVE-2022-42889 Karsten Hilbert 11:33
Re: Feature suggestions for backup and replication Ron 13:02
Q: pg_hba.conf separate database names file format Albrecht Dreß 13:16
Re: Information to CVE-2022-42889 Imre Samu 14:05
Re: Segmentation Fault PG 14 Willian Colognesi 16:40
Re: Segmentation Fault PG 14 Tom Lane 17:16

Nov. 9, 2022

Thread Author Time
"set role" semantics Bryn Llewellyn 00:16
Re: "set role" semantics David G. Johnston 00:24
Re: "set role" semantics Adrian Klaver 01:02
escaping double-quotes in varchar array David Gauthier 01:27
Re: escaping double-quotes in varchar array David G. Johnston 01:38
Re: Q: pg_hba.conf separate database names file format Michael Paquier 05:19
write an analyze_function for own type 黄宁 07:46
Re: Q: pg_hba.conf separate database names file format Ron 10:02
Unnecessary locks for partitioned tables n.kobzarev 11:11
Q: documentation improvement re collation version mismatch Karsten Hilbert 11:45
Re: Unnecessary locks for partitioned tables Laurenz Albe 13:14
RE: Unnecessary locks for partitioned tables n.kobzarev 13:40
Re: Unnecessary locks for partitioned tables Tom Lane 14:29
RE: Unnecessary locks for partitioned tables n.kobzarev 15:11
Re: copy file from a client app to remote postgres isntance Peter J. Holzer 16:15
Re: copy file from a client app to remote postgres isntance Peter J. Holzer 16:17
Re: Unnecessary locks for partitioned tables David Rowley 18:29
Re: "set role" semantics Bryn Llewellyn 18:55
Re: copy file from a client app to remote postgres isntance Ron 18:57
Re: "set role" semantics Guillaume Lelarge 19:22
Re: "set role" semantics David G. Johnston 19:22
Re: "set role" semantics Adrian Klaver 19:22
Re: "set role" semantics Adrian Klaver 19:27
Re: "set role" semantics David G. Johnston 19:29
Re: "set role" semantics Bryn Llewellyn 20:31
Re: "set role" semantics Adrian Klaver 20:53
Re: copy file from a client app to remote postgres isntance Peter J. Holzer 22:32
Re: "set role" semantics Bryn Llewellyn 23:23

Nov. 10, 2022

Thread Author Time
Re: Support logical replication of DDLs 📎 Ajin Cherian 04:04
Re: Q: pg_hba.conf separate database names file format Michael Paquier 04:23
List user databases Igor Korot 04:40
Re: List user databases Ian Lawrence Barwick 04:57

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