| From: | Rahul Saha <rahul(dot)blooming(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | [Admin] Deleting Orphan Relfilenode |
| Date: | 2018-07-16 12:10:55 |
| Message-ID: | 33986830-A802-43DD-AABB-6035B37251EC@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Experts,
Background - PG version 9.4
Running in Linux Rhel
We have a scenario where we ran Vacuum Full (2 TB Table)but due to some reason Vacuum Full failed.
These have let almost 1 TB orphan Relfilenodes inside base directory under the concern database which does not map with pg_class.
For example - Select * from pg_class where relfilenode = 123456. It does not return any row but those relfilenode exist inside base.
It would be great if you can suggest how to remove those orphan files. I know definitely manually deleting is not suggested so thought to know your suggestions.
Kind Regards,
Rahul Saha
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-07-16 15:18:10 | Re: [Admin] Deleting Orphan Relfilenode |
| Previous Message | Mariel Cherkassky | 2018-07-15 08:47:49 | questions regarding setup a new barman server |