Stack Overflow
Stack Overflow

Questions tagged [pg-repack]

13 questions
9
votes
2 answers

pg_repack version mismatch after maintenance on cloud sql (GCP)

I have a cloud-sql postgres11 instance on GCP and use pg_repack cron for cleaning my database. I've noticed that since last maintenance occurred (7th of March 21) I cannot perform a repack. When tried to manually run a repack I encountered this…
Omri Shani
  • 91
  • 2
3
votes
1 answer

does pg_repack work for materialized view

Does pg_repack work for materialized views on postgres v11? I am running into issues installing pg_repack client on my server and hence unable to check myself. As per the documentation it says "pg_repack is a PostgreSQL extension which lets you…
nmakb
  • 1,069
  • 1
  • 17
  • 35
1
vote
0 answers

How to use pg_repack extension on Azure PostgreSQL

How to use pg_repack extension on Azure PostgreSQL? Here is the link of with the PostgreSQL extension and while there is documentation for some of them, the documentation for pg_repack is missing. It is pointing to official documentation here but I…
Christian
  • 420
  • 1
  • 8
  • 15
1
vote
0 answers

Recommended way of invoking pg_repack on google cloud

We have installed pg_repack on our postgresql database. What is the best way to periodically invoke the pg_repack command using GCP infrastructure? We tried running it using Cloud Run, but the 1 hour time limit often means that it times out before…
Felix Qvist
  • 11
  • 3
1
vote
1 answer

Clear materialized view in PostgreSQL

I had a table with size of 10gb and materialized view on it (without join and etc.) of size 10gb too. I used pg_repack on table and its size decreased to 660mb. But after refresh materialized view concurrently and size of mat view still 10 gb. When…
yuoggy
  • 97
  • 1
  • 10
1
vote
0 answers

error with pg_restore while creating default acl

got this error when doing a pg_restore. dump & restore are done using same master account in both source/target. I see its related to pg_repack, but cannot figure out why this error is happening during restore. Please advise pg_restore: creating…
Falcon
  • 47
  • 6
1
vote
1 answer

pg_repack is running for a full week - is this expected behavior?

I kicked off pg_repack 7 days ago and it's still running. I haven't really seen any examples take this long anywhere in my googling... Is this typical for my setup (see below details)? Should I let it keep going? Or should I cancel? And if I cancel,…
Markus
  • 11
  • 1
1
vote
2 answers

ERROR: pg_repack failed with error: ERROR: column "relhasoids" does not exist

I'm using pg_repack extension to perform full vacuum on my database tables. Till now , I was using postgres-11. Now, I have upgraded it to postgres-12.4. After upgrading when I started doing full vacuum again- I got below error: ERROR: pg_repack…
Channa
  • 742
  • 17
  • 28
0
votes
1 answer

How to install and run pg_reack on postgres with pg_reack version v1.4.8?

I recently upgraded PostgreSQL from v12.14 to v15.2. During the upgrade, I also had to update the pg_repack extension from v1.4.5 to v1.4.8. However, when I attempted to run pg_repack, I encountered the error: "pg_repack failed with error: program…
Akshay Bhadange
  • 73
  • 11
0
votes
1 answer

In "pg_repack" I faced an Error : cannot update table "table_123" because it does not have a replica identity and publishes updates

ERROR: query failed: ERROR: cannot update table "table_123" because it does not have a replica identity and publishes updates HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE. CONTEXT: SQL statement "UPDATE…
MANJULA KURAPATI
  • 1
0
votes
0 answers

Unable to setup pg_repack in ubuntu22.04.1 LTS

I want to perform pg_repack in remote postgres server. pg_repack is used to remove bloat from PostgreSQL. I am following this for reference: https://reorg.github.io/pg_repack/#installation After installing pgxn, we need to install pg_repack. It's…
Prince Kushwaha
  • 1
  • 1
0
votes
1 answer

Invoking pg_repack extension in gcp cloud sql

We have installed the pg_repack extension in Cloud SQL by following the guide: https://cloud.google.com/sql/docs/postgres/extensions#pg_repack The installation of the extension works fine and it shows up in the list of extensions when running…
Norla
  • 9
  • 4
0
votes
0 answers

installing pg_repack fails with pgut/pgut.h:13:10: fatal error: c.h: No such file or directory

In am installing pg_repack with "sudo pgxn install pg_repack" and it end INFO: best version: pg_repack 1.4.7 INFO: saving /tmp/tmp7qn9rttz/pg_repack-1.4.7.zip INFO: unpacking: /tmp/tmp7qn9rttz/pg_repack-1.4.7.zip INFO: building extension make[1]:…
ryaliscs
  • 123
  • 9