RE: vacuumlo

Morning.

Thanks for all the replies.

What I did to remove these files was to backup of the DB, drop the DB and then I restored the DB.

Regards
Ian

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Sent: Thursday, 02 September 2021 09:33
To: Atul Kumar <akumar14871(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>; Ian Dauncey <Ian(dot)Dauncey(at)bankzero(dot)co(dot)za>; pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: vacuumlo

External email - treat with caution
Le jeu. 2 sept. 2021 à 07:11, Atul Kumar <akumar14871(at)gmail(dot)com<mailto:akumar14871(at)gmail(dot)com>> a écrit :
Hi,

Don’t you think it as a drawback of postgres that such temporary files don’t get deleted automatically once the transaction gets committed or rolled back .

They are automatically removed in case of a proper commit or rollback. They aren't in case of a crash.

Could you suggest a good permanent solution for such case.

You should try https://github.com/bdrouvot/pg_orphaned<https://github.com/bdrouvot/pg_orphaned> to find the list of orphaned files. It does a pretty good job at it.

--
Guillaume.

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast, a leader in email security and cyber resilience. Mimecast integrates email defenses with brand protection, security awareness training, web security, compliance and other essential capabilities. Mimecast helps protect large and small organizations from malicious activity, human error and technology failure; and to lead the movement toward building a more resilient world. To find out more, visit our website.