pgsql-admin - February 2024

PostgreSQL administration (excludes pgAdmin application support, which can be found on the pgadmin-support list)

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

Feb. 1, 2024

Thread	Author	Time
Re: Enhancement Request	Ron Johnson	01:31
Re: Enhancement Request	Ron Johnson	01:35
Basebackup command	Rajesh Kumar	05:43
Re: Basebackup command	Dhanraj Acharya	06:00
Re: Basebackup command	David G. Johnston	06:10
Oracle to Postgres Migration	Kalyani Maity	10:50
Re: Oracle to Postgres Migration	Laurenz Albe	12:38
Re: Oracle to Postgres Migration	MichaelDBA	13:35
Oracle to Postgres Migration	Wetmore, Matthew (CTR)	15:52
Re: Oracle to Postgres Migration	M Sarwar	16:03
Re: Oracle to Postgres Migration	M Sarwar	16:32
Re: Oracle to Postgres Migration	M Sarwar	16:59
Enforcing Initial Password Setup for New Users	Sudeep Dass	19:02
Re: Enforcing Initial Password Setup for New Users	Willian Colognesi	19:08
Postgres alerting tools?	Ron Watkins	20:03
Re: Postgres alerting tools?	Krishna B	20:11
RE: Postgres alerting tools?	jwiencek3	20:44
Re: Postgres alerting tools?	Servet Kahraman Turan	20:48

Feb. 2, 2024

Thread	Author	Time
Re: Enhancement Request	M Sarwar	01:50
Re: Enhancement Request	David G. Johnston	02:15
Re: Postgres alerting tools?	Gabriel Guillem Barceló Soteras	07:10
Re: Enhancement Request	Olivier Gautherot	08:50
RE: Postgres alerting tools?	Bernd Lentes	09:31
Postgres 16 slow "fast" shutdown when using streaming replication	Stefan Kohlhauser	11:25
Re: Enhancement Request	Ron Johnson	13:54
Re: Enhancement Request	M Sarwar	14:10
Re: Enhancement Request	Olivier Gautherot	15:02
Function is giving execution error from inside the procedure	M Sarwar	15:04
Re: Function is giving execution error from inside the procedure	David G. Johnston	15:30
Re: Function is giving execution error from inside the procedure	M Sarwar	15:53
Re: Enhancement Request	Ron Johnson	17:15
PgAdmin 4 tool - Filter and Limit selector greyed out	Ravindranathan Rinilnath (Ext. - UniCredit)	17:53
Could not read pg_multixact/offsets on	still Learner	19:17

Feb. 3, 2024

Thread	Author	Time
Re: Pam NIS authentication	Samed YILDIRIM	20:38

Feb. 4, 2024

Thread	Author	Time
repmgr auto-failover not happening.	jacob ndinkwa	11:41
Re: repmgr auto-failover not happening.	Nikhil Shetty	13:11
Re: repmgr auto-failover not happening.	jacob ndinkwa	22:06
Re: Could not read pg_multixact/offsets on	Ron Johnson	23:11

Feb. 5, 2024

Thread	Author	Time
Re: repmgr auto-failover not happening.	Nikhil Shetty	05:35
Re: repmgr auto-failover not happening.	jacob ndinkwa	11:40

Feb. 6, 2024

Thread	Author	Time
psql du command	Heckler, Kim M	15:34
Re: psql du command	Erik Wienhold	16:19
Re: psql du command	David G. Johnston	16:46

Feb. 7, 2024

Thread	Author	Time
How to output psql to file AND screen/console	Edwin UY	09:16
Re: How to output psql to file AND screen/console	Erik Wienhold	10:11
Re: How to output psql to file AND screen/console	Edwin UY	10:39
Re: How to output psql to file AND screen/console	Erik Wienhold	12:52
Re: How to output psql to file AND screen/console	Edwin UY	19:13
Re: How to output psql to file AND screen/console	Erik Wienhold	20:46

Feb. 8, 2024

Thread	Author	Time
Re: How to output psql to file AND screen/console	Edwin UY	00:39
Need help to implement Primary Key.	Gambhir Singh	10:30
Re: Need help to implement Primary Key.	Thomas Kellerer	10:37
Re: Need help to implement Primary Key.	Holger Jakobs	11:25
pg_basebackup --wal-method=fetch	Ron Johnson	16:05
Re: pg_basebackup --wal-method=fetch	Magnus Hagander	17:48
Re: pg_basebackup --wal-method=fetch	Ron Johnson	17:54
DDL - TYPES	Gambhir Singh	19:14
Re: DDL - TYPES	Laurenz Albe	20:02
Re: DDL - TYPES	Ron Johnson	21:03
Re: pg_basebackup --wal-method=fetch	Stephen Frost	21:41
Re: pg_basebackup --wal-method=fetch	Ron Johnson	22:06
Re: DDL - TYPES	Laurenz Albe	22:21
Re: pg_basebackup --wal-method=fetch	Stephen Frost	22:21
Re: DDL - TYPES	Tom Lane	22:32
Re: pg_basebackup --wal-method=fetch	Ron Johnson	23:10

Feb. 9, 2024

Thread	Author	Time
Re: pg_basebackup --wal-method=fetch	Magnus Hagander	14:19
upgrade questions	David Barron	17:00
Re: upgrade questions	Scott Ribe	17:07
RE: upgrade questions	Wetmore, Matthew (CTR)	17:12
Re: upgrade questions	Holger Jakobs	17:41
Re: upgrade questions	Ron Johnson	17:43
RE: upgrade questions	David Barron	18:09
RE: upgrade questions	David Barron	18:10
Re: upgrade questions	Laurenz Albe	18:23
Use AD-account as login into Postgres.	Pär Mattsson	18:31
RE: upgrade questions	David Barron	19:01
Re: Use AD-account as login into Postgres.	Holger Jakobs	19:05
Re: Use AD-account as login into Postgres.	Pär Mattsson	19:31
Re: Use AD-account as login into Postgres.	Holger Jakobs	19:34
Re: upgrade questions	Ed Sabol	19:49
Re: Use AD-account as login into Postgres.	Pär Mattsson	19:59

Feb. 10, 2024

Thread	Author	Time
Temp table + inde + FDW table on Redshift: MOVE BACKWARD ALL IN not supported	Wells Oliver	23:35

Feb. 11, 2024

Thread	Author	Time
Re: Temp table + inde + FDW table on Redshift: MOVE BACKWARD ALL IN not supported	Tom Lane	00:20

Feb. 12, 2024

Thread	Author	Time
pg_dump --binary-upgrade out of memory	Антон Глушаков	15:36

Feb. 13, 2024

Thread	Author	Time
migrating data from non-partitioned table to partitioned table in Aurora Postgresql	hellen jiang	15:44
Re: migrating data from non-partitioned table to partitioned table in Aurora Postgresql	Ron Johnson	16:15
Postgres upgrade from 9.6.9 to postgresql 16 version	Krishnaswamy	16:22
Re: Postgres upgrade from 9.6.9 to postgresql 16 version	Chris Hoover	16:27
Re: Postgres upgrade from 9.6.9 to postgresql 16 version	Ron Johnson	17:26
Re: pg_dump --binary-upgrade out of memory	Tom Lane	18:30
pg_restore error	M Sarwar	20:08
RE: pg_restore error	M Sarwar	20:27

Feb. 14, 2024

Thread	Author	Time
AW: pg_dump --binary-upgrade out of memory	Dischner, Anton	07:11
Re: pg_dump --binary-upgrade out of memory	Антон Глушаков	11:26

Feb. 15, 2024

Thread	Author	Time
Regarding cve-2024-0985	Rakesh Nashine	10:23
Re: Regarding cve-2024-0985	Michael Banck	10:40
Re: Regarding cve-2024-0985	Ron Johnson	14:27
Re: Regarding cve-2024-0985	Rakesh Nashine	14:46
Re: Regarding cve-2024-0985	David G. Johnston	15:14
Re: Regarding cve-2024-0985	Ron Johnson	20:13

Feb. 16, 2024

Thread	Author	Time
Re: Postgres upgrade from 9.6.9 to postgresql 16 version	Krishnaswamy	07:57
Re: Postgres upgrade from 9.6.9 to postgresql 16 version	Laurenz Albe	12:33

Feb. 17, 2024

Thread	Author	Time
pg_hba.conf settings for postgres	Teju Jakkidi vlogs	20:33
Re: pg_hba.conf settings for postgres	Tom Lane	20:40

Feb. 18, 2024

Thread	Author	Time
Re: pg_hba.conf settings for postgres	andrew burns	02:17
Backup and Recovery related	SathishKumar R	19:18

Feb. 19, 2024

Thread	Author	Time
Full backup failed	Rajesh Kumar	04:05
Re: Full backup failed	Don Seiler	05:05
Re: Full backup failed	Laurenz Albe	07:23
Re: Full backup failed	Rajesh Kumar	07:43
Re: Full backup failed	Michael Banck	07:50
Re: Full backup failed	Amitpal Singh	14:27

Feb. 20, 2024

Thread	Author	Time
Wraparound	Rajesh Kumar	04:32
Re: Wraparound	Laurenz Albe	07:23
Re: Wraparound	Rajesh Kumar	07:27
Re: Wraparound	Michael Banck	07:40
Re: Wraparound	Laurenz Albe	07:42
pg_restore option --clean	Fabrice Chapuis	07:47
select statements have many shared_blks_dirtied and written	James Pang	08:20
Re: select statements have many shared_blks_dirtied and written	Laurenz Albe	08:34

Feb. 21, 2024

Thread	Author	Time
Re: Wraparound	Rajesh Kumar	03:37
Re: Wraparound	Vijaykumar Jain	08:25
Fwd: pg_restore option --clean	Fabrice Chapuis	09:17
Re: pg_restore option --clean	M Sarwar	11:47
Re: pg_restore option --clean	Fabrice Chapuis	14:00
Re: pg_restore option --clean	Guillaume Lelarge	14:35
Re: pg_restore option --clean	Tom Lane	15:31
Modify Bootstrap user ID	Nikhil Shetty	18:17
Re: Modify Bootstrap user ID	Tom Lane	18:39

Feb. 22, 2024

Thread	Author	Time
Re: Wraparound	Rajesh Kumar	04:46
Re: Wraparound	Laurenz Albe	06:52
Re: pg_restore option --clean	Fabrice Chapuis	08:05
\set to create shortcut	Fabrice Chapuis	08:32
Problems installing APT version	Ulf Bengtner	08:43
Re: \set to create shortcut	Laurenz Albe	08:45
Re: \set to create shortcut	Erik Wienhold	09:32
Re: \set to create shortcut	Fabrice Chapuis	11:19
print cached SQL plans of a backend	James Pang	12:33
Re: print cached SQL plans of a backend	srinivasan s	13:13
Re: Modify Bootstrap user ID	Nikhil Shetty	13:31
Re: Modify Bootstrap user ID	Nikhil Shetty	13:34
Connections spike	Rajesh Kumar	13:43
Re: Use AD-account as login into Postgres.	Stephen Frost	17:48
Re: Backup and Recovery related	Stephen Frost	17:50
Another way to do audit in DML operations in PostgreSQL >= 14	Lucio Chiessi	19:14
Re: Connections spike	Lucio Chiessi	19:25
Would you ever recommend Shared Disk Failover for HA?	norbert poellmann	19:34
Re: Problems installing APT version	Michael Banck	19:39
Re: Would you ever recommend Shared Disk Failover for HA?	Ron Johnson	19:49
Re: Another way to do audit in DML operations in PostgreSQL >= 14	Bruce Momjian	23:36

Feb. 23, 2024

Thread	Author	Time
Postgres Table column translation	Ravindranathan Rinilnath (Ext. - UniCredit)	02:04
Re: Another way to do audit in DML operations in PostgreSQL >= 14	S Hoffman	04:54
Re: Would you ever recommend Shared Disk Failover for HA?	Laurenz Albe	07:02
Re: Would you ever recommend Shared Disk Failover for HA?	Ron Johnson	07:21
Re: Would you ever recommend Shared Disk Failover for HA?	vignesh kumar	07:38
Re: Use AD-account as login into Postgres.	Gabriel Guillem Barceló Soteras	08:02
Re: Would you ever recommend Shared Disk Failover for HA?	Laurenz Albe	09:08
Re: print cached SQL plans of a backend	Julien Rouhaud	12:44
Two different database in RDS access table.	qazi saif hussain	13:50
Re: Two different database in RDS access table.	Licio Matos	13:53
Re: Another way to do audit in DML operations in PostgreSQL >= 14	Bruce Momjian	14:29
Re: Another way to do audit in DML operations in PostgreSQL >= 14	S Hoffman	19:35

Feb. 25, 2024

Thread	Author	Time
Are the estimates made for number of pages accurate	Sai Sadashiva Kundurmutt	08:40
Re: Are the estimates made for number of pages accurate	Tom Lane	16:41

Feb. 26, 2024

Thread	Author	Time
Re: Another way to do audit in DML operations in PostgreSQL >= 14	Ron Johnson	00:02
Re: Are the estimates made for number of pages accurate	Sai Sadashiva Kundurmutt	03:59
Google Cloud Maintenance	SOzcn	08:43
Re: Google Cloud Maintenance	Ozgur Kulu	10:30
Re: Use AD-account as login into Postgres.	Stephen Frost	18:05
Re: Would you ever recommend Shared Disk Failover for HA?	Stephen Frost	19:24

Feb. 27, 2024

Thread	Author	Time
Re: Another way to do audit in DML operations in PostgreSQL >= 14	Lucio Chiessi	14:41
explosive WAL growth	Scott Ribe	18:09
Re: explosive WAL growth	Alvaro Herrera	18:22
Re: explosive WAL growth	Lucio Chiessi	18:22
Re: explosive WAL growth	Scott Ribe	18:48
Re: explosive WAL growth	Karthik Yellapragada	18:58
Re: explosive WAL growth	Scott Ribe	19:19
Re: explosive WAL growth	vignesh kumar	19:50

Feb. 28, 2024

Thread	Author	Time
PG Role : With Crud Operations without Drop DB user	venkatesh R	03:30
Re: PG Role : With Crud Operations without Drop DB user	David G. Johnston	03:45
Mean_exec_time	Rajesh Kumar	06:01
New table not have access for read only user	Ankur Kaushik	12:40
Re: New table not have access for read only user	David G. Johnston	12:46
Re: New table not have access for read only user	Sundeep Kumar	12:46
Backup strategy	David Barron	16:23
Re: Backup strategy	Tom Lane	16:38
RE: Backup strategy	David Barron	16:45
Re: Backup strategy	Tom Lane	16:48
Re: Backup strategy	Peter Geoghegan	16:50
Re: Backup strategy	David G. Johnston	16:52
RE: Backup strategy	David Barron	16:53
Re: Backup strategy	Ron Johnson	18:22

Feb. 29, 2024

Thread	Author	Time
Need help - Unable to grant a role	Siraj G	01:06
Re: Need help - Unable to grant a role	Erik Wienhold	01:28
Re: Need help - Unable to grant a role	Siraj G	01:35
Re: Need help - Unable to grant a role	David G. Johnston	02:09
Re: Need help - Unable to grant a role	Siraj G	02:59
Re: Need help - Unable to grant a role	David G. Johnston	03:39
Re: Need help - Unable to grant a role	Erik Wienhold	03:48
Re: Need help - Unable to grant a role	Siraj G	06:58

Browse Archives

Prev | Next