Home > mailing lists

Mailing lists [pgsql-admin]

1 June 2024

02:00 postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` Mohan NBSPS
06:58 Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` Muhammad Imtiaz
12:40 Timeouts in Postgresql JDBC Driver Debraj Manna
13:53 Re: Timeouts in Postgresql JDBC Driver Muhammad Ikram
14:48 Re: Timeouts in Postgresql JDBC Driver Debraj Manna
15:45 Re: Timeouts in Postgresql JDBC Driver Debraj Manna

2 June 2024

07:00 Re: Timeouts in Postgresql JDBC Driver Muhammad Ikram
14:47 Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` Kashif Zeeshan

4 June 2024

04:29 Re: Timeouts in Postgresql JDBC Driver vignesh kumar
04:33 Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` vignesh kumar
04:38 Re: Questions on recovery situations (not urgent) vignesh kumar
04:41 Re: Upgrade from PostgreSQL version 10 to 16 vignesh kumar
04:47 Re: Autovacuum log messges re: index scans vignesh kumar
05:23 pgBackRest configuration with DDBoost Naveed Iftikhar
06:06 Re: pgBackRest configuration with DDBoost Ron Johnson
06:21 Re: pgBackRest configuration with DDBoost Scott Ribe
07:09 Re: pgBackRest configuration with DDBoost Ron Johnson
07:36 Re: pgBackRest configuration with DDBoost Amitpal Singh
16:14 Minimize checkpointer and walwriter io during pg_restore Ron Johnson
17:44 Re: pgBackRest configuration with DDBoost Naveed Iftikhar
18:21 Re: Minimize checkpointer and walwriter io during pg_restore Laurenz Albe
18:22 Re: pgBackRest configuration with DDBoost Ron Johnson
18:22 Re: pgBackRest configuration with DDBoost Scott Ribe
18:32 Re: Minimize checkpointer and walwriter io during pg_restore Ron Johnson
19:15 Re: pgBackRest configuration with DDBoost Naveed Iftikhar
20:42 pg_dump and restore without indexes Teja Jakkidi
20:56 Re: pg_dump and restore without indexes Erik Wienhold
20:58 Re: pg_dump and restore without indexes Teja Jakkidi
21:15 pg_dump and restore without indexes Wetmore, Matthew (CTR)
21:27 Re: pg_dump and restore without indexes Erik Wienhold
21:30 Re: pg_dump and restore without indexes Teja Jakkidi

5 June 2024

03:08 Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` Mohan NBSPS
03:08 Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` Mohan NBSPS
03:09 Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` Mohan NBSPS
06:36 Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` Kashif Zeeshan
06:42 Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog` Scott Ribe
06:51 Unable to create publication Siraj G
06:53 Re: Unable to create publication Kashif Zeeshan
12:52 Re: Minimize checkpointer and walwriter io during pg_restore Laurenz Albe
15:22 Re: Minimize checkpointer and walwriter io during pg_restore Ron Johnson

6 June 2024

00:23 Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE M Sarwar
00:39 Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE Tom Lane
01:21 Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE M Sarwar
10:58 Re: Truncate DUMMY_mid is blocked DELETE DUMMY_init TABLE Laurenz Albe
11:06 Re: Minimize checkpointer and walwriter io during pg_restore Laurenz Albe
15:54 Re: Minimize checkpointer and walwriter io during pg_restore Ron Johnson
16:33 Re: Minimize checkpointer and walwriter io during pg_restore Ron Johnson

7 June 2024

00:06 How to find the view modified date and time and user name M Sarwar
00:11 RE: How to find the view modified date and time and user name M Sarwar
00:48 Re: How to find the view modified date and time and user name David G. Johnston
00:49 Re: How to find the view modified date and time and user name David G. Johnston
03:47 Re: How to find the view modified date and time and user name Ron Johnson
04:14 Re: How to find the view modified date and time and user name Tom Lane
04:40 Re: How to find the view modified date and time and user name Ron Johnson
06:34 Re: How to find the view modified date and time and user name M Sarwar
06:40 Re: How to find the view modified date and time and user name M Sarwar
06:44 Re: How to find the view modified date and time and user name M Sarwar
06:54 Re: How to find the view modified date and time and user name M Sarwar
07:11 Re: How to find the view modified date and time and user name Kashif Zeeshan
07:14 Re: How to find the view modified date and time and user name David G. Johnston
07:17 Re: How to find the view modified date and time and user name David G. Johnston
07:25 Re: How to find the view modified date and time and user name Kashif Zeeshan
07:29 Re: How to find the view modified date and time and user name Ron Johnson
16:01 Re: How to find the view modified date and time and user name Rui DeSousa
18:35 Re: How to find the view modified date and time and user name Muhammad Ikram
20:29 RE: [EXTERNAL] Re: How to find the view modified date and time and user name Wetmore, Matthew (CTR)

8 June 2024

17:15 Streams replication and Failover failback Datta D
17:45 Re: Streams replication and Failover failback Muhammad Ikram
22:58 Re: Streams replication and Failover failback Ron Johnson

9 June 2024

19:35 Re: How to find the view modified date and time and user name M Sarwar
19:41 Re: [EXTERNAL] Re: How to find the view modified date and time and user name M Sarwar
20:11 Re: How to find the view modified date and time and user name M Sarwar
22:24 PostgreSQL Logical replication FROM RDS TO EC2 Sbob
22:35 Re: PostgreSQL Logical replication FROM RDS TO EC2 Kashif Zeeshan

10 June 2024

03:09 GRANT CONNECT ON DATABASE Edwin UY
03:14 Re: GRANT CONNECT ON DATABASE soroush jurat
03:27 Re: GRANT CONNECT ON DATABASE David G. Johnston
03:27 Re: GRANT CONNECT ON DATABASE Edwin UY
03:30 Re: GRANT CONNECT ON DATABASE David G. Johnston
03:34 Re: GRANT CONNECT ON DATABASE soroush jurat
04:02 Re: GRANT CONNECT ON DATABASE Edwin UY
10:41 Re: How to find the view modified date and time and user name Muhammad Ikram
13:59 Re: GRANT CONNECT ON DATABASE Norbert Poellmann
15:17 Re: GRANT CONNECT ON DATABASE Edwin UY
15:44 RE: GRANT CONNECT ON DATABASE M Sarwar
16:41 Re: GRANT CONNECT ON DATABASE Edwin UY
16:49 How to setup startup without asking for a passphrase Edwin UY
17:58 Re: How to setup startup without asking for a passphrase Tom Lane
21:41 Re: Questions on recovery situations (not urgent) Charles Schultz

11 June 2024

04:37 Re: Questions on recovery situations (not urgent) Laurenz Albe
14:22 Re: Questions on recovery situations (not urgent) Charles Schultz

12 June 2024

00:15 Index - Concurrently Method SOzcn
09:38 Re: Index - Concurrently Method Laurenz Albe
09:48 Re: Index - Concurrently Method SOzcn
12:16 Questions on WAL Rajesh Kumar
12:17 Re: Questions on WAL Kashif Zeeshan
12:19 Re: Questions on WAL Rajesh Kumar
12:22 Re: Questions on WAL Kashif Zeeshan
12:25 Re: Questions on WAL Ron Johnson
17:06 pg_upgrade Wasim Devale
20:14 Logical replication from PostgreSQL 10.23 to 16.3, last two big tables (getting synced) just keep growing Achilleas Mantzios
21:09 Re: Logical replication from PostgreSQL 10.23 to 16.3, last two big tables (getting synced) just keep growing Achilleas Mantzios
22:46 Re: Logical replication from PostgreSQL 10.23 to 16.3, last two big tables (getting synced) just keep growing Achilleas Mantzios
22:50 Re: pg_upgrade Holger Jakobs

13 June 2024

04:23 How to Handle Sequences in Logical Bi-Directional Replication PGSQL DBA
06:58 Re: Logical replication from PostgreSQL 10.23 to 16.3, last two big tables (getting synced) just keep growing Achilleas Mantzios
07:13 Re: How to Handle Sequences in Logical Bi-Directional Replication Matti Linnanvuori
07:50 Re: pg_upgrade Wasim Devale
08:34 Re: How to Handle Sequences in Logical Bi-Directional Replication Muhammad Ikram
10:15 Re: How to Handle Sequences in Logical Bi-Directional Replication Laurenz Albe
15:52 Get PG primary version without substring manipulation? Ron Johnson
16:17 Re: Get PG primary version without substring manipulation? Peter Adlersburg
16:17 Re: Get PG primary version without substring manipulation? Keith Fiske
19:50 Re: Get PG primary version without substring manipulation? J T

14 June 2024

03:30 Re: Get PG primary version without substring manipulation? Ian Lawrence Barwick
10:25 Re: Get PG primary version without substring manipulation? Laurenz Albe
18:22 Keepalive Rui DeSousa
18:28 Re: Keepalive Tom Lane
19:52 Outage caused by query in IPC:MessageQueueReceive wait???? Chris Hoover
20:02 Re: Outage caused by query in IPC:MessageQueueReceive wait???? Chris Hoover
20:47 Re: Keepalive Laurenz Albe
21:19 Re: Outage caused by query in IPC:MessageQueueReceive wait???? Chris Hoover
22:47 Re: Outage caused by query in IPC:MessageQueueReceive wait???? Chris Hoover
22:54 Re: Keepalive Rui DeSousa
23:32 Re: Keepalive Rui DeSousa

15 June 2024

18:56 Re: Logical replication from PostgreSQL 10.23 to 16.3, last two big tables (getting synced) just keep growing Achilleas Mantzios
19:17 Re: Keepalive Rui DeSousa

16 June 2024

02:25 Re: Keepalive Tom Lane
09:06 Re: Keepalive Rui DeSousa

17 June 2024

02:49 Urgent: Segmentation Fault in PostgreSQL postmaster Process Veerendra Pulapa
06:02 RE: Urgent: Segmentation Fault in PostgreSQL postmaster Process
08:10 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Vijaykumar Jain
08:14 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Achilleas Mantzios
13:49 Custom ordering operator for type xid Alexander Lipatov
15:54 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Veerendra Pulapa
15:55 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Veerendra Pulapa
16:00 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Veerendra Pulapa
17:39 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Laurenz Albe
18:03 Re: Custom ordering operator for type xid Tom Lane
18:33 Re: Custom ordering operator for type xid Rui DeSousa
18:40 Re: Custom ordering operator for type xid Alexander Lipatov

18 June 2024

13:38 Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge Phani Prathyush Somayajula
14:40 Re: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge Laurenz Albe
15:10 RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge Phani Prathyush Somayajula
16:22 RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
17:42 RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge Phani Prathyush Somayajula
22:33 Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER PABLO ANDRES IBARRA DUPRAT
22:39 Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER David G. Johnston
22:42 Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER David G. Johnston
22:47 RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER PABLO ANDRES IBARRA DUPRAT
22:58 RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
23:22 Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER Ron Johnson
23:23 Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER David G. Johnston
23:24 Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER David G. Johnston
23:28 Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER Ron Johnson
23:31 RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER
23:34 Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER David G. Johnston

19 June 2024

00:01 RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER PABLO ANDRES IBARRA DUPRAT
00:02 Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER David G. Johnston
00:08 Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER Tom Lane
00:14 RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER PABLO ANDRES IBARRA DUPRAT
01:02 RE: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER Vitale, Anthony, Sony Music
01:11 Statement_timeout in procedure block Teja Jakkidi
01:28 Materialized views & dead tuples Wells Oliver
01:38 RE: Materialized views & dead tuples
02:45 Re: Scripting a ALTER PROCEDURE or FUNCTION to Change OWNER David G. Johnston
07:14 Re: Statement_timeout in procedure block Achilleas Mantzios
07:24 Re: Materialized views & dead tuples Achilleas Mantzios
09:47 Re: Statement_timeout in procedure block jian he
10:24 Re: Statement_timeout in procedure block Laurenz Albe
10:27 Re: Materialized views & dead tuples Laurenz Albe
10:27 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Veerendra Pulapa
10:50 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Laurenz Albe
11:02 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Veerendra Pulapa
11:08 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Laurenz Albe
11:12 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Michael Banck
17:58 Re: Statement_timeout in procedure block Tom Lane
18:06 Re: Statement_timeout in procedure block Laurenz Albe
18:18 Excluding event triggers from a pg_dump Kenneth Barber
19:07 Re: Excluding event triggers from a pg_dump Idelette Tchakounte
19:18 Re: Materialized views & dead tuples Wells Oliver

20 June 2024

08:05 password_rollover_time like Oracle James Pang
09:43 Re: password_rollover_time like Oracle Kashif Zeeshan
10:18 pg_cron schedule partition automate Sathish Reddy
10:22 need help on pg_cron setup for partition Sathish Reddy
16:04 Pg_cron issue Sathish Reddy
19:47 Re: Pg_cron issue Achilleas Mantzios
23:51 Re: Pg_cron issue SOzcn

21 June 2024

00:00 Re: Pg_cron issue SOzcn
00:47 Re: need help on pg_cron setup for partition Nisarg Patel
03:53 Re: password_rollover_time like Oracle Rui DeSousa
04:35 Monitoring Script for Postgres Naveed Iftikhar
05:46 Re: password_rollover_time like Oracle Bruce Momjian
06:13 Re: password_rollover_time like Oracle Rui DeSousa
06:27 Re: Monitoring Script for Postgres Kashif Zeeshan
07:29 My Database getting dropped anonymously Sekar S
07:42 Re: My Database getting dropped anonymously David G. Johnston
07:47 Re: My Database getting dropped anonymously Ron Johnson
08:34 Re: My Database getting dropped anonymously Zaid Shabbir
09:51 Re: My Database getting dropped anonymously Piergiorgio Valli
12:56 Re: My Database getting dropped anonymously Muhammad Ikram
19:26 Re: Monitoring Script for Postgres Naveed Iftikhar

22 June 2024

07:30 pgpool not load balancing via foreign table Sbob
08:05 Re: pgpool not load balancing via foreign table David G. Johnston
08:12 Re: pgpool not load balancing via foreign table David G. Johnston
09:38 Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process Veerendra Pulapa
10:04 Segmentation Fault Issue in PostgreSQL 13.4 Veerendra Pulapa
11:17 Re: Segmentation Fault Issue in PostgreSQL 13.4 Vijaykumar Jain
11:21 Re: Segmentation Fault Issue in PostgreSQL 13.4 Pierre Forstmann
13:59 Re: My Database getting dropped anonymously Muhammad Ikram
18:54 Re: pgpool not load balancing via foreign table Sbob
23:11 Restoration Wasim Devale
23:15 Re: Restoration David G. Johnston

23 June 2024

00:06 Re: Restoration vrms
09:56 Re: Restoration Kashif Zeeshan
13:02 Re: Restoration Wasim Devale
13:42 Re: Restoration vrms
13:54 Re: Restoration Wasim Devale
15:01 Replication is stuck Murthy Nunna
15:15 Re: Replication is stuck Ninad Shah
15:34 RE: Replication is stuck Murthy Nunna
15:38 Re: Replication is stuck Ninad Shah
15:38 RE: Monitoring Script for Postgres
15:40 RE: Replication is stuck
15:41 Re: Restoration Kashif Zeeshan

24 June 2024

05:50 Logical replication troubleshooting Siraj G
07:01 Re: Logical replication troubleshooting Kashif Zeeshan
07:02 Re: Logical replication troubleshooting Muhammad Ikram
11:10 Re: Logical replication troubleshooting Laurenz Albe
11:13 Re: Segmentation Fault Issue in PostgreSQL 13.4 Laurenz Albe
12:28 Re: Logical replication troubleshooting Siraj G
17:47 Re: Monitoring Script for Postgres Naveed Iftikhar

25 June 2024

22:21 Postgresql 12.19 compatible with RHEL 9 Wasim Devale
22:22 Re: Postgresql 12.19 compatible with RHEL 9 Imran Khan

26 June 2024

14:02 Limiting line size in Postgres log files Priancka Chatz
15:19 Re: Limiting line size in Postgres log files Laurenz Albe
16:25 Re: Limiting line size in Postgres log files Ron Johnson

27 June 2024

17:01 Incorrect syntax when restoring a single table Ron Johnson
18:01 Re: Incorrect syntax when restoring a single table Achilleas Mantzios - cloud
18:05 Re: Incorrect syntax when restoring a single table Tom Lane
18:23 Re: Incorrect syntax when restoring a single table Ron Johnson
18:40 Re: Incorrect syntax when restoring a single table David G. Johnston
22:39 Fwd: Postgresql 12.19 compatible with RHEL 9 Wasim Devale

28 June 2024

12:31 Re: Postgresql 12.19 compatible with RHEL 9 Imran Khan
13:00 Re: Postgresql 12.19 compatible with RHEL 9 Wasim Devale
16:34 Strange "permission denied" errors on pg_restore Ron Johnson
16:42 Re: Postgresql 12.19 compatible with RHEL 9 Imran Khan
16:58 Free disk space decreasing after running Vaccum Full Sabyasachi Mukherjee
17:43 Re: Free disk space decreasing after running Vaccum Full Idelette Tchakounte
17:51 Re: Free disk space decreasing after running Vaccum Full Ron Johnson
17:53 Re: Free disk space decreasing after running Vaccum Full Ron Johnson
18:57 Re: Free disk space decreasing after running Vaccum Full Wells Oliver
19:07 Re: Free disk space decreasing after running Vaccum Full Sabyasachi Mukherjee
19:14 Re: Free disk space decreasing after running Vaccum Full Scott Ribe
19:23 Re: Free disk space decreasing after running Vaccum Full Sabyasachi Mukherjee
19:53 Re: Free disk space decreasing after running Vaccum Full Sabyasachi Mukherjee

29 June 2024

07:31 Re: Strange "permission denied" errors on pg_restore Laurenz Albe
08:04 Re: Strange "permission denied" errors on pg_restore Ron Johnson
08:13 Re: Strange "permission denied" errors on pg_restore Laurenz Albe
08:18 Re: Strange "permission denied" errors on pg_restore Ron Johnson
17:54 Re: Strange "permission denied" errors on pg_restore Tom Lane
21:52 Sudden spike in WAL Siraj G
21:54 Re: Sudden spike in WAL Mahesh mana
22:18 Re: Sudden spike in WAL Siraj G
22:29 Re: Sudden spike in WAL Mahesh mana

30 June 2024

00:10 Re: Sudden spike in WAL Achilleas Mantzios
01:12 Re: Strange "permission denied" errors on pg_restore Ron Johnson
01:30 Re: Strange "permission denied" errors on pg_restore Scott Ribe
01:34 Re: Strange "permission denied" errors on pg_restore Ron Johnson
08:13 Re: Strange "permission denied" errors on pg_restore Wasim Devale
09:48 Re: Strange "permission denied" errors on pg_restore Ron Johnson
11:48 Re: Sudden spike in WAL Siraj G