File Manager

Hackfut Security File Manager

Current Path: /opt/td-agent/embedded/share/man/man1

opt / td-agent / embedded / share / man / man1 /

📁 ..
📄 clusterdb.1(5.77 KB)
📄 createdb.1(7.26 KB)
📄 createlang.1(5.3 KB)
📄 createuser.1(9.42 KB)
📄 dropdb.1(5.25 KB)
📄 droplang.1(5.1 KB)
📄 dropuser.1(5.23 KB)
📄 ecpg.1(5.04 KB)
📄 erb.1(3.24 KB)
📄 initdb.1(10.26 KB)
📄 irb.1(3.43 KB)
📄 libtool.1(9.63 KB)
📄 libtoolize.1(2.53 KB)
📄 lzcat.1(63.13 KB)
📄 lzma.1(63.13 KB)
📄 lzmadec.1(2.77 KB)
📄 lzmainfo.1(1.22 KB)
📄 makedepend.1(9.3 KB)
📄 oid2name.1(8.64 KB)
📄 pg_archivecleanup.1(5.43 KB)
📄 pg_basebackup.1(17.68 KB)
📄 pg_config.1(6.11 KB)
📄 pg_controldata.1(2.22 KB)
📄 pg_ctl.1(13.54 KB)
📄 pg_dump.1(35 KB)
📄 pg_dumpall.1(13.76 KB)
📄 pg_isready.1(4.56 KB)
📄 pg_receivexlog.1(8.9 KB)
📄 pg_recvlogical.1(8.03 KB)
📄 pg_resetxlog.1(8.58 KB)
📄 pg_restore.1(22 KB)
📄 pg_rewind.1(7.08 KB)
📄 pg_standby.1(10.33 KB)
📄 pg_test_fsync.1(2.86 KB)
📄 pg_test_timing.1(9.74 KB)
📄 pg_upgrade.1(22.02 KB)
📄 pg_xlogdump.1(4.58 KB)
📄 pgbench.1(36.58 KB)
📄 pkg-config.1(18.73 KB)
📄 postgres.1(21.49 KB)
📄 postmaster.1(1.47 KB)
📄 psql.1(101.06 KB)
📄 reindexdb.1(6.55 KB)
📄 ri.1(5.22 KB)
📄 ruby.1(18.51 KB)
📄 unlzma.1(63.13 KB)
📄 unxz.1(63.13 KB)
📄 vacuumdb.1(8.15 KB)
📄 vacuumlo.1(4.19 KB)
📄 xml2-config.1(1.15 KB)
📄 xmlcatalog.1(8.2 KB)
📄 xmllint.1(13.15 KB)
📄 xsltproc.1(8.06 KB)
📄 xz.1(63.13 KB)
📄 xzcat.1(63.13 KB)
📄 xzdec.1(2.77 KB)

Editing: vacuumlo.1

'\" t
.\"     Title: vacuumlo
.\"    Author: The PostgreSQL Global Development Group
.\" Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
.\"      Date: 2018
.\"    Manual: PostgreSQL 9.6.9 Documentation
.\"    Source: PostgreSQL 9.6.9
.\"  Language: English
.\"
.TH "VACUUMLO" "1" "2018" "PostgreSQL 9.6.9" "PostgreSQL 9.6.9 Documentation"
.\" -----------------------------------------------------------------
.\" * Define some portability stuff
.\" -----------------------------------------------------------------
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.\" http://bugs.debian.org/507673
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.SH "NAME"
vacuumlo \- remove orphaned large objects from a PostgreSQL database
.SH "SYNOPSIS"
.HP \w'\fBvacuumlo\fR\ 'u
\fBvacuumlo\fR [\fIoption\fR...] \fIdbname\fR...
.SH "DESCRIPTION"
.PP
vacuumlo
is a simple utility program that will remove any
\(lqorphaned\(rq
large objects from a
PostgreSQL
database\&. An orphaned large object (LO) is considered to be any LO whose OID does not appear in any
oid
or
lo
data column of the database\&.
.PP
If you use this, you may also be interested in the
\fBlo_manage\fR
trigger in the
lo
module\&.
\fBlo_manage\fR
is useful to try to avoid creating orphaned LOs in the first place\&.
.PP
All databases named on the command line are processed\&.
.SH "OPTIONS"
.PP
vacuumlo
accepts the following command\-line arguments:
.PP
\fB\-l\fR \fIlimit\fR
.RS 4
Remove no more than
\fIlimit\fR
large objects per transaction (default 1000)\&. Since the server acquires a lock per LO removed, removing too many LOs in one transaction risks exceeding
max_locks_per_transaction\&. Set the limit to zero if you want all removals done in a single transaction\&.
.RE
.PP
\fB\-n\fR
.RS 4
Don\*(Aqt remove anything, just show what would be done\&.
.RE
.PP
\fB\-v\fR
.RS 4
Write a lot of progress messages\&.
.RE
.PP
\fB\-V\fR
.br
\fB\-\-version\fR
.RS 4
Print the
vacuumlo
version and exit\&.
.RE
.PP
\fB\-?\fR
.br
\fB\-\-help\fR
.RS 4
Show help about
vacuumlo
command line arguments, and exit\&.
.RE
.PP
vacuumlo
also accepts the following command\-line arguments for connection parameters:
.PP
\fB\-h\fR \fIhostname\fR
.RS 4
Database server\*(Aqs host\&.
.RE
.PP
\fB\-p\fR \fIport\fR
.RS 4
Database server\*(Aqs port\&.
.RE
.PP
\fB\-U\fR \fIusername\fR
.RS 4
User name to connect as\&.
.RE
.PP
\fB\-w\fR
.br
\fB\-\-no\-password\fR
.RS 4
Never issue a password prompt\&. If the server requires password authentication and a password is not available by other means such as a
\&.pgpass
file, the connection attempt will fail\&. This option can be useful in batch jobs and scripts where no user is present to enter a password\&.
.RE
.PP
\fB\-W\fR
.RS 4
Force
vacuumlo
to prompt for a password before connecting to a database\&.
.sp
This option is never essential, since
vacuumlo
will automatically prompt for a password if the server demands password authentication\&. However,
vacuumlo
will waste a connection attempt finding out that the server wants a password\&. In some cases it is worth typing
\fB\-W\fR
to avoid the extra connection attempt\&.
.RE
.SH "NOTES"
.PP
vacuumlo
works by the following method: First,
vacuumlo
builds a temporary table which contains all of the OIDs of the large objects in the selected 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\&. (Note: Only types with these names are considered; in particular, domains over them are not considered\&.) The remaining entries in the temporary table identify orphaned LOs\&. These are removed\&.
.SH "AUTHOR"
.PP
Peter Mount
<peter@retep\&.org\&.uk>

Hackfut Security File Manager

Editing: vacuumlo.1

Upload File

Create Folder