how to remove large objects in postgres

Question

should I call lo_unlink ? A delete didn't remove the object from pg_largeobject.

pards · Accepted Answer · 2011-06-10 20:12:09Z

15

You can also clean up large objects from the command-line using

$ vacuumlo -U username databasename

answered Jun 10, 2011 at 20:12

pards

1,18615 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

theherk Over a year ago

This is great. It can be found in package postgres-contrib on Fedora distributions.

1737973 Over a year ago

Sadly AWS RDS is not currently allowing it. But find here my workaround for that disallowance.

kappa Over a year ago

Actually vacuumlo can connect to a remote database instance

Magnus Hagander · Accepted Answer · 2009-08-01 06:59:50Z

5

Yes, you need to explicitly call lo_unlink(). I assume you just DELETEd the row that held a reference to it, and that will not remove the actual large object.

If you only ever reference it from the same place, you can always create a trigger to do it automatically for you.

answered Aug 1, 2009 at 6:59

Magnus Hagander

25.5k6 gold badges60 silver badges44 bronze badges

Collectives™ on Stack Overflow

how to remove large objects in postgres

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related