I tried to CREATE EXTENSION vacuumlo, but it fails with the following message:

"/usr/pgsql-9.4/share/extension/vacuumlo.control": no such file or directory.

I can see other .sql and .control files in that directory, and I was able to CREATE EXTENSION pgstattuple from it, but the vacuumlo files are indeed missing.

This is a VERY old server, and neither I nor others at the client have any PG experience (those that configured the server and apps are long gone).

I was told to use this tool to determine pg_largeobject bloat on this thread:

pg_largeobject bloat

How can I compile/use vacuumlo if the code is not in that directory?

  • 1
    Vacumlo is not an extension: postgresql.org/docs/9.4/vacuumlo.html it's a binary that should have been installed when the contrib module was installed
    – user1822
    Commented Feb 18, 2022 at 8:40
  • Thanks for the answer! Sadly I cannot see how to MARK it as answered. I will check the forum docs to see if I can figure it out.
    – TheSQLGuru
    Commented Feb 18, 2022 at 14:26


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.