Mailing lists [pgsql-admin]

1 March 2023

• 02:11   Query taking long with levenshtein function Teju Jakkidi vlogs
• 02:30   Re: Query taking long with levenshtein function Tom Lane
• 10:48   Forcasting in Postgresql Govardhan .G
• 19:57   Re: Forcasting in Postgresql Laurenz Albe
• 21:27   Create replication read only Erik Serrano

2 March 2023

• 01:00   Re: Create replication read only Ron
• 14:53   psql terminates on first error Holger Jakobs
• 15:32   Re: psql terminates on first error Erik Wienhold
• 15:44   Re: psql terminates on first error Holger Jakobs
• 15:48   Re: psql terminates on first error Thomas Kellerer
• 16:30   Re: psql terminates on first error Holger Jakobs
• 16:45   Re: psql terminates on first error Erik Wienhold
• 17:33   Re: psql terminates on first error Tom Lane
• 17:36   Re: psql terminates on first error Holger Jakobs
• 19:25   Re: Forcasting in Postgresql Govardhan .G
• 20:47   RE: Forcasting in Postgresql 
• 20:51   Re: Forcasting in Postgresql Govardhan .G

3 March 2023

• 00:53   Re: New PG14 server won't start with >2GB shared_buffers Chris Hoover
• 00:56   Re: New PG14 server won't start with >2GB shared_buffers MichaelDBA
• 10:37   replication origin advance in pglogical extension srinivas oguri

6 March 2023

• 12:05   Upgrading Patroni from 2.1.x to 3.0.1 ? Victor Sudakov

7 March 2023

• 00:00   Migrating tables to new schema with minimal downtime Joseph Hammerman
• 09:29   Re: Migrating tables to new schema with minimal downtime Laurenz Albe
• 14:59   Re: Migrating tables to new schema with minimal downtime hubert depesz lubaczewski
• 18:42   Replication between two different versions Erik Serrano
• 19:35   Re: Replication between two different versions J T
• 19:44   Re: Replication between two different versions Erik Serrano
• 19:49   Re: Replication between two different versions J T

8 March 2023

• 03:56   Re: Replication between two different versions Abhishek Singh
• 16:04   PostgreSQL uses huge amount of memory Mauricio Martini
• 16:29   Re: PostgreSQL uses huge amount of memory Neimar Sierota
• 19:13   Re: PostgreSQL uses huge amount of memory Scott Ribe
• 19:48   Re: PostgreSQL uses huge amount of memory Fernando Hevia
• 21:42   Re: PostgreSQL uses huge amount of memory Tom Lane

9 March 2023

• 11:22   database collation "C" and "C.LATIN1" James Pang (chaolpan)
• 11:29   Re: database collation "C" and "C.LATIN1" Laurenz Albe
• 11:31   RE: database collation "C" and "C.LATIN1" James Pang (chaolpan)
• 11:37   RE: database collation "C" and "C.LATIN1" James Pang (chaolpan)
• 12:46   postgresql to Oracle database migration Renjith Gk
• 12:48   Re: postgresql to Oracle database migration Holger Jakobs
• 15:04   Re: database collation "C" and "C.LATIN1" Laurenz Albe
• 16:08   Re: postgresql to Oracle database migration Eric Raskin
• 16:09   Re: postgresql to Oracle database migration Sumit Sengupta
• 17:35   Re: database collation "C" and "C.LATIN1" Tom Lane
• 18:19   Malformed array literal in goin from jsonb to real[] Wells Oliver
• 19:05   Re: Malformed array literal in goin from jsonb to real[] Erik Wienhold
• 19:12   Re: Malformed array literal in goin from jsonb to real[] Erik Wienhold
• 22:41   Re: postgresql to Oracle database migration Piergiorgio Valli

10 March 2023

• 20:39   LOG: could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat" Erik Wienhold
• 21:06   Re: LOG: could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat" Holger Jakobs

11 March 2023

• 21:23   Ways to change a database collation with removing duplicates Alexey Murz Korepov
• 21:49   Tooling for per table autovacuum tuning Joseph Hammerman
• 22:07   Re: Tooling for per table autovacuum tuning Ron
• 22:20   Re: Ways to change a database collation with removing duplicates Erik Wienhold
• 23:53   Re: Ways to change a database collation with removing duplicates Tom Lane

12 March 2023

• 00:23   Re: LOG: could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat" Erik Wienhold
• 08:52   Re: Ways to change a database collation with removing duplicates Alexey Murz Korepov
• 16:47   Re: Tooling for per table autovacuum tuning Laurenz Albe
• 19:56   Re: Tooling for per table autovacuum tuning Wolfgang Wilhelm
• 23:34   Re: Tooling for per table autovacuum tuning Joseph Hammerman
• 23:43   Re: Tooling for per table autovacuum tuning MichaelDBA

13 March 2023

• 00:03   Re: Tooling for per table autovacuum tuning Ron
• 00:36   Re: Tooling for per table autovacuum tuning Matt Pearson
• 08:58   Re: Tooling for per table autovacuum tuning Laurenz Albe
• 13:09   Re: Tooling for per table autovacuum tuning Alvaro Herrera
• 14:55   Buffermapping LWLock Contention Amine Tengilimoglu
• 15:56   Re: Tooling for per table autovacuum tuning Ron

14 March 2023

• 02:46   Setup System_Stats extention on Windows Mohamed Raafat
• 10:25   Oracle characterset and collation to Postgresql James Pang (chaolpan)
• 19:01   CRUD tool? Rich Pixley
• 19:46   Re: CRUD tool? Tim
• 20:19   Re: CRUD tool? Mónica Gamarra
• 20:28   Re: CRUD tool? Thomas Kellerer

15 March 2023

• 00:31   Re: Oracle characterset and collation to Postgresql Laurenz Albe
• 20:24   Automatic partition creation? Sbob
• 21:20   Re: Automatic partition creation? Rui DeSousa
• 21:53   Re: Automatic partition creation? Keith Fiske

19 March 2023

• 10:28   Re: Upgrading Patroni from 2.1.x to 3.0.1 ? Victor Sudakov
• 12:02   How to pass idle_session_timeout in postgres docker in a compose file? Debraj Manna

20 March 2023

• 00:36   PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl richard coleman
• 01:26   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl Tom Lane
• 03:27   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl MichaelDBA
• 05:49   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl richard coleman
• 10:31   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl Holger Jakobs
• 16:59   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl richard coleman
• 17:02   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl richard coleman
• 17:06   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl MichaelDBA
• 17:30   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl Holger Jakobs
• 17:36   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl Thomas Kellerer
• 17:48   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl richard coleman
• 17:49   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl MichaelDBA
• 18:10   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl Tom Lane
• 18:48   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl richard coleman
• 19:10   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl Thomas Kellerer
• 19:39   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl richard coleman
• 19:50   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl Ron Johnson
• 19:56   pg_cron: cron.schedule_in_database is working without pg_hba.conf entry!? Zwettler Markus (OIZ)

21 March 2023

• 09:15   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl jian he
• 16:58   Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl Keith

23 March 2023

• 02:57   Logical Replication Setup using one replication slot per table? Sbob
• 03:10   Re: Logical Replication Setup using one replication slot per table? SOLVED Sbob
• 12:10   Prepared statements generating a lot of temp files. Karthik Krishnakumar
• 12:13   Re: Prepared statements generating a lot of temp files. Michaeldba@sqlexec.com
• 12:59   Re: Prepared statements generating a lot of temp files. Karthik Krishnakumar
• 13:03   Re: Prepared statements generating a lot of temp files. MichaelDBA
• 13:21   Re: Prepared statements generating a lot of temp files. Karthik Krishnakumar
• 13:26   Re: Prepared statements generating a lot of temp files. MichaelDBA
• 13:50   Re: Prepared statements generating a lot of temp files. Karthik Krishnakumar
• 13:54   Re: Prepared statements generating a lot of temp files. MichaelDBA
• 21:03   PL/pgSQL function to run DDL on a remote server/cluster? Sbob
• 21:52   Re: PL/pgSQL function to run DDL on a remote server/cluster? Laurenz Albe
• 22:15   Re: PL/pgSQL function to run DDL on a remote server/cluster? Tom Lane
• 23:16   Re: PL/pgSQL function to run DDL on a remote server/cluster? Laurenz Albe
• 23:27   Re: PL/pgSQL function to run DDL on a remote server/cluster? Sbob

25 March 2023

• 03:55   Debian PostgreSQL 15 pg_createcluster - could not open collator for locale Matt Gibbins
• 19:39   Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale Erik Wienhold

26 March 2023

• 02:06   Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale Matt Gibbins
• 07:30   Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale Erik Wienhold
• 11:26   Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale Matt Gibbins
• 12:37   Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale Erik Wienhold
• 14:41   Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale Matt Gibbins
• 20:39   Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale Erik Wienhold

27 March 2023

• 19:32   Installing PostGreSQLon Redhat Linux - Help needed Sendhu Sendhu
• 20:10   Re: Installing PostGreSQLon Redhat Linux - Help needed Matti Linnanvuori
• 20:41   Re: Installing PostGreSQLon Redhat Linux - Help needed Ron
• 20:41   Re: Installing PostGreSQLon Redhat Linux - Help needed Servet Kahraman Turan
• 21:31   Re: Installing PostGreSQLon Redhat Linux - Help needed Sendhu Sendhu
• 21:41   Re: Installing PostGreSQLon Redhat Linux - Help needed Ron
• 21:51   Re: Installing PostGreSQLon Redhat Linux - Help needed Sendhu Sendhu
• 22:17   Re: Installing PostGreSQLon Redhat Linux - Help needed Servet Kahraman Turan
• 23:50   Re: Installing PostGreSQLon Redhat Linux - Help needed Holger Jakobs

28 March 2023

• 00:23   Re: Installing PostGreSQLon Redhat Linux - Help needed Ron
• 01:07   Re: Installing PostGreSQLon Redhat Linux - Help needed Sendhu Sendhu
• 05:33   Re: Installing PostGreSQLon Redhat Linux - Help needed Ron
• 08:01   DBMS_LDAP equivalent utility in PostgreSQL Mukesh Rajpurohit
• 08:35   How can we log the sequential scan of queries at DB level badrinadh p
• 08:40   facing issues in downloading of packages in pgadmin4 parth ratra
• 08:41   Re: How can we log the sequential scan of queries at DB level Rui DeSousa
• 17:00   Re: Installing PostGreSQLon Redhat Linux - Help needed Sendhu Sendhu
• 17:02   Re: Installing PostGreSQLon Redhat Linux - Help needed Imran Khan

29 March 2023

• 04:19   Re: DBMS_LDAP equivalent utility in PostgreSQL Dan Smith
• 04:55   Re: DBMS_LDAP equivalent utility in PostgreSQL Mukesh Rajpurohit
• 17:16   Host name in .pgpass Ron
• 17:28   Re: Host name in .pgpass Ron

30 March 2023

• 12:50   pg15 and VM snapshots with pg_backup_start oernii+pg@axonpro.sk
• 13:45   Re: pg15 and VM snapshots with pg_backup_start Laurenz Albe
• 13:59   Re: pg15 and VM snapshots with pg_backup_start Stephen Frost