Home > mailing lists

Mailing lists [pgsql-admin]

1 October 2023

00:17 Re: Backup solution over unreliable network Ron

2 October 2023

08:54 Re: Terminating connection because of crash of another server process Deo Felix
09:00 Re: Terminating connection because of crash of another server process Deo Felix

3 October 2023

09:15 Re: Terminating connection because of crash of another server process Deepak Goel

4 October 2023

18:38 Idle_session_timeout Rajesh Kumar
18:51 Re: Idle_session_timeout Scott Ribe
19:23 Re: Idle_session_timeout Goran Pulevic
21:13 Timeout Issue SOzcn
21:56 Re: Timeout Issue Ron
22:03 RE: Timeout Issue
22:42 Re: Idle_session_timeout Rajesh Kumar
23:34 Re: Idle_session_timeout Laurenz Albe

5 October 2023

07:07 Re: Pg_cron not working Rajesh Kumar
08:42 Re: Pg_cron not working Marian Wendt
20:48 Benjamin Acquaye
21:10 Re: David G. Johnston
21:48 Re: M Sarwar
22:12 BDR Nikhil Ingale
23:55 Re: Benjamin Acquaye

8 October 2023

00:54 Error "public.powa_take_snapshot()" in PostgreSQL Pablo Delgado

9 October 2023

15:25 Re: Error "public.powa_take_snapshot()" in PostgreSQL Ninad Shah
15:29 Re: Error "public.powa_take_snapshot()" in PostgreSQL Julien Rouhaud
17:07 Discard All in pgbouncer Rajesh Kumar
17:11 Re: Discard All in pgbouncer Scott Ribe
17:12 Re: Discard All in pgbouncer Samed YILDIRIM
17:13 Re: Discard All in pgbouncer Ron
17:18 Re: Discard All in pgbouncer Rajesh Kumar
17:22 Re: Discard All in pgbouncer Scott Ribe
17:22 Re: Discard All in pgbouncer Rajesh Kumar
17:34 Re: Discard All in pgbouncer Michael Banck
17:44 Re: Discard All in pgbouncer David G. Johnston
17:48 Re: Discard All in pgbouncer Rajesh Kumar
17:52 Re: Discard All in pgbouncer David G. Johnston
18:39 Re: Discard All in pgbouncer Ron

11 October 2023

18:36 Automation Rajesh Kumar
18:52 Re: Automation Ron
19:15 Re: Automation Dan Smith
19:27 Re: Automation David G. Johnston
19:43 Re: Automation Matuszyk, Paul G.
21:36 Re: Automation Rajesh Kumar

12 October 2023

11:44 Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'? Zhaoxun Yan
11:48 Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'? Zhaoxun Yan
12:18 Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'? Ron
15:42 Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'? Zhaoxun Yan
16:29 Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'? Ron

13 October 2023

02:46 Locks analyze Rajesh Kumar
04:41 Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'? Zhaoxun Yan
05:03 Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'? Tom Lane
05:21 Re: Locks analyze Scott Ribe
09:02 Re: Locks analyze Laurenz Albe
09:40 Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'? Zhaoxun Yan
10:04 Re: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'? David G. Johnston
11:51 Re: Automation Rajesh Kumar
12:39 Re: Locks analyze Rajesh Kumar
14:59 Re: Locks analyze Laurenz Albe
16:06 One PG process eating more than 40GB of RAM and getting killed by OOM Jean-Christophe Boggio
16:12 Re: One PG process eating more than 40GB of RAM and getting killed by OOM MichaelDBA
16:13 Re: One PG process eating more than 40GB of RAM and getting killed by OOM Johannes Truschnigg
16:13 Re: One PG process eating more than 40GB of RAM and getting killed by OOM Michael Banck
16:14 Re: Locks analyze Scott Ribe
17:31 Re: One PG process eating more than 40GB of RAM and getting killed by OOM Jean-Christophe Boggio
17:57 Re: Locks analyze Rajesh Kumar
18:02 Re: One PG process eating more than 40GB of RAM and getting killed by OOM Tom Lane
19:48 Re: One PG process eating more than 40GB of RAM and getting killed by OOM Jeff Janes
22:12 Re: One PG process eating more than 40GB of RAM and getting killed by OOM Jean-Christophe Boggio
22:38 Re: One PG process eating more than 40GB of RAM and getting killed by OOM Tom Lane

14 October 2023

00:53 Connecting 2 databases within the same instance M Sarwar
00:58 Re: Connecting 2 databases within the same instance Scott Ribe
01:36 Re: Connecting 2 databases within the same instance M Sarwar
01:39 Re: One PG process eating more than 40GB of RAM and getting killed by OOM Tom Lane
04:37 Re: Connecting 2 databases within the same instance swastik Gurung
04:40 RE: Connecting 2 databases within the same instance M Sarwar
05:08 Re: Connecting 2 databases within the same instance Scott Ribe
05:15 Re: Connecting 2 databases within the same instance Ron
09:50 Re: One PG process eating more than 40GB of RAM and getting killed by OOM Jean-Christophe Boggio
23:46 Big table and partition Rajesh Kumar

15 October 2023

00:06 Re: Big table and partition Ron
01:14 Re: Connecting 2 databases within the same instance M Sarwar
01:16 Re: Connecting 2 databases within the same instance M Sarwar
17:37 Re: Big table and partition Christophe Courtois
23:46 Re: Big table and partition Rajesh Kumar

16 October 2023

00:03 Re: Big table and partition Ron
00:13 Re: Big table and partition JP Pozzi
04:53 Re: Big table and partition Rajesh Kumar
16:09 Re: Big table and partition Rajesh Kumar
16:33 Re: Big table and partition Ron
17:45 Re: Big table and partition Rajesh Kumar
23:46 Auto Vacuum Question Murthy Nunna
23:55 List Based Table Partitioning on non-Primary Key Columns Amit Sharma

17 October 2023

00:04 Re: List Based Table Partitioning on non-Primary Key Columns Scott Ribe
00:40 Re: Auto Vacuum Question Michael Banck
09:55 postgresql lost connection to repmgr arbitrarily Zhaoxun Yan
16:39 Re: postgresql lost connection to repmgr arbitrarily Scott Ribe
20:53 Table health Rajesh Kumar
22:15 Re: Table health Ron

18 October 2023

05:25 Re: postgresql lost connection to repmgr arbitrarily Zhaoxun Yan
09:52 Re: Table health Laurenz Albe
12:30 connection timeout expired Alexander Gesser
12:41 Fwd: postgresql lost connection to repmgr arbitrarily Zhaoxun Yan
15:40 Re: Table health Tomek
16:37 Re: Table health Rajesh Kumar
17:02 Re: Table health Tomek
17:11 Re: Table health Ron
17:13 Re: Table health Alvaro Herrera
21:32 What's the state of native Transparent Data Encryption (TDE) in PostgreSQL? richard coleman
21:43 Re: What's the state of native Transparent Data Encryption (TDE) in PostgreSQL? Bruce Momjian
22:29 Tools available to determine bad code in the testing phase Siraj G
22:30 Re: connection timeout expired gunnar.wagner
22:36 Re: What's the state of native Transparent Data Encryption (TDE) in PostgreSQL? richard coleman
23:05 Vacuumdb on a table Murthy Nunna
23:47 Re: What's the state of native Transparent Data Encryption (TDE) in PostgreSQL? Stephen Frost

19 October 2023

01:30 pg_dump -Z6 (the default) can be pretty slow Ron
01:37 Re: pg_dump -Z6 (the default) can be pretty slow Scott Ribe
02:21 Re: pg_dump -Z6 (the default) can be pretty slow Ron
02:42 Re: pg_dump -Z6 (the default) can be pretty slow Scott Ribe
03:00 Re: pg_dump -Z6 (the default) can be pretty slow Ron
07:25 Re: Tools available to determine bad code in the testing phase Julien Rouhaud
07:30 Re: Table health Rajesh Kumar
07:31 Re: Vacuumdb on a table Keith
07:32 Cluster creation in Openshift container Rajesh Kumar
07:38 Re: Vacuumdb on a table Scott Ribe
11:02 Re: Vacuumdb on a table Tomek
11:14 Re: Vacuumdb on a table Tomek
13:08 Need assistance for replication sync issue Veerendra Pulapa
13:38 Re: Need assistance for replication sync issue Licio Matos
13:55 Re: Need assistance for replication sync issue Laurenz Albe
15:36 Re: Need assistance for replication sync issue Ron
15:59 Re: connection timeout expired Scott Ribe
18:41 Binaries for EOL version? Ron
18:57 RE: Binaries for EOL version? HALAT-PRUVOT SYLVIE
19:05 Re: What's the state of native Transparent Data Encryption (TDE) in PostgreSQL? Bruce Momjian
19:13 Re: Binaries for EOL version? Ron
19:22 Re: Binaries for EOL version? Thomas Kellerer
20:03 Re: Binaries for EOL version? Ron
20:08 RE: Vacuumdb on a table Murthy Nunna
20:30 Re: Binaries for EOL version? Tom Lane
20:54 Re: Binaries for EOL version? Ron
21:35 Re: postgresql14-contrib does not install with libpython 3.7 Alex Williams
21:38 Re: Binaries for EOL version? Evan Rempel
22:06 Re: Binaries for EOL version? Ron
22:44 Re: Binaries for EOL version? Evan Rempel
23:02 Re: Binaries for EOL version? Ron
23:04 Re: Vacuumdb on a table Laurenz Albe
23:21 Re: Binaries for EOL version? Evan Rempel

20 October 2023

00:05 Re: Binaries for EOL version? Ron
00:12 Re: Binaries for EOL version? Evan Rempel
01:38 Re: postgresql14-contrib does not install with libpython 3.7 Marcia Rocha
01:43 Re: postgresql14-contrib does not install with libpython 3.7 Alex Williams
04:24 using pg_ctl over ssh hangs Sbob
04:31 Re: using pg_ctl over ssh hangs David G. Johnston
04:32 Re: using pg_ctl over ssh hangs Tom Lane
05:58 Re: Binaries for EOL version? Ron
07:10 Re: Need assistance for replication sync issue Veerendra Pulapa
13:20 User/Roles, Owner, and privileges migration strategy ADITYA DUVURI
16:55 Re: using pg_ctl over ssh hangs vrms
17:57 Re: User/Roles, Owner, and privileges migration strategy M Sarwar

21 October 2023

18:07 Need to run pg_dump from the laptop without entering the password M Sarwar
18:18 Re: Need to run pg_dump from the laptop without entering the password Ron
18:24 Re: Need to run pg_dump from the laptop without entering the password ramsiddu007
22:24 autovacuum query Murthy Nunna

22 October 2023

05:51 Re: User/Roles, Owner, and privileges migration strategy ADITYA DUVURI
19:01 Re: User/Roles, Owner, and privileges migration strategy Holger Jakobs
22:40 Re: User/Roles, Owner, and privileges migration strategy Ron

23 October 2023

01:31 Re: Need to run pg_dump from the laptop without entering the password M Sarwar
02:19 Re: Need to run pg_dump from the laptop without entering the password Erik Wienhold
02:55 Re: Need to run pg_dump from the laptop without entering the password Ron
04:00 Re: Need to run pg_dump from the laptop without entering the password Erik Wienhold
04:27 Re: Need to run pg_dump from the laptop without entering the password M Sarwar
04:30 Re: Need to run pg_dump from the laptop without entering the password M Sarwar
04:54 Re: Need to run pg_dump from the laptop without entering the password M Sarwar
14:58 Re: Need assistance for replication sync issue Tomek

24 October 2023

14:18 Re: User/Roles, Owner, and privileges migration strategy Aditya D
15:42 Re: User/Roles, Owner, and privileges migration strategy Ron
16:34 Re: User/Roles, Owner, and privileges migration strategy Dan Smith
19:43 pg_restore is not working M Sarwar
19:56 Re: pg_restore is not working Scott Ribe
20:02 Re: pg_restore is not working M Sarwar
20:05 RE: pg_restore is not working Wetmore, Matthew (CTR)
20:08 Re: pg_restore is not working Ron
20:18 Re: pg_restore is not working M Sarwar
20:24 Re: pg_restore is not working M Sarwar
20:25 RE: pg_restore is not working Wetmore, Matthew (CTR)
20:34 Re: pg_restore is not working Michael Banck
20:56 Re: pg_restore is not working Ron
21:28 Re: pg_restore is not working M Sarwar
22:13 Re: pg_restore is not working M Sarwar
22:43 Re: pg_restore is not working Ron
22:45 Re: postgresql14-contrib does not install with libpython 3.7 Alex Williams
22:55 Re: pg_restore is not working M Sarwar
23:03 Re: pg_restore is not working Ron

25 October 2023

00:47 Re: postgresql14-contrib does not install with libpython 3.7 Marcia Rocha
12:46 Re: postgresql14-contrib does not install with libpython 3.7 Devrim Gündüz
13:01 Re: User/Roles, Owner, and privileges migration strategy Aditya D
13:19 Autovacuum and Insert wait Rajesh Kumar
14:15 Re: Autovacuum and Insert wait Alvaro Herrera
14:27 Re: User/Roles, Owner, and privileges migration strategy Alvaro Herrera
14:36 Re: Autovacuum and Insert wait Rajesh Kumar
18:00 Predefined Role - pg_write_all_data Gambhir Singh
20:51 Re: User/Roles, Owner, and privileges migration strategy Tom Lane
22:32 Re: User/Roles, Owner, and privileges migration strategy Alvaro Herrera
23:39 Re: User/Roles, Owner, and privileges migration strategy Ron

26 October 2023

06:14 pgbouncer's default_pool_size and server limits Victor Sudakov
08:34 Re: Predefined Role - pg_write_all_data Laurenz Albe
22:39 GCP Postgres denied connection requests for user. Ron Watkins
23:17 Re: GCP Postgres denied connection requests for user. Tom Lane

27 October 2023

07:07 pgadmin for ubuntu 23.10 (mantic) Sanjay Minni
11:14 pgagent for windows download link missing B Liu
13:13 statement_timeout has no effect if sync standby is unavailable Nikhil Shetty
13:36 On Replica - History issue SOzcn
13:53 Re: pgagent for windows download link missing Zhaoxun Yan
15:29 Re: On Replica - History issue Laurenz Albe
16:33 Re: pgagent for windows download link missing B Liu
16:34 Progress of ALTER TABLE on inheritance-partitioned table? Ron
16:41 Re: Progress of ALTER TABLE on inheritance-partitioned table? Michael Guissine
16:42 Introducing PostgresFly: A New PostgreSQL Installation Tool Rozad Khalaf
17:04 Re: Progress of ALTER TABLE on inheritance-partitioned table? Laurenz Albe
17:16 ORDER BY DESC and NULLS LAST by default Loles
17:17 Re: ORDER BY DESC and NULLS LAST by default M Sarwar
17:19 Re: Progress of ALTER TABLE on inheritance-partitioned table? Ron
17:40 Rollback after "Connection timed out"? Ron
17:42 Re: ORDER BY DESC and NULLS LAST by default Arjan Saly Consultancy (EU)
17:45 Re: Rollback after "Connection timed out"? Tom Lane
18:54 Re: ORDER BY DESC and NULLS LAST by default Laurenz Albe
18:55 Re: Progress of ALTER TABLE on inheritance-partitioned table? Laurenz Albe
19:25 Re: ORDER BY DESC and NULLS LAST by default Holger Jakobs
20:55 Re: ORDER BY DESC and NULLS LAST by default Loles
21:02 pg_restore -L reordering of the statements does not work Aditya D
21:05 Re: ORDER BY DESC and NULLS LAST by default David G. Johnston
21:08 Re: ORDER BY DESC and NULLS LAST by default Tom Lane
21:34 Re: pg_restore -L reordering of the statements does not work Tom Lane
22:32 RE: ORDER BY DESC and NULLS LAST by default M Sarwar

29 October 2023

04:36 Re: pg_restore -L reordering of the statements does not work Aditya D
04:41 Re: pg_restore -L reordering of the statements does not work David G. Johnston
04:49 Re: pg_restore -L reordering of the statements does not work Tom Lane
05:59 Re: pg_restore -L reordering of the statements does not work Aditya D
18:10 Not able to grant role to User. Gambhir Singh
18:31 Re: Not able to grant role to User. Ron
18:48 Re: Not able to grant role to User. ashter lab
18:56 Re: Not able to grant role to User. Ron

30 October 2023

04:46 Re: pg_restore -L reordering of the statements does not work Aditya D
06:48 Re: Not able to grant role to User. Laurenz Albe
07:11 Re: Not able to grant role to User. Tom Lane
13:48 Re: On Replica - History issue SOzcn
14:00 Re: On Replica - History issue SOzcn
14:20 AUTOVACUUM Siraj G
15:29 Re: On Replica - History issue Laurenz Albe
16:27 Re: On Replica - History issue SOzcn
16:28 Optimized WHERE UPPER(name) LIKE UPPER('%p_name%') Loles
16:34 Re: On Replica - History issue SOzcn
16:39 RE: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%') HALAT-PRUVOT SYLVIE
16:42 Re: AUTOVACUUM Ron
17:08 Re: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%') Tom Lane
17:11 Re: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%') Jeff Janes
17:29 Re: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%') Dan Smith

31 October 2023

07:13 Re: AUTOVACUUM Siraj G
11:57 postgresql backups to rubrik anyone MAILBOX-DBS
17:46 Re: postgresql backups to rubrik anyone Ron
19:09 RPMs changing in the yum repository Evan Rempel