Seeking Advice on Table Alterations without Downtime in PostgreSQL

From: Veerendra Pulapa <veerendra(dot)pulapa(at)ashnik(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Seeking Advice on Table Alterations without Downtime in PostgreSQL
Date: 2023-07-17 16:31:55
Message-ID: SE1P216MB2309B830057A3DFA53D938E1F13BA@SE1P216MB2309.KORP216.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear PostgreSQL Community,

I am writing to seek guidance on performing table alterations without incurring downtime. As a member of the community, I would greatly appreciate any insights or best practices you could provide in this regard.

Specifically, I am interested in techniques or approaches that allow for seamless alterations such as adding/removing columns, modifying column data types, renaming columns, and altering constraints.

Thank you for your time and support. Your expertise will be highly valuable to me.

Br,
Veerendra Pulapa
+91-9949349894

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-07-17 16:47:43 Re: Seeking Advice on Table Alterations without Downtime in PostgreSQL
Previous Message Bert 2023-07-17 16:20:56 Re: PostgreSQL 12 VS PostgreSQL 15