pgsql-general since 2022-10-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)
Advanced Search

Browse Archives

Prev | Next

Oct. 27, 2022

Thread Author Time
How to load data from CSV into a table that has array types in its columns? Siddharth Jain 00:30
Re: How to load data from CSV into a table that has array types in its columns? Adrian Klaver 00:59
Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Bryn Llewellyn 01:33
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all David G. Johnston 02:00
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Ian Lawrence Barwick 02:10
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Misty Peters (MistyLynn) 02:22
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Adrian Klaver 04:57
Re: PostgreSql Service different path chris navarroza 05:36
Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Kristjan Mustkivi 07:20
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Allan Kamau 07:26
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Allan Kamau 07:40
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Kristjan Mustkivi 07:55
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Peter J. Holzer 09:18
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Allan Kamau 09:29
Re: Support logical replication of DDLs 📎 vignesh C 10:32
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Kristjan Mustkivi 12:07
Re: Value Too long varchar(100) David G. Johnston 12:18
Re: Value Too long varchar(100) Stefan Knecht 12:48
EXPLAIN ANALYZE does not return accurate execution times Mark Mizzi 13:28
Re: EXPLAIN ANALYZE does not return accurate execution times Julien Rouhaud 13:35
Re: EXPLAIN ANALYZE does not return accurate execution times Tom Lane 13:43
Re: EXPLAIN ANALYZE does not return accurate execution times Mark Mizzi 14:12
Re: EXPLAIN ANALYZE does not return accurate execution times Tom Lane 14:45
Lock: Speculative token Ravi Krishna 14:51
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Ron 16:06
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Bryn Llewellyn 19:09
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Bryn Llewellyn 20:14
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Jeremy Smith 20:41
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all David G. Johnston 22:24
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Bryn Llewellyn 22:24
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all David G. Johnston 22:38
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all David G. Johnston 22:50
Re: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Tom Lane 23:02
Re: Support logical replication of DDLs Peter Smith 23:18
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Peter J. Holzer 23:41

Oct. 28, 2022

Thread Author Time
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Bryn Llewellyn 00:20
Re: Support logical replication of DDLs Zheng Li 00:20
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Bryn Llewellyn 00:24
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Bryn Llewellyn 00:28
Re: Support logical replication of DDLs Peter Smith 00:38
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Bryn Llewellyn 00:41
Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all Adrian Klaver 00:51
Re: Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all David G. Johnston 02:47
Re: Support logical replication of DDLs Peter Smith 06:50
ERROR: could not find pathkey item to sort Vijaykumar Sampat Jain 10:01
Re: ERROR: could not find pathkey item to sort Tom Lane 13:45
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Kristjan Mustkivi 14:23
Re: ERROR: could not find pathkey item to sort Vijaykumar Sampat Jain 14:29
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Peter J. Holzer 20:24

Oct. 29, 2022

Thread Author Time
"peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Bryn Llewellyn 00:26
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Jeremy Smith 01:09
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should David G. Johnston 02:28
how to install plprofiler shashidhar Reddy 06:43
Re: how to install plprofiler Pavel Stehule 07:11
Re: how to install plprofiler shashidhar Reddy 07:25
Re: how to install plprofiler shashidhar Reddy 07:27
Re: how to install plprofiler Pavel Stehule 07:28
Re: how to install plprofiler shashidhar Reddy 07:40
Re: Support logical replication of DDLs Alvaro Herrera 09:30
Upgrade error from version 12 to 23 shashidhar Reddy 10:38
access method xxx does not exist [email protected] 11:19
回复: access method xxx does not exist [email protected] 11:21
Error while upgrading from v12 to v13 shashidhar Reddy 11:39
Re: access method xxx does not exist Peter J. Holzer 12:00
Re: Re: access method xxx does not exist [email protected] 12:15
Re: access method xxx does not exist Julien Rouhaud 13:27
Re: Re: access method xxx does not exist [email protected] 13:43
Re: access method xxx does not exist Julien Rouhaud 14:06
Re: Error while upgrading from v12 to v13 shashidhar Reddy 14:08
Re: Error while upgrading from v12 to v13 Imre Samu 14:26
Re: Error while upgrading from v12 to v13 shashidhar Reddy 14:33
Does it equal to execute "CREATE ACCESS METHOD"? [email protected] 15:25
Re: Does it equal to execute "CREATE ACCESS METHOD"? [email protected] 15:34
Re: Does it equal to execute "CREATE ACCESS METHOD"? Tom Lane 15:34
Re: Re: Does it equal to execute "CREATE ACCESS METHOD"? [email protected] 15:39
Re: Re: Does it equal to execute "CREATE ACCESS METHOD"? [email protected] 15:45
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Adrian Klaver 17:14
How to add a variable to a timestamp. Eagna 17:35
Re: How to add a variable to a timestamp. Erik Wienhold 18:35
Re: How to add a variable to a timestamp. Adrian Klaver 20:10
Re: How to add a variable to a timestamp. Tom Lane 22:13

Oct. 30, 2022

Thread Author Time
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Bryn Llewellyn 03:20
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should David G. Johnston 03:38
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Adrian Klaver 04:15
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Peter J. Holzer 09:47
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Peter J. Holzer 09:50
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Peter J. Holzer 10:04
Re: Index corruption revealed after upgrade to 11.17, could date back to at least 11.12 Joe Conway 16:07
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Karsten Hilbert 16:11
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Karsten Hilbert 16:16
Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Adrian Klaver 16:22
Re: Unix users and groups... Was: "peer" authentication... Bryn Llewellyn 22:05

Oct. 31, 2022

Thread Author Time
there is no an example in reloptions.c for string? [email protected] 03:24
Re: there is no an example in reloptions.c for string? David G. Johnston 03:48
CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Bryn Llewellyn 04:01
Re: Support logical replication of DDLs Peter Smith 08:07
Re: Support logical replication of DDLs vignesh C 10:47
Off-topic? How to extract database statements from JPA? Gus Spier 10:50
Re: Off-topic? How to extract database statements from JPA? Erik Wienhold 12:19
Re: Off-topic? How to extract database statements from JPA? negora 12:27
Alfresco and postgres schemas Erika Knihti-Van Driessche 14:18
PGSQL Phriday #002: PostgreSQL Backup and Restore Andreas 'ads' Scherbaum 14:22
Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Adrian Klaver 16:22
Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Bryn Llewellyn 17:31
Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Adrian Klaver 18:03
Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should Peter J. Holzer 22:02
Autovacuum on Partitioned Tables Ryan Ruenroeng 22:26

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

Browse Archives

Prev | Next