pgsql-general - August 2023

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

Aug. 1, 2023

Thread Author Time
Re: jsonb on-disk size calculation Junwang Zhao 03:58
How to build a new grammer for pg? 📎 jacktby 09:27
error: connection to server on socket... Amn Ojee Uw 10:22
Re: error: connection to server on socket... Amn Ojee Uw 10:25
Re: error: connection to server on socket... Tomas Pospisek 10:38
Re: PORT 5432 ERROR Tomas Pospisek 10:41
Re: error: connection to server on socket... pf 11:28
Re: error: connection to server on socket... Matthias Apitz 11:57
Re: error: connection to server on socket... Tom Lane 13:10
Re: PORT 5432 ERROR Adrian Klaver 14:33
Re: error: connection to server on socket... Adrian Klaver 14:35
Re:How to build a new grammer for pg? Wen Yi 14:45
PostgreSQL listens on localhost? Frank Gunseor 16:12
Re: PostgreSQL listens on localhost? Matthias Apitz 16:21
Re: PostgreSQL listens on localhost? Ron 16:22
Sample pg_hba.conf allows local users to access all databases William Edwards 17:13
Re: How to build a new grammer for pg? David G. Johnston 17:14
Re: Sample pg_hba.conf allows local users to access all databases Christophe Pettus 17:34
Re: Sample pg_hba.conf allows local users to access all databases David G. Johnston 17:35
Re: error: connection to server on socket... Amn Ojee Uw 18:42
Re: PostgreSQL listens on localhost? Adrian Klaver 18:42
Re: error: connection to server on socket... Adrian Klaver 18:55
Re: PostgreSQL listens on localhost? Frank Gunseor 19:24
Re: error: connection to server on socket... Amn Ojee Uw 22:40

Aug. 2, 2023

Thread Author Time
Re: Sample pg_hba.conf allows local users to access all databases William Edwards 08:08
Different releases in the same server marco.ptz 14:31
Re: Different releases in the same server Christoph Moench-Tegeder 14:57
Re: Different releases in the same server marco.ptz 15:27
Re: Different releases in the same server Ron 15:51

Aug. 3, 2023

Thread Author Time
question on auto_explain Karsten Hilbert 16:29
Re: question on auto_explain David G. Johnston 16:35
Aw: Re: question on auto_explain Karsten Hilbert 16:53
Runaway Initial Table Syncs in Logical Replication? Don Seiler 19:24
Aw: Re: question on auto_explain Karsten Hilbert 19:45
Re: Installation Issue Mark Atlantic 22:58

Aug. 4, 2023

Thread Author Time
role "my_account" does not exist Amn Ojee Uw 00:17
Re: role "my_account" does not exist David G. Johnston 00:20
Re: role "my_account" does not exist Adrian Klaver 00:22
Re: role "my_account" does not exist Amn Ojee Uw 01:13
RE: Runaway Initial Table Syncs in Logical Replication? Zhijie Hou (Fujitsu) 02:12
org.postgresql.util.PSQLException: ERROR: invalid XML content. Huge Input lookup Sai Teja 02:22
Re: org.postgresql.util.PSQLException: ERROR: invalid XML content. Huge Input lookup Ron 02:33
Re: org.postgresql.util.PSQLException: ERROR: invalid XML content. Huge Input lookup Sai Teja 03:46
PITR based recovery failing due to difference in max_connections Kalit Inani 04:47
Re: org.postgresql.util.PSQLException: ERROR: invalid XML content. Huge Input lookup Ron 04:53
Re: PITR based recovery failing due to difference in max_connections Ron 04:57
Re: question on auto_explain Julien Rouhaud 05:33
Re: question on auto_explain Frédéric Yhuel 07:28
Re: PITR based recovery failing due to difference in max_connections Kalit Inani 08:57
Re: question on auto_explain Karsten Hilbert 12:06
Re: Runaway Initial Table Syncs in Logical Replication? Don Seiler 14:28

Aug. 5, 2023

Thread Author Time
How does pg parse 'select '(1,2)'' jacktby jacktby 13:46
How to solve the warning? 📎 jacktby jacktby 14:08
Failed to parse new syntax jacktby jacktby 15:56
Re: Failed to parse new syntax Jan Wieck 18:18

Aug. 6, 2023

Thread Author Time
Re:How to solve the warning? Wen Yi 02:50
[Question] Can someone provide the explain of the relation between PGPROC and transaction? Wen Yi 02:54
/usr/local/pgsql is empty after successful of make 📎 Aramaki Zyake 16:00
Re: /usr/local/pgsql is empty after successful of make Julien Rouhaud 16:05
Re: /usr/local/pgsql is empty after successful of make Tom Lane 16:08
Re: /usr/local/pgsql is empty after successful of make Adrian Klaver 16:09
Re: /usr/local/pgsql is empty after successful of make Aramaki Zyake 16:14

Aug. 7, 2023

Thread Author Time
Re: How to solve the warning? Jeffrey Walton 00:47
Dropping all tables in a database H 01:17
Re: Dropping all tables in a database Christophe Pettus 01:24
Re: Dropping all tables in a database Julien Rouhaud 01:29
Re: Dropping all tables in a database David G. Johnston 01:31
Re: Dropping all tables in a database Thorsten Glaser 02:19
Backup Copy of a Production server. KK CHN 05:02
Re: Backup Copy of a Production server. Ron 05:19
My 1st TABLESPACE Amn Ojee Uw 05:43
Re: My 1st TABLESPACE negora 05:48
Re: Dropping all tables in a database Thomas Kellerer 05:50
Re: How does pg parse 'select '(1,2)'' Kyotaro Horiguchi 05:54
Re: Backup Copy of a Production server. KK CHN 12:05
Re: My 1st TABLESPACE Amn Ojee Uw 12:16
Re: Backup Copy of a Production server. Chris Travers 12:30
Re: Backup Copy of a Production server. Ron 13:17
DB Server slow down & hang during Peak hours of Usage 📎 KK CHN 13:41
Re: DB Server slow down & hang during Peak hours of Usage Ron 15:08

Aug. 8, 2023

Thread Author Time
Re: Dropping all tables in a database H 00:59
PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored Meera Nair 07:39
Re: My 1st TABLESPACE KK CHN 09:33
Re: DB Server slow down & hang during Peak hours of Usage Marc Millas 11:59
Re: DB Server slow down & hang during Peak hours of Usage Marc Millas 12:19
Re: DB Server slow down & hang during Peak hours of Usage KK CHN 12:51
Re: PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored Ron 13:30
Re: PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored Stephen Frost 14:18
ignore_system_indexes=on no help for missing/corrupt pg_class_oid_index? Jerry Sievers 22:47

Aug. 9, 2023

Thread Author Time
PgSQL 15.3: Execution plan not using index as expected 📎 Dürr Software 08:14
RE: PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored Meera Nair 10:19
PrepareStatement and parameters data types ihab sabiq 12:01
Re: PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored Stephen Frost 15:43
How to set default privilege for new users to have no access to other databases? Erik Nelson 18:35

Aug. 10, 2023

Thread Author Time
Query regarding certificate authentication in postgres Ashok Patil 05:11
Re: PgSQL 15.3: Execution plan not using index as expected Adrian Klaver 14:41
Re: How to set default privilege for new users to have no access to other databases? David G. Johnston 16:06
pb with big volumes Marc Millas 21:36

Aug. 11, 2023

Thread Author Time
Re: pb with big volumes Ron 01:09
Re: pb with big volumes Adam Scott 01:41
Re: pb with big volumes Ron 01:53
Re: pb with big volumes David Rowley 04:40
Re: pb with big volumes Marc Millas 10:17
Re: pb with big volumes Ron 14:27
Re: PgSQL 15.3: Execution plan not using index as expected Adrian Klaver 14:32

Aug. 12, 2023

Thread Author Time
Re: PgSQL 15.3: Execution plan not using index as expected rob stone 02:25
Re: How to set default privilege for new users to have no access to other databases? Peter J. Holzer 08:17
Re: PgSQL 15.3: Execution plan not using index as expected 📎 Dürr Software 09:01
Re: PgSQL 15.3: Execution plan not using index as expected 📎 Dürr Software 09:03
A Good Beginner's Book Amn Ojee Uw 13:02
Re: A Good Beginner's Book Amn Ojee Uw 13:04
Dynamically accessing columns from a row type in a trigger Rhys A.D. Stewart 20:09
Re: Dynamically accessing columns from a row type in a trigger Adrian Klaver 20:22
Re: Dynamically accessing columns from a row type in a trigger Adrian Klaver 20:31
Re: A Good Beginner's Book Miles Elam 22:22
Re: A Good Beginner's Book Anthony DeBarros 22:59

Aug. 13, 2023

Thread Author Time
Re: Dynamically accessing columns from a row type in a trigger Rhys A.D. Stewart 03:21
Re: Dynamically accessing columns from a row type in a trigger Adrian Klaver 04:28
Re: Dynamically accessing columns from a row type in a trigger David G. Johnston 04:34
Re: Dynamically accessing columns from a row type in a trigger jian he 04:53
Re: pb with big volumes Marc Millas 23:14
Re: pb with big volumes David Rowley 23:24

Aug. 14, 2023

Thread Author Time
Best strategy to perform individual incremental backups Mario Diangelo 09:51
Fatal Error : Invalid Memory alloc request size 1236252631 Sai Teja 09:59
Re: Fatal Error : Invalid Memory alloc request size 1236252631 Andreas Kretschmer 11:42
Re: Best strategy to perform individual incremental backups Stephen Frost 12:58
Query plan regression between CTE and views David Gilman 14:54
Re: Fatal Error : Invalid Memory alloc request size 1236252631 Sai Teja 15:29
Re: Query plan regression between CTE and views Ron 15:44
How to optimize PostgreSQL Row Security Policies that involve related tables? David Ventimiglia 16:36
Re: Fatal Error : Invalid Memory alloc request size 1236252631 Rob Sargent 17:25
Re: Fatal Error : Invalid Memory alloc request size 1236252631 Sai Teja 17:31
Re: How to optimize PostgreSQL Row Security Policies that involve related tables? David Ventimiglia 17:55
Re: Fatal Error : Invalid Memory alloc request size 1236252631 Ron 19:14

Aug. 15, 2023

Thread Author Time
Re: Dynamically accessing columns from a row type in a trigger Rhys A.D. Stewart 00:20
Re: Dynamically accessing columns from a row type in a trigger Rob Sargent 00:49
Re: Fatal Error : Invalid Memory alloc request size 1236252631 Sai Teja 02:40
Re: Fatal Error : Invalid Memory alloc request size 1236252631 Sai Teja 03:04
Re: Fatal Error : Invalid Memory alloc request size 1236252631 Tom Lane 03:23
PostgreSQL and local HDD Jason Long 07:23
Cast INTEGER to BIT confusion [Quipsy] Markus Karg 08:49
Re: PostgreSQL and local HDD Olivier Gautherot 09:24
Re: Cast INTEGER to BIT confusion Erik Wienhold 11:48
AW: Cast INTEGER to BIT confusion [Quipsy] Markus Karg 11:59
AW: Cast INTEGER to BIT confusion [Quipsy] Markus Karg 12:02
Re: Query plan regression between CTE and views David Gilman 12:59
Re: AW: Cast INTEGER to BIT confusion Erik Wienhold 14:27
Re: AW: Cast INTEGER to BIT confusion Erik Wienhold 14:27
Converting sql anywhere to postgres Russell Rose | Passfield Data Systems 15:04
PostgreSQL and GUI management Jason Long 15:08
AW: PostgreSQL and GUI management [Quipsy] Markus Karg 15:10
Re: PostgreSQL and GUI management Pavel Stehule 15:16
Re: PostgreSQL and GUI management Pavel Stehule 15:17
Re: PostgreSQL and GUI management Albrecht Dreß 15:23
Re: Converting sql anywhere to postgres Adrian Klaver 15:27
Re: Converting sql anywhere to postgres Erik Wienhold 16:05
Re: Converting sql anywhere to postgres Georg H. 16:43
Re: Converting sql anywhere to postgres Adrian Klaver 18:19
Re: AW: PostgreSQL and GUI management Jason Long 18:27
Re: Converting sql anywhere to postgres Russell Rose | Passfield Data Systems 18:30
Re: PostgreSQL and GUI management Adrian Klaver 18:38
Re: PostgreSQL and GUI management Rob Sargent 18:43
Re: PostgreSQL and GUI management Andreas Joseph Krogh 18:48
Re: PostgreSQL and GUI management Adrian Klaver 18:57
Re: PostgreSQL and GUI management Pavel Stehule 19:11
Re: PostgreSQL and GUI management Rob Sargent 20:52
Re: PostgreSQL and GUI management Adrian Klaver 21:46
Re: Converting sql anywhere to postgres Guyren Howe 21:52
Re: PostgreSQL and GUI management Andreas Joseph Krogh 23:03
Re: Converting sql anywhere to postgres Peter J. Holzer 23:43

Aug. 16, 2023

Thread Author Time
Re: Cast INTEGER to BIT confusion Greg Sabino Mullane 01:02
Re: PostgreSQL and local HDD Ron 03:39
Re: PostgreSQL and local HDD Ron 03:40
Re: PostgreSQL and local HDD Olivier Gautherot 04:48
Re: PostgreSQL and local HDD Ron 04:54
Re: PostgreSQL and local HDD Olivier Gautherot 06:12
Re: Converting sql anywhere to postgres Russell Rose | Passfield Data Systems 06:22
Re: PostgreSQL and local HDD Andreas Joseph Krogh 08:40
Re: A Good Beginner's Book Amn Ojee Uw 09:32
Creating a TABLESPACE Amn Ojee Uw 10:10
Re: Query regarding managing Replication Ashok Patil 10:18
Re: Creating a TABLESPACE Mateusz Henicz 10:43
Re: PostgreSQL and local HDD Ron 14:25
Re: Creating a TABLESPACE Ron 15:37
Re: Creating a TABLESPACE Amn Ojee Uw 17:24
Re: Creating a TABLESPACE Amn Ojee Uw 17:27
Re: Converting sql anywhere to postgres Guyren Howe 18:30
Re: Converting sql anywhere to postgres Rob Sargent 19:01
Re: Converting sql anywhere to postgres Adrian Klaver 19:35
Re: Creating a TABLESPACE Ron 20:24
Re: Creating a TABLESPACE Ray O'Donnell 20:29
Re: Converting sql anywhere to postgres Rob Sargent 21:16
Re: Converting sql anywhere to postgres Adrian Klaver 22:31

Aug. 17, 2023

Thread Author Time
AW: AW: Cast INTEGER to BIT confusion [Quipsy] Markus Karg 07:31
Why doesn't autovacuum/analyze run in due time after calling pg_stat_reset? rihad 09:01
Base files compatibility between PG11 and PG15 Abraham, Danny 09:32
Sv: Base files compatibility between PG11 and PG15 Andreas Joseph Krogh 10:10
Re: Cast INTEGER to BIT confusion rob stone 12:57
Re: Cast INTEGER to BIT confusion Erik Wienhold 13:14
Re: AW: AW: Cast INTEGER to BIT confusion Tom Lane 13:18

Browse Archives

Prev | Next