pgsql-general - December 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)

Browse Archives

Prev | Next

Dec. 1, 2024

Thread Author Time
Re: Errors when restoring backup created by pg_dumpall PopeRigby 01:17
Re: Errors when restoring backup created by pg_dumpall David G. Johnston 01:27
Re: Errors when restoring backup created by pg_dumpall PopeRigby 02:11
Re: Errors when restoring backup created by pg_dumpall David G. Johnston 02:41
Re: Errors when restoring backup created by pg_dumpall PopeRigby 03:26
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 03:36
Re: Errors when restoring backup created by pg_dumpall PopeRigby 03:36
Re: Errors when restoring backup created by pg_dumpall Marco Torres 03:45
Re: Errors when restoring backup created by pg_dumpall David G. Johnston 03:45
Re: Errors when restoring backup created by pg_dumpall PopeRigby 03:47
Re: Errors when restoring backup created by pg_dumpall David G. Johnston 03:51
Re: Errors when restoring backup created by pg_dumpall Tom Lane 03:58
Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Alexander Farber 19:34
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Tom Lane 19:58
Re: Errors when restoring backup created by pg_dumpall PopeRigby 20:05
Re: Errors when restoring backup created by pg_dumpall Tom Lane 20:15
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Alexander Farber 20:36
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Alexander Farber 20:50
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Alexander Farber 20:59
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 21:08
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Tom Lane 21:09
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Adrian Klaver 21:12
Re: Errors when restoring backup created by pg_dumpall Tom Lane 21:14
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Peter Kleiner 21:21
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Alexander Farber 21:25
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 21:36
Re: Errors when restoring backup created by pg_dumpall Tom Lane 21:55

Dec. 2, 2024

Thread Author Time
Help with syntax error Arbol One 00:14
Re: Help with syntax error Adrian Klaver 00:17
Re: Help with syntax error Ron Johnson 00:18
Re: Help with syntax error Arbol One 00:21
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Alexander Farber 11:24
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Torsten Krah 11:31
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Alexander Farber 11:49
Re: Connection to 127.0.0.1 refused in a Dockerfile based on postgres:17-alpine3.20 Jeremy Smith 13:25
Unable to Recover a Deleted Database Using PITR Scott Taylor 20:12
Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Bharani SV-forum 22:18
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Adrian Klaver 22:25
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Ron Johnson 22:31
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Adrian Klaver 22:46
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Adrian Klaver 22:48
Re: Errors when restoring backup created by pg_dumpall PopeRigby 23:21
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Bharani SV-forum 23:41
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Adrian Klaver 23:46
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Bharani SV-forum 23:52

Dec. 3, 2024

Thread Author Time
VACUUM FULL, power failure results in unrecoverable space Pierre Barre 00:02
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Adrian Klaver 00:20
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Bharani SV-forum 00:25
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Peter J. Holzer 01:08
Re: Errors when restoring backup created by pg_dumpall Tom Lane 01:17
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Ron Johnson 01:23
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Adrian Klaver 05:28
Re: VACUUM FULL, power failure results in unrecoverable space Guillaume Lelarge 06:13
Autovacuum and visibility maps Tefft, Michael J 16:32
Re: Autovacuum and visibility maps Adrian Klaver 16:57
Best Practices for Managing Schema Changes Dynamically with libpq Sasmit Utkarsh 17:43
Re: Autovacuum and visibility maps Ron Johnson 17:57
Re: Best Practices for Managing Schema Changes Dynamically with libpq Ron Johnson 18:10
RE: Autovacuum and visibility maps Tefft, Michael J 18:11
Re: Autovacuum and visibility maps Ron Johnson 18:18
Forcing autocomplete on keypress Zac Warham 18:48
Re: Autovacuum and visibility maps Adrian Klaver 19:23
Re: Best Practices for Managing Schema Changes Dynamically with libpq Adrian Klaver 20:50

Dec. 4, 2024

Thread Author Time
Re: Using Expanded Objects other than Arrays from plpgsql 📎 Tom Lane 00:42
Re: Errors when restoring backup created by pg_dumpall PopeRigby 05:13
Qsn on Setting replication using " set session_replication_role = " Bharani SV-forum 12:20
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Bharani SV-forum 12:42
Clarification of behaviour when dropping partitions Bolaji Wahab 13:22
Re: Qsn on Setting replication using " set session_replication_role = " David G. Johnston 13:29
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Ron Johnson 14:49
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Greg Sabino Mullane 15:46
Seamless age (xid) replacement Ivan Shershnev 15:51
Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Adrian Klaver 17:04
Re: Clarification of behaviour when dropping partitions Laurenz Albe 17:20
Re: Clarification of behaviour when dropping partitions Bolaji Wahab 22:00

Dec. 5, 2024

Thread Author Time
Re: Clarification of behaviour when dropping partitions Laurenz Albe 01:38
Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo Gerhard Wiesinger 06:16
Re: Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo Christiano Anderson 07:43
Re: Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo Gerhard Wiesinger 18:20
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 20:34
Re: Errors when restoring backup created by pg_dumpall PopeRigby 22:32
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 22:48
Re: Errors when restoring backup created by pg_dumpall Ron Johnson 23:04
Re: Errors when restoring backup created by pg_dumpall David G. Johnston 23:23

Dec. 6, 2024

Thread Author Time
Re: Best Practices for Managing Schema Changes Dynamically with libpq Erik Wienhold 02:06
Re: Errors when restoring backup created by pg_dumpall Ron Johnson 02:44
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 03:48
Re: Errors when restoring backup created by pg_dumpall David G. Johnston 05:06
GRANT WITH INHERIT ?? Arbol One 12:40
Re: GRANT WITH INHERIT ?? Arbol One 12:53
Empty query_id in pg_stat_activity Costa Alexoglou 14:32
Re: Empty query_id in pg_stat_activity Erik Wienhold 15:44
tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed Zacher, Stacy 21:19
Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed Adrian Klaver 21:50
RE: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed Zacher, Stacy 22:10
Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed Adrian Klaver 22:26
Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed Adrian Klaver 23:34

Dec. 7, 2024

Thread Author Time
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 00:51
Insert records in the tavke only if they are not exist Igor Korot 03:36
Re: Insert records in the tavke only if they are not exist David G. Johnston 03:55
Re: Insert records in the tavke only if they are not exist Igor Korot 04:02
Re: Insert records in the tavke only if they are not exist Adrian Klaver 17:18
Re: Insert records in the tavke only if they are not exist Igor Korot 17:59
Re: Insert records in the tavke only if they are not exist Adrian Klaver 18:32
Re: Errors when restoring backup created by pg_dumpall PopeRigby 19:25
Re: Errors when restoring backup created by pg_dumpall David G. Johnston 19:58
Re: Insert records in the tavke only if they are not exist Igor Korot 20:17
Re: Insert records in the tavke only if they are not exist Adrian Klaver 23:07
Re: Insert records in the tavke only if they are not exist Igor Korot 23:58

Dec. 8, 2024

Thread Author Time
Re: Insert records in the tavke only if they are not exist Rob Sargent 00:23
Re: Insert records in the tavke only if they are not exist David G. Johnston 00:40
Re: Insert records in the tavke only if they are not exist Adrian Klaver 00:49
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 07:05

Dec. 9, 2024

Thread Author Time
Cancelled query due to buffer deadlock with recovery Will Storey 00:42
Re: Empty query_id in pg_stat_activity Michael Paquier 07:48
pg_upgrade vs. logical replication Joe Wildish 11:42
Re: pg_upgrade vs. logical replication Greg Sabino Mullane 13:06
RE: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed - RESOLVED Zacher, Stacy 17:03
Re: Errors when restoring backup created by pg_dumpall PopeRigby 22:14
Re: Errors when restoring backup created by pg_dumpall David G. Johnston 22:31
Re: Errors when restoring backup created by pg_dumpall PopeRigby 22:34
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 22:47
Re: Errors when restoring backup created by pg_dumpall PopeRigby 22:49
Re: Errors when restoring backup created by pg_dumpall Tom Lane 23:23
Re: Errors when restoring backup created by pg_dumpall PopeRigby 23:30

Dec. 10, 2024

Thread Author Time
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 00:07
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 00:31
Re: Errors when restoring backup created by pg_dumpall Ron Johnson 04:02
Re: Errors when restoring backup created by pg_dumpall David G. Johnston 04:24
Re: Errors when restoring backup created by pg_dumpall Ron Johnson 04:54
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 05:31
Formulating SQL queries via Retrieval Augmented Generation (RAG). Allan Kamau 12:59
Clusters and shared permissions using LDAP Felipe Matas 15:59

Dec. 11, 2024

Thread Author Time
Re: Errors when restoring backup created by pg_dumpall PopeRigby 03:05
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 05:22
Re: Clarification of behaviour when dropping partitions Bolaji Wahab 06:46
Credcheck- credcheck.max_auth_failure 張宸瑋 10:46
Re: Credcheck- credcheck.max_auth_failure Adrian Klaver 16:41
Re: Credcheck- credcheck.max_auth_failure Greg Sabino Mullane 17:57
Re: Credcheck- credcheck.max_auth_failure Ron Johnson 18:43
Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Bharani SV-forum 19:12
Re: Credcheck- credcheck.max_auth_failure Greg Sabino Mullane 20:00
Re: Credcheck- credcheck.max_auth_failure Adrian Klaver 20:11
Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Adrian Klaver 20:57

Dec. 12, 2024

Thread Author Time
Re: Empty query_id in pg_stat_activity Erik Wienhold 20:37

Dec. 13, 2024

Thread Author Time
Re: Errors when restoring backup created by pg_dumpall PopeRigby 06:19
Re: Errors when restoring backup created by pg_dumpall Adrian Klaver 16:46
Restoring database from backup Rich Shepard 18:21
Re: Restoring database from backup Adrian Klaver 18:31
Re: Restoring database from backup Rich Shepard 19:15
Re: Restoring database from backup Adrian Klaver 19:16
Re: Restoring database from backup Rich Shepard 19:18
Re: Restoring database from backup Rich Shepard 19:23
Re: Restoring database from backup Adrian Klaver 19:23
Subscriptions limit for 32cpus and 128gb Durgamahesh Manne 19:23
Re: Restoring database from backup Rich Shepard 19:26
Re: Credcheck- credcheck.max_auth_failure Peter J. Holzer 20:23
Re: Errors when restoring backup created by pg_dumpall PopeRigby 22:00

Dec. 14, 2024

Thread Author Time
Allowed to return possibly TOASTed datums? Jan Behrens 13:28
Re: Allowed to return possibly TOASTed datums? Tom Lane 17:01
Re: Allowed to return possibly TOASTed datums? Ron Johnson 18:13
Re: Allowed to return possibly TOASTed datums? Tom Lane 21:37

Dec. 15, 2024

Thread Author Time
Request for new column in pg_namespace Ron Johnson 16:58
Re: Request for new column in pg_namespace Pavel Stehule 17:15
Re: Request for new column in pg_namespace Tom Lane 17:29
Documentation enancement regarding NULL and operators 📎 Luca Dametto 17:35
Re: Request for new column in pg_namespace Isaac Morland 17:40
Continue Logical Replication After Master Became Slave and then Became Master Again Avi Weinberg 17:41
Re: Request for new column in pg_namespace Ron Johnson 17:46
Re: Request for new column in pg_namespace Tom Lane 19:20
Re: Request for new column in pg_namespace Isaac Morland 20:05

Dec. 16, 2024

Thread Author Time
Re: Request for new column in pg_namespace Ron Johnson 00:16
Re: Credcheck- credcheck.max_auth_failure 張宸瑋 10:32
Re: Credcheck- credcheck.max_auth_failure Peter J. Holzer 11:34
Re: Credcheck- credcheck.max_auth_failure Greg Sabino Mullane 13:09
Re: Credcheck- credcheck.max_auth_failure Ron Johnson 14:13
Re: Credcheck- credcheck.max_auth_failure Ron Johnson 14:17
Re: Credcheck- credcheck.max_auth_failure Peter J. Holzer 15:18
Re: Credcheck- credcheck.max_auth_failure Ron Johnson 15:37
How to do an update with XML column ? celati Laurent 16:07
Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Bharani SV-forum 21:19
Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Adrian Klaver 22:19
Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Bharani SV-forum 22:30
Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Adrian Klaver 22:49
Re: Additional Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X Bharani SV-forum 23:05

Dec. 17, 2024

Thread Author Time
Disabling vacuum truncate for autovacuum Will Storey 00:25
How to deal with dangling files after aborted `pg_restore`? Ivan Kurnosov 06:10
Re: Disabling vacuum truncate for autovacuum Laurenz Albe 07:30
Query about pg_wal directory filled up Rama Krishnan 13:41
Intermittent errors when fetching cursor rows on PostgreSQL 16 📎 Enrico Schenone 16:30
Re: Disabling vacuum truncate for autovacuum Will Storey 18:03
Re: Credcheck- credcheck.max_auth_failure Peter J. Holzer 18:39
Re: Credcheck- credcheck.max_auth_failure Ron Johnson 18:47

Dec. 18, 2024

Thread Author Time
PG16 ADMIN OPTION Pawan Sharma 11:52
Re: How to do an update with XML column ? Francisco Olarte 12:39
Re: Query about pg_wal directory filled up Laurenz Albe 14:28
Re: Documentation enancement regarding NULL and operators Laurenz Albe 14:32
Re: Intermittent errors when fetching cursor rows on PostgreSQL 16 Ron Johnson 15:11
Re: Documentation enancement regarding NULL and operators Adrian Klaver 16:11
Cannot drop column Rich Shepard 18:47

Browse Archives

Prev | Next