search

dataegret / pgcompacttable

BSD 3-Clause "New" or "Revised" License
314 stars 48 forks source link

RDS support #47

Open brauliobo opened 2 years ago

brauliobo commented 2 years ago

Do you know if it is feasible in any way to use pgcompacttable in AWS RDS-managed PostgreSQL?

alexius2 commented 1 year ago

Hello, as far as I know amazon doesn't allow to change session_replication_role. It's possible to run it if comment that line: https://github.com/dataegret/pgcompacttable/blob/master/bin/pgcompacttable#L1771 But that might be dangerous if table has any update triggers since pgcompacctable might fire them. Perhaps we could check that in code and allow to run it with default session_replication_role on tables without update triggers.