pgsql-general - June 2024

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

June 1, 2024

Thread	Author	Time
Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound	Ron Johnson	13:53
Proposing a PostgreSQL Independent Professionals Network	Chris Travers	16:02

June 3, 2024

Thread	Author	Time
Poor performance after restoring database from snapshot on AWS RDS	Sam Kidman	08:06
Postgresql 16.3 Out Of Memory	Radu Radutiu	10:19
Re: Postgresql 16.3 Out Of Memory	Greg Sabino Mullane	13:12
Re: Postgresql 16.3 Out Of Memory	Ron Johnson	13:32
Unexpected results from CALL and AUTOCOMMIT=off	Victor Yegorov	14:41
Re: Unexpected results from CALL and AUTOCOMMIT=off	Pierre Forstmann	17:40
Re: Unexpected results from CALL and AUTOCOMMIT=off	Victor Yegorov	18:15
Re: Unexpected results from CALL and AUTOCOMMIT=off	Tom Lane	19:28

June 4, 2024

Thread	Author	Time
Re: Unexpected results from CALL and AUTOCOMMIT=off 📎	Tom Lane	01:32
Purpose of pg_dump tar archive format?	Ron Johnson	12:13
Re: Purpose of pg_dump tar archive format?	Erik Wienhold	13:48
Re: Purpose of pg_dump tar archive format?	Adrian Klaver	14:43
Re: Purpose of pg_dump tar archive format?	Ron Johnson	15:25
Re: Purpose of pg_dump tar archive format?	Adrian Klaver	15:33
Re: Purpose of pg_dump tar archive format?	Tom Lane	16:53
Re: Purpose of pg_dump tar archive format?	Adrian Klaver	17:06
Re: Purpose of pg_dump tar archive format?	Shaheed Haque	17:40
Bugs details.	Muhammad Salahuddin Manzoor	17:55
Re: Bugs details.	Erik Wienhold	18:07
Re: Unexpected results from CALL and AUTOCOMMIT=off 📎	Tom Lane	18:28
Re: Purpose of pg_dump tar archive format?	Rob Sargent	18:55
Re: Purpose of pg_dump tar archive format?	Ron Johnson	19:15
Re: Purpose of pg_dump tar archive format?	Rob Sargent	19:37
Re: Purpose of pg_dump tar archive format?	Gavin Roy	19:47
Re: Unexpected results from CALL and AUTOCOMMIT=off	Nathan Bossart	20:13
Re: Unexpected results from CALL and AUTOCOMMIT=off	Tom Lane	20:31
Re: Purpose of pg_dump tar archive format?	Shaheed Haque	21:35
Questions on logical replication	Koen De Groote	22:55
Re: Questions on logical replication	Koen De Groote	23:02
Re: Questions on logical replication	Adrian Klaver	23:05
Re: Purpose of pg_dump tar archive format?	Ron Johnson	23:36

June 5, 2024

Thread	Author	Time
Re: Long running query causing XID limit breach	sud	06:25
Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir	Meera Nair	06:36
Re: Long running query causing XID limit breach	Simon Elbaz	07:08
Re: Long running query causing XID limit breach	sud	07:39
Re: Postgresql 16.3 Out Of Memory 📎	Radu Radutiu	08:16
Re: Poor performance after restoring database from snapshot on AWS RDS	Shammat	08:31
Variant (Untyped) parameter for function/procedure	Durumdara	08:34
Re: Unable to connect to any data source for foreign server	Russell Mercer	08:55
Re: Long running query causing XID limit breach	Laurenz Albe	10:22
Re: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir	Laurenz Albe	10:26
Re: Poor performance after restoring database from snapshot on AWS RDS	Jeremy Smith	12:09
Re: Purpose of pg_dump tar archive format?	Gavin Roy	14:22
Re: Variant (Untyped) parameter for function/procedure	Adrian Klaver	15:01
Length returns NULL ?	Marcos Pegoraro	17:50
Re: Length returns NULL ?	Erik Wienhold	19:07
Re: Long running query causing XID limit breach	yudhi s	19:21
how to tell if a pg version supports a linux distribution	bruno vieira da silva	20:24
Re: how to tell if a pg version supports a linux distribution	Adrian Klaver	20:31
Re: how to tell if a pg version supports a linux distribution	Adrian Klaver	20:35
Re: Questions on logical replication	Koen De Groote	21:54
Re: Questions on logical replication	Adrian Klaver	22:19

June 6, 2024

Thread	Author	Time
RE: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir	Meera Nair	01:52
Re: Poor performance after restoring database from snapshot on AWS RDS	Sam Kidman	04:40
Re: how to tell if a pg version supports a linux distribution	Laurenz Albe	08:41
Can't Remote connection by IpV6	Marcelo Marloch	14:46
Re: Can't Remote connection by IpV6	Kashif Zeeshan	14:58
Re: Can't Remote connection by IpV6	Adrian Klaver	15:03
Re: Can't Remote connection by IpV6	Ron Johnson	15:13
Re: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir	Ron Johnson	16:25
Oracle to Postgres - Transform Hash Partition	David Barbour	16:28
Tables get stuck at srsubstate = f	Avi Weinberg	16:38
Re: Oracle to Postgres - Transform Hash Partition	Christoph Moench-Tegeder	18:41
Re: Can't Remote connection by IpV6	Alan Hodgson	18:47
Re: Can't Remote connection by IpV6	Adrian Klaver	19:02
Re: Questions on logical replication	Koen De Groote	22:19

June 7, 2024

Thread	Author	Time
RE: Logical replication type- WAL recovery fails and changes the size of wal segment in archivedir	Meera Nair	01:45
PG 14 pg_basebackup accepts --compress=server-zst option	Ron Johnson	01:54
Re: Questions on logical replication	Kashif Zeeshan	04:20
Re: PG 14 pg_basebackup accepts --compress=server-zst option	Kashif Zeeshan	04:27
Re: PG 14 pg_basebackup accepts --compress=server-zst option	David G. Johnston	04:32
Re: Oracle to Postgres - Transform Hash Partition	Muhammad Ikram	05:40
Re: Oracle to Postgres - Transform Hash Partition	Laurenz Albe	08:31
PG16.1 security breach?	Zwettler Markus (OIZ)	11:04
Re: PG 14 pg_basebackup accepts --compress=server-zst option	Ron Johnson	12:04
Re: Poor performance after restoring database from snapshot on AWS RDS	Ron Johnson	12:13
Re: PG16.1 security breach?	Joe Conway	13:22
AW: [Extern] Re: PG16.1 security breach?	Zwettler Markus (OIZ)	13:54
Re: PG16.1 security breach?	David G. Johnston	14:16
Re: AW: [Extern] Re: PG16.1 security breach?	Laurenz Albe	14:32
Re: AW: [Extern] Re: PG16.1 security breach?	Adrian Klaver	14:35
PG16.1 security breach?	David G. Johnston	14:42
Re: Questions on logical replication	Adrian Klaver	15:15
Re: PG 14 pg_basebackup accepts --compress=server-zst option	Tom Lane	15:33

June 8, 2024

Thread	Author	Time
Creating big indexes	Lok P	07:23
Re: Long running query causing XID limit breach	sud	09:21
Question on pg_cron	yudhi s	09:31
How to create efficient index in this scenario?	veem v	13:33
Columnar Format Export in Postgres	Sushrut Shivaswamy	14:59
Re: Question on pg_cron	Ron Johnson	16:23
Re: Question on pg_cron	yudhi s	16:34
Re: Questions on logical replication	Koen De Groote	17:40
Re: Questions on logical replication	Adrian Klaver	17:46
Re: Questions on logical replication	Justin	20:33

June 9, 2024

Thread	Author	Time
Re: How to create efficient index in this scenario?	Lok P	04:15
Re: How to create efficient index in this scenario?	veem v	04:51
Re: Creating big indexes	sud	05:06
Re: Creating big indexes	Lok P	05:09
Re: Question on pg_cron	sud	06:27
Re: Creating big indexes	Lok P	08:09
Fwd: lost master password	Afa Jamal	21:46

June 10, 2024

Thread	Author	Time
Re: Fwd: lost master password	Laurenz Albe	09:06
Re: Fwd: lost master password	Afa Jamal	09:06
Re: lost master password	Kashif Zeeshan	09:13
Re: Fwd: lost master password	Laurenz Albe	09:16
Re: PG16.1 security breach?	Laurenz Albe	09:21
Question regarding automatically paused streaming replication	Ian van der Linde	11:39
Vacuum backend with backend_xmin?	Torsten Förtsch	12:06
Escaping single quotes with backslash seems not to work	Ron Johnson	14:02
Re: Escaping single quotes with backslash seems not to work	David G. Johnston	14:07
Re: Escaping single quotes with backslash seems not to work	David G. Johnston	14:12
libpq v17 PQsocketPoll timeout is not granular enough	Dominique Devienne	14:36
Re: Escaping single quotes with backslash seems not to work	Ron Johnson	14:52
Re: Escaping single quotes with backslash seems not to work	David G. Johnston	14:56
Re: Escaping single quotes with backslash seems not to work	Ron Johnson	14:59
Re: Escaping single quotes with backslash seems not to work	Tom Lane	15:08
Re: Escaping single quotes with backslash seems not to work	Ron Johnson	15:19
Re: Escaping single quotes with backslash seems not to work	Adrian Klaver	15:38
Re: Escaping single quotes with backslash seems not to work	David G. Johnston	15:42
Re: Vacuum backend with backend_xmin?	Laurenz Albe	16:16
Re: libpq v17 PQsocketPoll timeout is not granular enough	Tom Lane	16:18
Re: Escaping single quotes with backslash seems not to work	Ron Johnson	17:51
Re: libpq v17 PQsocketPoll timeout is not granular enough	Dominique Devienne	18:43
Multiple tables row insertions from single psql input file	Rich Shepard	18:50
Does trigger only accept functions?	veem v	19:17
Re: Multiple tables row insertions from single psql input file	Ron Johnson	19:42
Re: Multiple tables row insertions from single psql input file	Torsten Förtsch	20:02
Re: Multiple tables row insertions from single psql input file	Rich Shepard	20:06
Re: Multiple tables row insertions from single psql input file	Rich Shepard	20:11
Re: libpq v17 PQsocketPoll timeout is not granular enough	Adrian Klaver	20:13
Re: Does trigger only accept functions?	Adrian Klaver	20:20
Re: Multiple tables row insertions from single psql input file	Ron Johnson	20:25
Re: Escaping single quotes with backslash seems not to work	Adrian Klaver	20:52
Re: Multiple tables row insertions from single psql input file	David G. Johnston	21:15
Re: Multiple tables row insertions from single psql input file	Peter J. Holzer	21:27
Re: Multiple tables row insertions from single psql input file	Rich Shepard	21:58
Re: Multiple tables row insertions from single psql input file	David G. Johnston	22:00
Re: Multiple tables row insertions from single psql input file [RESOLVED]	Rich Shepard	22:35
Gaps in PK sequence numbers	Rich Shepard	22:57
Re: libpq v17 PQsocketPoll timeout is not granular enough	Thomas Munro	22:59
Re: Gaps in PK sequence numbers	David G. Johnston	23:03
Re: Gaps in PK sequence numbers	Christophe Pettus	23:05
Re: libpq v17 PQsocketPoll timeout is not granular enough	Tom Lane	23:49

June 11, 2024

Thread	Author	Time
Re: Gaps in PK sequence numbers [RESOLVED]	Rich Shepard	01:10
Re: Gaps in PK sequence numbers	Rich Shepard	01:13
Re: Gaps in PK sequence numbers [RESOLVED]	Christophe Pettus	01:21
Re: Gaps in PK sequence numbers [RESOLVED]	David G. Johnston	01:23
Re: Does trigger only accept functions?	Laurenz Albe	01:41
Re: Vacuum backend with backend_xmin?	Kashif Zeeshan	03:27
Re: Multiple tables row insertions from single psql input file	Ron Johnson	04:40
autoanalyze / autovacuum vs manually executed "vacuum analyze"	Shenavai, Manuel	06:55
Re: libpq v17 PQsocketPoll timeout is not granular enough	Francisco Olarte	07:19
Re: Does trigger only accept functions?	hubert depesz lubaczewski	11:33
Re: Gaps in PK sequence numbers [RESOLVED]	Rich Shepard	12:28
Unexpected Backend PID reported by Notification	Dominique Devienne	15:05
Re: Unexpected Backend PID reported by Notification	Adrian Klaver	15:21
Re: Unexpected Backend PID reported by Notification	David G. Johnston	15:29
Re: Creating big indexes	sud	18:22
Re: Does trigger only accept functions?	veem v	18:49
Re: Does trigger only accept functions?	hubert depesz lubaczewski	18:56
Re: Does trigger only accept functions?	veem v	19:20
Re: Does trigger only accept functions?	Adrian Klaver	19:46
Re: Does trigger only accept functions?	hubert depesz lubaczewski	19:58
DROP COLLATION vs pg_collation question	Karsten Hilbert	21:15
Re: Questions on logical replication	Koen De Groote	21:38
Re: Questions on logical replication	Koen De Groote	21:42
Re: Oracle to Postgres - Transform Hash Partition - Thanks!	David Barbour	22:11
Re: Does trigger only accept functions?	Ron Johnson	22:25

June 12, 2024

Thread	Author	Time
Re: Unexpected Backend PID reported by Notification	Dominique Devienne	06:53
Re: DROP COLLATION vs pg_collation question	Laurenz Albe	07:03
postgres table statistics	Chandy G	07:47
Re: postgres table statistics	Ron Johnson	08:27
Oracle Linux 9 Detected RPMs with RSA/SHA1 signature	Hans Schou	09:54
Re: Oracle Linux 9 Detected RPMs with RSA/SHA1 signature	Adrian Klaver	14:34
Re: postgres table statistics	Shammat	14:44
Question about UNIX socket connections and SSL	Casey & Gina	15:34
Re: Does trigger only accept functions?	Isaac Morland	16:40
Re: Questions on logical replication	Justin	17:01
Re: DROP COLLATION vs pg_collation question	Karsten Hilbert	19:13
Re: Question about UNIX socket connections and SSL	Tom Lane	19:17
Re: Question about UNIX socket connections and SSL	Daniel Gustafsson	19:32
Re: PG16.1 security breach?	David G. Johnston	20:35
Re: Question about UNIX socket connections and SSL	Casey & Gina	20:46
Definging columns for INSERT statements	Rich Shepard	21:11
UPDATE with multiple WHERE conditions	Rich Shepard	21:28
Re: UPDATE with multiple WHERE conditions	Muhammad Salahuddin Manzoor	21:31
Re: UPDATE with multiple WHERE conditions	Rich Shepard	21:34
Re: Defining columns for INSERT statements	Rich Shepard	21:36
Re: PG16.1 security breach?	Ron Johnson	21:37
Re: UPDATE with multiple WHERE conditions	Ron Johnson	21:48
Re: UPDATE with multiple WHERE conditions	Rob Sargent	22:05
Re: PG16.1 security breach?	David G. Johnston	22:08
Re: UPDATE with multiple WHERE conditions	David G. Johnston	22:09
Re: Definging columns for INSERT statements	David G. Johnston	22:12
Re: UPDATE with multiple WHERE conditions	Rich Shepard	22:41
Re: Definging columns for INSERT statements	Rich Shepard	22:43
Re: UPDATE with multiple WHERE conditions	Rich Shepard	22:46
Re: UPDATE with multiple WHERE conditions	Rich Shepard	22:47

Browse Archives

Prev | Next