pgsql-admin - December 2023

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
Jump to day: 1 2 4 5 6 7 8 9 10 11 12 13 14 18 19 20 21 22 23 24 25 26 27 28 29 30

Dec. 1, 2023

Thread Author Time
Re: char column with a single space as the default not working Laurenz Albe 07:15

Dec. 2, 2023

Thread Author Time
Logical replication failed Srinivasarao Oguri 13:52

Dec. 4, 2023

Thread Author Time
Re: Logical replication failed Ninad Shah 11:16
Re: Logical replication failed Srinivasarao Oguri 12:53

Dec. 5, 2023

Thread Author Time
Tracking maintenance_work_memory flush pressure Joseph Hammerman 22:53

Dec. 6, 2023

Thread Author Time
Pgbouncer error Rajesh Kumar 16:49
Disable autocommit inside dbeaver arun chirappurath 17:41
Re: Disable autocommit inside dbeaver Holger Jakobs 18:22
Monitoring autovacuum induced contention Joseph Hammerman 21:35

Dec. 7, 2023

Thread Author Time
Re: Monitoring autovacuum induced contention Laurenz Albe 03:16
Fwd: Disable autocommit inside dbeaver arun chirappurath 03:45
Re: Fwd: Disable autocommit inside dbeaver Rob Sargent 03:49
Setup HA in PostgreSQL 15? Mahendra Singh 08:56
Re: Setup HA in PostgreSQL 15? Holger Jakobs 10:00
Pg_dump Rajesh Kumar 18:11
Re: Pg_dump Holger Jakobs 18:13
Re: Pg_dump Scott Ribe 18:26
Re: Pg_dump jason cable 18:39
Re: Pg_dump Tom Lane 18:52
Re: Pg_dump M Sarwar 19:00
Re: Pg_dump Alvaro Herrera 19:39
Pg_dump Rajesh Kumar 19:52
Re: Pg_dump David G. Johnston 19:55
Re: Pg_dump M Sarwar 19:58
Re: Pg_dump jason cable 20:00
Re: Pg_dump M Sarwar 20:02
Re: Pg_dump Ron Johnson 21:31

Dec. 8, 2023

Thread Author Time
Postgres storage migration Rajesh Kumar 09:43
Re: Postgres storage migration Paul Smith* 10:09
application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Achilleas Mantzios - cloud 10:21
Re: Postgres storage migration Ron Johnson 11:33
Re: Postgres storage migration Rajesh Kumar 12:37
Re: Postgres storage migration Ron Johnson 13:03
Re: Related to Foreign Table Accessing ROHIT SACHDEVA 13:59
Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Tom Lane 14:47
Re: Postgres storage migration Scott Ribe 14:57
Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Achilleas Mantzios - cloud 15:25
Re: Postgres storage migration ẞ. Shafi 15:26
Re: Related to Foreign Table Accessing Ron Johnson 16:16
Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Tom Lane 16:56
Re: Postgres storage migration Rajesh Kumar 19:05
Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Achilleas Mantzios 19:06
Re: Postgres storage migration Ron Johnson 20:00
Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Tom Lane 22:54

Dec. 9, 2023

Thread Author Time
Re: Postgres storage migration Rajesh Kumar 02:56
Re: Postgres storage migration Ron Johnson 05:08
Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Achilleas Mantzios 06:52
Inquiry Regarding Automatic Tuning Features in PostgreSQL Md. Ezhar Ansari 08:16
Re: Inquiry Regarding Automatic Tuning Features in PostgreSQL Ron Johnson 15:57
Re: Postgres storage migration Scott Ribe 16:12
Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Achilleas Mantzios 21:38
Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Tom Lane 22:08

Dec. 10, 2023

Thread Author Time
Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Achilleas Mantzios 05:41
Re: application_name backend (not) reporting back to the client : pgbouncer, PgSQL 16.1, pgbouncer 1.21.0 Achilleas Mantzios 07:54
Re: Postgres storage migration Rajesh Kumar 20:27

Dec. 11, 2023

Thread Author Time
Re: Inquiry Regarding Automatic Tuning Features in PostgreSQL Md. Ezhar Ansari 04:32
pg_auto_failover issues with password auth Roland Che 10:04

Dec. 12, 2023

Thread Author Time
Log Rotation SOzcn 16:11
Re: Log Rotation Tom Lane 16:18
Re: Log Rotation SOzcn 16:25
Re: Log Rotation Ron Johnson 16:48
Re: Log Rotation SOzcn 16:52
Re: Log Rotation Laurenz Albe 22:48

Dec. 13, 2023

Thread Author Time
Re: Log Rotation sagar jadhav 02:13
Re: Setup HA in PostgreSQL 15? Mahendra Singh 04:52
Re: Log Rotation SOzcn 07:25
Reindex concurrently SOzcn 11:27
Re: Reindex concurrently Holger Jakobs 13:48
Verify data after backup and restore Rajesh Kumar 13:50
Re: Verify data after backup and restore Holger Jakobs 14:17
Re: Setup HA in PostgreSQL 15? jacob ndinkwa 14:38
Re: Verify data after backup and restore Pepe TD Vo 15:16
Re: Verify data after backup and restore Ron Johnson 15:18
Best way to parse complex json string into table columns? Sbob 16:55
Re: Best way to parse complex json string into table columns? Tom Lane 17:24
Re: Reindex concurrently SOzcn 17:27
Re: Reindex concurrently Ron Johnson 17:53
Re: Reindex concurrently SOzcn 17:59
Re: Best way to parse complex json string into table columns? Sbob 18:05
Re: Reindex concurrently Ron Johnson 18:40
Re: Reindex concurrently David G. Johnston 18:46
Re: Verify data after backup and restore Rajesh Kumar 18:49
Re: Reindex concurrently SOzcn 18:52

Dec. 14, 2023

Thread Author Time
Re: Verify data after backup and restore Ron Johnson 04:54
Re: Verify data after backup and restore Rajesh Kumar 05:07
Re: Verify data after backup and restore Ron Johnson 05:09
Re: Verify data after backup and restore David G. Johnston 05:15
Re: Verify data after backup and restore kaido vaikla 08:09

Dec. 18, 2023

Thread Author Time
please ignore me from this group maki man 10:51
Backups using non-consistent snapshots (e.g. COW reflinks) Wilson, Chris 12:51
Re: Backups using non-consistent snapshots (e.g. COW reflinks) Stephen Frost 14:12
pg_ctl only allows 12 parameters? Ron Johnson 15:05
Re: pg_ctl only allows 12 parameters? David G. Johnston 15:11
Re: pg_ctl only allows 12 parameters? Ron Johnson 15:31
Re: pg_ctl only allows 12 parameters? David G. Johnston 15:40
Re: pg_ctl only allows 12 parameters? Ron Johnson 15:48
Re: pg_ctl only allows 12 parameters? David G. Johnston 16:02
Re: pg_ctl only allows 12 parameters? Tom Lane 16:09
Re: pg_ctl only allows 12 parameters? Ron Johnson 16:31
Guidance required to summarize the migration breaking changes between PG versions Aditya D 16:47
Re: pg_ctl only allows 12 parameters? Tom Lane 17:02
Re: pg_ctl only allows 12 parameters? Ron Johnson 18:03
Re: pg_ctl only allows 12 parameters? Tom Lane 19:28
Re: Guidance required to summarize the migration breaking changes between PG versions GF 19:30
Guidance required to summarize the migration breaking changes between PG versions Wetmore, Matthew (CTR) 19:32
Vacuuming TOAST after pg_restore Ron Johnson 22:26
Re: Vacuuming TOAST after pg_restore David G. Johnston 22:40
Re: Vacuuming TOAST after pg_restore Ron Johnson 23:14

Dec. 19, 2023

Thread Author Time
Re: Vacuuming TOAST after pg_restore David G. Johnston 00:56
Re: Vacuuming TOAST after pg_restore Laurenz Albe 07:18
highest timeline xxx of the primary is behind recovery timeline - backup of the underlying filesystem lejeczek 07:59
Request join jorge gerardo fernandez lugo 11:25
Would-be standby-node phoning home every 5 seconds. Why? Ron Johnson 14:07
Need inputs on postgresql HA with consul cluster Rambabu V 14:12
Re: Need inputs on postgresql HA with consul cluster Scott Ribe 14:22
Re: Would-be standby-node phoning home every 5 seconds. Why? SOzcn 14:57
Re: Would-be standby-node phoning home every 5 seconds. Why? Ron Johnson 15:25
Re: Would-be standby-node phoning home every 5 seconds. Why? SOzcn 16:09
Re: Would-be standby-node phoning home every 5 seconds. Why? Ron Johnson 16:14
Re: Would-be standby-node phoning home every 5 seconds. Why? Ron Johnson 16:28
Re: Would-be standby-node phoning home every 5 seconds. Why? SOzcn 16:33
Re: Need inputs on postgresql HA with consul cluster Rambabu V 17:32
Re: Need inputs on postgresql HA with consul cluster Ron Johnson 17:40
Re: Need inputs on postgresql HA with consul cluster Karthik Yellapragada 19:05
Timestamps in outputs Murthy Nunna 23:08

Dec. 20, 2023

Thread Author Time
Re: Need inputs on postgresql HA with consul cluster Rambabu V 01:52
Oracle to Postgres migration bimal maity 03:35
Re: Timestamps in outputs SOzcn 06:14
Truncate data from whole cluster Rajesh Kumar 09:05
Re: Truncate data from whole cluster hubert depesz lubaczewski 10:23
AW: Truncate data from whole cluster Dischner, Anton 11:39
Re: AW: Truncate data from whole cluster hubert depesz lubaczewski 11:50
Re: AW: Truncate data from whole cluster Rajesh Kumar 15:09
Re: Need inputs on postgresql HA with consul cluster kaido vaikla 17:42
Re: Need inputs on postgresql HA with consul cluster kaido vaikla 18:30

Dec. 21, 2023

Thread Author Time
Re: Need inputs on postgresql HA with consul cluster Rambabu V 01:49
LDAP (AD) Configuration jacob ndinkwa 13:29
Error: Package: postgresql13-devel-13.13-1PGDG.rhel7.x86_64 tayyab.humayl 16:21
Case sensitive grant statements in pg14? richard coleman 18:26
Re: Case sensitive grant statements in pg14? Tom Lane 18:36
Re: Case sensitive grant statements in pg14? richard coleman 18:45
Error: Package: postgresql13-devel-13.13-1PGDG.rhel7.x86_64 Wetmore, Matthew (CTR) 19:13
Re: Case sensitive grant statements in pg14? Tom Lane 19:26
help Michael Thomas 19:33
Re: Case sensitive grant statements in pg14? M Sarwar 19:34
Login script Krishna B 19:41
Re: Case sensitive grant statements in pg14? richard coleman 19:51
Re: Case sensitive grant statements in pg14? M Sarwar 20:03
Re: Login script M Sarwar 20:05
Re: Case sensitive grant statements in pg14? Tom Lane 20:08
Re: Login script SOzcn 20:23
Case sensitive grant statements in pg14? Wetmore, Matthew (CTR) 20:35
Re: Case sensitive grant statements in pg14? Joe Conway 20:39
Re: Case sensitive grant statements in pg14? kaido vaikla 20:39
Re: Case sensitive grant statements in pg14? Tom Lane 20:43
Re: Case sensitive grant statements in pg14? richard coleman 21:35
Re: Error: Package: postgresql13-devel-13.13-1PGDG.rhel7.x86_64 Carlos Alves 22:09

Dec. 22, 2023

Thread Author Time
Re: Login script M Sarwar 02:52
Re: Login script Krishna B 03:45
Re: Oracle to Postgres migration Ilya Kosmodemiansky 09:49
RE: Error: Package: postgresql13-devel-13.13-1PGDG.rhel7.x86_64 tayyab.humayl 11:20
Re: Oracle to Postgres migration Thomas Kellerer 12:25
Inquiry Regarding PostgreSQL Index Size - Seeking Community Insights Md. Ezhar Ansari 14:20
Best way to stop Streaming Replication? Ron Johnson 19:49
Re: Best way to stop Streaming Replication? kaido vaikla 21:11
Re: Best way to stop Streaming Replication? Samed YILDIRIM 21:38
Re: LDAP (AD) Configuration Samed YILDIRIM 22:16
Re: LDAP (AD) Configuration Brett Bisesti 22:53

Dec. 23, 2023

Thread Author Time
Re: Need inputs on postgresql HA with consul cluster Rambabu V 06:11
Re: Need inputs on postgresql HA with consul cluster Rambabu V 06:11
Re: Need inputs on postgresql HA with consul cluster 📎 Rambabu V 06:13
Re: Need inputs on postgresql HA with consul cluster Scott Ribe 13:29
Re: Need inputs on postgresql HA with consul cluster Rambabu V 13:33
Re: Need inputs on postgresql HA with consul cluster Scott Ribe 13:36
Re: Best way to stop Streaming Replication? Ron Johnson 17:34
Switchover Rajesh Kumar 18:08
Re: Best way to stop Streaming Replication? Samed YILDIRIM 22:57
Re: Best way to stop Streaming Replication? Ron Johnson 23:53

Dec. 24, 2023

Thread Author Time
Re: Need inputs on postgresql HA with consul cluster Scott Ribe 14:00
RE: Timestamps in outputs Murthy Nunna 15:36
Query Performance after pg_restore Murthy Nunna 15:53
Re: Query Performance after pg_restore Tom Lane 16:12
Re: Timestamps in outputs Scott Ribe 16:27
RE: Query Performance after pg_restore Murthy Nunna 17:00
Re: Query Performance after pg_restore Ron Johnson 17:18

Dec. 25, 2023

Thread Author Time
Re: Query Performance after pg_restore Laurenz Albe 01:06
RE: Query Performance after pg_restore Murthy Nunna 18:04
Re: Login script M Sarwar 22:37
Re: Login script Krishna B 22:43
Re: Login script M Sarwar 22:46
Re: Login script Krishna B 23:21

Dec. 26, 2023

Thread Author Time
pg_file_settings Rıdvan Korkmaz 07:13
Re: pg_file_settings Rıdvan Korkmaz 18:12
Re: pg_file_settings Tom Lane 19:22
Re: Login script M Sarwar 22:47

Dec. 27, 2023

Thread Author Time
how to troubleshoot a wrong query plan jian xu 20:45
RE: how to troubleshoot a wrong query plan jian xu 21:15
Re: how to troubleshoot a wrong query plan Tom Lane 21:21
Re: how to troubleshoot a wrong query plan jian xu 21:29
Re: how to troubleshoot a wrong query plan Tom Lane 21:38

Browse Archives

Prev | Next
Jump to day: 1 2 4 5 6 7 8 9 10 11 12 13 14 18 19 20 21 22 23 24 25 26 27 28 29 30