diff options
Diffstat (limited to 'contrib/vacuumlo')
-rw-r--r-- | contrib/vacuumlo/Makefile | 6 | ||||
-rw-r--r-- | contrib/vacuumlo/README | 38 | ||||
-rw-r--r-- | contrib/vacuumlo/vacuumlo.c | 2 |
3 files changed, 4 insertions, 42 deletions
diff --git a/contrib/vacuumlo/Makefile b/contrib/vacuumlo/Makefile index 88fd8cfb7e..2c56e542fc 100644 --- a/contrib/vacuumlo/Makefile +++ b/contrib/vacuumlo/Makefile @@ -1,5 +1,5 @@ # -# $Header: /cvsroot/pgsql/contrib/vacuumlo/Makefile,v 1.4 2000/06/16 18:59:30 momjian Exp $ +# $Header: /cvsroot/pgsql/contrib/vacuumlo/Makefile,v 1.5 2000/06/19 13:54:50 momjian Exp $ # TOPDIR=../.. @@ -10,7 +10,7 @@ NAME = vacuumlo PROGRAM = $(NAME) OBJS = $(NAME).o -DOCS = README +DOCS = README.$(NAME) SQLS = BINS = $(PROGRAM) EXAMPLES= @@ -29,7 +29,7 @@ install: install_doc install_bin install_doc: for inst_file in $(DOCS); do \ - $(INSTALL) $(INSTL_LIB_OPTS) $$inst_file $(CONTRIB_DOCDIR)/$(DOCS).$(NAME); \ + $(INSTALL) $(INSTL_LIB_OPTS) $$inst_file $(CONTRIB_DOCDIR); \ done install_bin: diff --git a/contrib/vacuumlo/README b/contrib/vacuumlo/README index 2c3c93de15..e69de29bb2 100644 --- a/contrib/vacuumlo/README +++ b/contrib/vacuumlo/README @@ -1,38 +0,0 @@ -$Header: /cvsroot/pgsql/contrib/vacuumlo/Attic/README,v 1.1 1999/04/10 16:48:04 peter Exp $ - -This is a simple utility that will remove any orphaned large objects out of a -PostgreSQL database. - -Compiling --------- - -Simply run make. A single executable "vacuumlo" is created. - -Useage ------- - -vacuumlo [-v] database [db2 ... dbn] - -The -v flag outputs some progress messages to stdout. - -Method ------- - -First, it builds a temporary table which contains all of the oid's of the -large objects in that database. - -It then scans through any columns in the database that are of type 'oid', and -removes any entries from the temporary table. - -Finally, it runs through the first table, and removes from the second table, any -oid's it finds. What is left are the orphans, and these are removed. - -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 backed as a "vacuum lo" command -in a later release. - -Peter Mount <peter@retep.org.uk> -http://www.retep.org.uk -March 21 1999 - -Committed April 10 1999 Peter diff --git a/contrib/vacuumlo/vacuumlo.c b/contrib/vacuumlo/vacuumlo.c index ac41d551c3..3f2c592c09 100644 --- a/contrib/vacuumlo/vacuumlo.c +++ b/contrib/vacuumlo/vacuumlo.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/contrib/vacuumlo/vacuumlo.c,v 1.4 2000/06/15 18:55:31 momjian Exp $ + * $Header: /cvsroot/pgsql/contrib/vacuumlo/vacuumlo.c,v 1.5 2000/06/19 13:54:50 momjian Exp $ * *------------------------------------------------------------------------- */ |