pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PL/pgSQL function to run DDL on a remote server/cluster?
  2023-03-23 18:03 UTC  Sbob <sbob@quadratum-braccas.com>
` Re: PL/pgSQL function to run DDL on a remote server/cluster?
  2023-03-23 18:52 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: PL/pgSQL function to run DDL on a remote server/cluster?
  2023-03-23 19:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: PL/pgSQL function to run DDL on a remote server/cluster?
  2023-03-23 20:16 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: PL/pgSQL function to run DDL on a remote server/cluster?
  2023-03-23 20:27 UTC  Sbob <sbob@quadratum-braccas.com>
  [5+ messages in thread]

Prepared statements generating a lot of temp files.
  2023-03-23 09:10 UTC  Karthik Krishnakumar <karthikk@zohocorp.com>
` Re: Prepared statements generating a lot of temp files.
  2023-03-23 09:13 UTC  Michaeldba@sqlexec.com <Michaeldba@sqlexec.com>
` Re: Prepared statements generating a lot of temp files.
  2023-03-23 09:59 UTC  Karthik Krishnakumar <karthikk@zohocorp.com>
` Re: Prepared statements generating a lot of temp files.
  2023-03-23 10:03 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Prepared statements generating a lot of temp files.
  2023-03-23 10:21 UTC  Karthik Krishnakumar <karthikk@zohocorp.com>
` Re: Prepared statements generating a lot of temp files.
  2023-03-23 10:26 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Prepared statements generating a lot of temp files.
  2023-03-23 10:50 UTC  Karthik Krishnakumar <karthikk@zohocorp.com>
` Re: Prepared statements generating a lot of temp files.
  2023-03-23 10:54 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
  [8+ messages in thread]

Logical Replication Setup using one replication slot per table?
  2023-03-22 23:57 UTC  Sbob <sbob@quadratum-braccas.com>
` Re: Logical Replication Setup using one replication slot per table? SOLVED
  2023-03-23 00:10 UTC  Sbob <sbob@quadratum-braccas.com>
  [2+ messages in thread]

PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-19 21:36 UTC  richard coleman <rcoleman.ascentgl@gmail.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-19 22:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 00:27 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 02:49 UTC  richard coleman <rcoleman.ascentgl@gmail.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 06:33 UTC  Edward J. Sabol <edwardjsabol@gmail.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 07:31 UTC  Holger Jakobs <holger@jakobs.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 13:59 UTC  richard coleman <rcoleman.ascentgl@gmail.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 14:02 UTC  richard coleman <rcoleman.ascentgl@gmail.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 14:06 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 14:30 UTC  Holger Jakobs <holger@jakobs.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 14:36 UTC  Thomas Kellerer <shammat@gmx.net>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 14:48 UTC  richard coleman <rcoleman.ascentgl@gmail.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 14:49 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 15:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 15:48 UTC  richard coleman <rcoleman.ascentgl@gmail.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 16:10 UTC  Thomas Kellerer <shammat@gmx.net>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 16:39 UTC  richard coleman <rcoleman.ascentgl@gmail.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-20 16:50 UTC  Ron Johnson <ronljohnsonjr@gmail.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-21 06:15 UTC  jian he <jian.universality@gmail.com>
` Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  2023-03-21 13:58 UTC  Keith <keith@keithf4.com>
  [20+ messages in thread]

pg_cron: cron.schedule_in_database is working without pg_hba.conf entry!?
  2023-03-20 16:56 UTC  Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>

How to pass idle_session_timeout in postgres docker in a compose file?
  2023-03-19 09:02 UTC  Debraj Manna <subharaj.manna@gmail.com>

Upgrading Patroni from 2.1.x to 3.0.1 ?
  2023-03-06 09:05 UTC  Victor Sudakov <vas@sibptus.ru>
` Re: Upgrading Patroni from 2.1.x to 3.0.1 ?
  2023-03-19 07:28 UTC  Victor Sudakov <vas@sibptus.ru>
  [2+ messages in thread]

Automatic partition creation?
  2023-03-15 17:24 UTC  Sbob <sbob@quadratum-braccas.com>
` Re: Automatic partition creation?
  2023-03-15 18:20 UTC  Rui DeSousa <rui@crazybean.net>
` Re: Automatic partition creation?
  2023-03-15 18:53 UTC  Keith Fiske <keith.fiske@crunchydata.com>
  [3+ messages in thread]

Oracle characterset and collation to Postgresql
  2023-03-14 07:25 UTC  James Pang (chaolpan) <chaolpan@cisco.com>
` Re: Oracle characterset and collation to Postgresql
  2023-03-14 21:31 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [2+ messages in thread]

CRUD tool?
  2023-03-14 16:01 UTC  Rich Pixley <rich.pixley@hayden.ai>
` Re: CRUD tool?
  2023-03-14 16:46 UTC  Tim <timfosho@gmail.com>
` Re: CRUD tool?
  2023-03-14 17:19 UTC  Mónica Gamarra <monica.gamarra@gmail.com>
` Re: CRUD tool?
  2023-03-14 17:28 UTC  Thomas Kellerer <shammat@gmx.net>
  [4+ messages in thread]

Setup System_Stats extention on Windows
  2023-03-13 23:46 UTC  Mohamed Raafat <mohamed.raafat.abdelkader@gmail.com>

Tooling for per table autovacuum tuning
  2023-03-11 18:49 UTC  Joseph Hammerman <joe.hammerman@datadoghq.com>
` Re: Tooling for per table autovacuum tuning
  2023-03-11 19:07 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Tooling for per table autovacuum tuning
  2023-03-12 13:47 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Tooling for per table autovacuum tuning
  2023-03-12 16:56 UTC  Wolfgang Wilhelm <wolfgang20121964@yahoo.de>
` Re: Tooling for per table autovacuum tuning
  2023-03-12 20:34 UTC  Joseph Hammerman <joe.hammerman@datadoghq.com>
` Re: Tooling for per table autovacuum tuning
  2023-03-12 20:43 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Tooling for per table autovacuum tuning
  2023-03-12 21:03 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Tooling for per table autovacuum tuning
  2023-03-12 21:36 UTC  Matt Pearson <mpearson2@pythian.com>
` Re: Tooling for per table autovacuum tuning
  2023-03-13 05:58 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Tooling for per table autovacuum tuning
  2023-03-13 10:09 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Tooling for per table autovacuum tuning
  2023-03-13 12:56 UTC  Ron <ronljohnsonjr@gmail.com>
  [11+ messages in thread]

Buffermapping LWLock Contention
  2023-03-13 11:55 UTC  Amine Tengilimoglu <aminetengilimoglu@gmail.com>

Ways to change a database collation with removing duplicates
  2023-03-11 18:23 UTC  Alexey Murz Korepov <murznn@gmail.com>
` Re: Ways to change a database collation with removing duplicates
  2023-03-11 19:20 UTC  Erik Wienhold <ewie@ewie.name>
` Re: Ways to change a database collation with removing duplicates
  2023-03-11 20:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Ways to change a database collation with removing duplicates
  2023-03-12 05:52 UTC  Alexey Murz Korepov <murznn@gmail.com>
  [4+ messages in thread]

LOG: could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat"
  2023-03-10 17:39 UTC  Erik Wienhold <ewie@ewie.name>
` Re: LOG: could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat"
  2023-03-10 18:06 UTC  Holger Jakobs <holger@jakobs.com>
` Re: LOG: could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat"
  2023-03-11 21:23 UTC  Erik Wienhold <ewie@ewie.name>
  [3+ messages in thread]

postgresql to Oracle database migration
  2023-03-09 09:46 UTC  Renjith Gk <renjithgk@gmail.com>
` Re: postgresql to Oracle database migration
  2023-03-09 09:48 UTC  Holger Jakobs <holger@jakobs.com>
` Re: postgresql to Oracle database migration
  2023-03-09 13:08 UTC  Eric Raskin <eraskin@paslists.com>
` Re: postgresql to Oracle database migration
  2023-03-09 13:09 UTC  Sumit Sengupta <ssengupta@hotmail.com>
` Re: postgresql to Oracle database migration
  2023-03-09 17:49 UTC  Jwiencek3 <jwiencek3@comcast.net>
` Re: postgresql to Oracle database migration
  2023-03-09 19:41 UTC  Piergiorgio Valli <piervalli@gmail.com>
  [6+ messages in thread]

Malformed array literal in goin from jsonb to real[]
  2023-03-09 15:19 UTC  Wells Oliver <wells.oliver@gmail.com>
` Re: Malformed array literal in goin from jsonb to real[]
  2023-03-09 16:05 UTC  Erik Wienhold <ewie@ewie.name>
` Re: Malformed array literal in goin from jsonb to real[]
  2023-03-09 16:12 UTC  Erik Wienhold <ewie@ewie.name>
  [3+ messages in thread]

database collation   "C" and "C.LATIN1"
  2023-03-09 08:22 UTC  James Pang (chaolpan) <chaolpan@cisco.com>
` Re: database collation   "C" and "C.LATIN1"
  2023-03-09 08:29 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` RE: database collation   "C" and "C.LATIN1"
  2023-03-09 08:31 UTC  James Pang (chaolpan) <chaolpan@cisco.com>
` RE: database collation   "C" and "C.LATIN1"
  2023-03-09 08:37 UTC  James Pang (chaolpan) <chaolpan@cisco.com>
` Re: database collation   "C" and "C.LATIN1"
  2023-03-09 12:04 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: database collation "C" and "C.LATIN1"
  2023-03-09 14:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

PostgreSQL uses huge amount of memory
  2023-03-08 13:04 UTC  Mauricio Martini <martini.mauricio@hotmail.com>
` Re: PostgreSQL uses huge amount of memory
  2023-03-08 13:29 UTC  Neimar Sierota <neimarsmo@gmail.com>
` Re: PostgreSQL uses huge amount of memory
  2023-03-08 16:13 UTC  Scott Ribe <scott_ribe@elevated-dev.com>
` Re: PostgreSQL uses huge amount of memory
  2023-03-08 16:48 UTC  Fernando Hevia <fhevia@gmail.com>
` Re: PostgreSQL uses huge amount of memory
  2023-03-08 18:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Replication between two different versions
  2023-03-07 15:42 UTC  Erik Serrano <eserranos@gmail.com>
` Re: Replication between two different versions
  2023-03-07 16:03 UTC  Jwiencek3 <jwiencek3@comcast.net>
` Re: Replication between two different versions
  2023-03-07 16:35 UTC  J T <jorge.torralba@gmail.com>
` Re: Replication between two different versions
  2023-03-07 16:44 UTC  Erik Serrano <eserranos@gmail.com>
` Re: Replication between two different versions
  2023-03-07 16:49 UTC  J T <jorge.torralba@gmail.com>
` Re: Replication between two different versions
  2023-03-08 00:56 UTC  Abhishek Singh <abhi.singh.solanki@gmail.com>
  [6+ messages in thread]

Migrating tables to new schema with minimal downtime
  2023-03-06 21:00 UTC  Joseph Hammerman <joe.hammerman@datadoghq.com>
` Re: Migrating tables to new schema with minimal downtime
  2023-03-07 06:29 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Migrating tables to new schema with minimal downtime
  2023-03-07 11:59 UTC  hubert depesz lubaczewski <depesz@depesz.com>
  [3+ messages in thread]

replication origin advance in pglogical extension
  2023-03-03 07:37 UTC  srinivas oguri <srinivasoguri7@gmail.com>

New PG14 server won't start with >2GB shared_buffers
  2023-02-25 02:08 UTC  Chris Hoover <chrish@aweber.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 02:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 03:29 UTC  Chris Hoover <chrish@aweber.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 10:25 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 10:33 UTC  JP Pozzi <jpp@jppozzi.dyndns.org>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 13:07 UTC  Chris Hoover <chrish@aweber.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 14:05 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 14:49 UTC  Kenneth Marshall <ktm@rice.edu>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 14:51 UTC  Chris Hoover <chrish@aweber.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 14:51 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 14:53 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 14:55 UTC  Chris Hoover <chrish@aweber.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 14:57 UTC  Chris Hoover <chrish@aweber.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 15:16 UTC  Evan Rempel <erempel@uvic.ca>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 16:35 UTC  Carlos Martinez <camarti@gmail.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 16:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 17:55 UTC  Tim <timfosho@gmail.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-25 18:38 UTC  Charles Bowers <charles.bowers@gmail.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-26 22:01 UTC  Chris Hoover <chrish@aweber.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-27 00:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-02-27 16:25 UTC  Chris Hoover <chrish@aweber.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-03-02 21:53 UTC  Chris Hoover <chrish@aweber.com>
` Re: New PG14 server won't start with >2GB shared_buffers
  2023-03-02 21:56 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
  [23+ messages in thread]

Forcasting in Postgresql
  2023-03-01 07:48 UTC  Govardhan .G <govardhansrr@gmail.com>
` Re: Forcasting in Postgresql
  2023-03-01 16:57 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Forcasting in Postgresql
  2023-03-02 16:25 UTC  Govardhan .G <govardhansrr@gmail.com>
` RE: Forcasting in Postgresql
  2023-03-02 17:47 UTC  dave@davebolt.co.uk
` Re: Forcasting in Postgresql
  2023-03-02 17:51 UTC  Govardhan .G <govardhansrr@gmail.com>
  [5+ messages in thread]

psql terminates on first error
  2023-03-02 11:53 UTC  Holger Jakobs <holger@jakobs.com>
` Re: psql terminates on first error
  2023-03-02 12:32 UTC  Erik Wienhold <ewie@ewie.name>
` Re: psql terminates on first error
  2023-03-02 12:44 UTC  Holger Jakobs <holger@jakobs.com>
` Re: psql terminates on first error
  2023-03-02 12:48 UTC  Thomas Kellerer <shammat@gmx.net>
` Re: psql terminates on first error
  2023-03-02 13:30 UTC  Holger Jakobs <holger@jakobs.com>
` Re: psql terminates on first error
  2023-03-02 13:45 UTC  Erik Wienhold <ewie@ewie.name>
` Re: psql terminates on first error
  2023-03-02 14:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: psql terminates on first error
  2023-03-02 14:36 UTC  Holger Jakobs <holger@jakobs.com>
  [8+ messages in thread]


[next (older)]

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox