HTTPS clone URL
Subversion checkout URL
REL2_0B REL6_4 REL6_5_PATCHES REL7_0_PATCHES REL7_1_STABLE REL7_2_STABLE REL7_3_STABLE REL7_4_STABLE REL8_0_STABLE REL8_1_STABLE REL8_2_STABLE REL8_3_STABLE REL8_4_STABLE REL8_5_ALPHA1_BRANCH REL8_5_ALPHA2_BRANCH REL8_5_ALPHA3_BRANCH REL9_0_ALPHA4_BRANCH REL9_0_ALPHA5_BRANCH REL9_0_STABLE REL9_1_STABLE REL9_2_STABLE REL9_3_STABLE REL9_4_STABLE REL9_5_STABLE Release_1_0_3 WIN32_DEV ecpg_big_bison master
Nothing to show
Nothing to show
Fetching latest commit...
Cannot retrieve the latest commit at this time.
|Failed to load latest commit information.|
$PostgreSQL: pgsql/contrib/vacuumlo/README.vacuumlo,v 1.5 2005/06/23 00:06:37 tgl Exp $ This is a simple utility that will remove any orphaned large objects out of a PostgreSQL database. An orphaned LO is considered to be any LO whose OID does not appear in any OID data column of the database. If you use this, you may also be interested in the lo_manage trigger in contrib/lo. lo_manage is useful to try to avoid creating orphaned LOs in the first place. Compiling -------- Simply run make. A single executable "vacuumlo" is created. Usage ----- vacuumlo [options] database [database2 ... databasen] All databases named on the command line are processed. Available options include: -v Write a lot of progress messages -n Don't remove large objects, just show what would be done -U username Username to connect as -W Prompt for password -h hostname Database server host -p port Database server port Method ------ First, it builds a temporary table which contains all of the OIDs of the large objects in that database. It then scans through all columns in the database that are of type "oid" or "lo", and removes matching entries from the temporary table. The remaining entries in the temp table identify orphaned LOs. These are removed. Notes ----- I decided to place this in contrib as it needs further testing, but hopefully, this (or a variant of it) would make it into the backend as a "vacuum lo" command in a later release. Peter Mount <firstname.lastname@example.org> http://www.retep.org.uk March 21 1999 Committed April 10 1999 Peter