Consider running pg_repack in a Docker container on ECS/Fargate etc if you don't want to spin up an EC2 instance. I think a free t2.micro sort of EC2 instance would be plenty to repack against an RDS host, might want to spring for a few cores to make the indexes faster...
On Mon, Jul 22, 2024 at 11:29 PM khan Affan <bawag773@xxxxxxxxx> wrote:
As stated before, security constraints prevent pg_repack from being executed directly in an RDS PostgreSQL environment.
Because RDS maintains a secure environment, installing custom extensions like pg_repack is restricted.
pg_cron in RDS is intended to be used for scheduling internal PostgreSQL functions or operations; it is not intended to be used with external utilities such as pg_repack.The alternative approach is to export your database schema and data (excluding large objects) to an external PostgreSQL instance, run pg_repack on the external instance to reclaim space, and then import the cleaned data back into your RDS instance.
Thanks & regards
Muhammad Affan (아판)
PostgreSQL Technical Support Engineer / Pakistan R&D
Interlace Plaza 4th floor Twinhub office 32 I8 Markaz, Islamabad, Pakistan On Tue, Jul 23, 2024 at 10:53 AM Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx> wrote:We are planning to run pg repack from pg_cron in RDS environment not in EC2 help me schedule job pg_repack
On Tue, Jul 23, 2024, 11:13 AM khan Affan <bawag773@xxxxxxxxx> wrote:Hi
First, use Vaccum Full or Vaccumlo if storing largeobject for clearing bloat, If you are running a script, dump it outside the RDS, such as you can dump it to EC2, and then apply PG_repack on the schema and then restore it to RDS.
As you know such services are not available on RDS.
https://www.postgresql.org/docs/current/vacuumlo.htmlhttps://www.postgresql.org/docs/current/sql-vacuum.html
Thanks & regards
Muhammad Affan (아판)
PostgreSQL Technical Support Engineer / Pakistan R&D
Interlace Plaza 4th floor Twinhub office 32 I8 Markaz, Islamabad, Pakistan On Tue, Jul 23, 2024 at 10:22 AM Sathish Reddy <sathishreddy.postgresql@xxxxxxxxx> wrote:HiI am trying to schedule pg_repack from pg_cron in RDS postgres environment on avoid the bash on host EC2 to run run directly with in postgres instance.it getting successful but not clearing bloat by using repack fuction in pg_repack extension.please help on these to sort out .ThanksSathish Reddy
Wells Oliver
wells.oliver@xxxxxxxxx
wells.oliver@xxxxxxxxx
