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: pg_archivecleanup.1

'\" t
.\"     Title: pg_archivecleanup
.\"    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 "PG_ARCHIVECLEANUP" "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"
pg_archivecleanup \- clean up PostgreSQL WAL archive files
.SH "SYNOPSIS"
.HP \w'\fBpg_archivecleanup\fR\ 'u
\fBpg_archivecleanup\fR [\fIoption\fR...] \fIarchivelocation\fR \fIoldestkeptwalfile\fR
.SH "DESCRIPTION"
.PP
pg_archivecleanup
is designed to be used as an
archive_cleanup_command
to clean up WAL file archives when running as a standby server (see
Section 26.2, \(lqLog-Shipping Standby Servers\(rq, in the documentation)\&.
pg_archivecleanup
can also be used as a standalone program to clean WAL file archives\&.
.PP
To configure a standby server to use
pg_archivecleanup, put this into its
recovery\&.conf
configuration file:
.sp
.if n \{\
.RS 4
.\}
.nf
archive_cleanup_command = \*(Aqpg_archivecleanup \fIarchivelocation\fR %r\*(Aq
.fi
.if n \{\
.RE
.\}
.sp
where
\fIarchivelocation\fR
is the directory from which WAL segment files should be removed\&.
.PP
When used within
archive_cleanup_command, all WAL files logically preceding the value of the
%r
argument will be removed from
\fIarchivelocation\fR\&. This minimizes the number of files that need to be retained, while preserving crash\-restart capability\&. Use of this parameter is appropriate if the
\fIarchivelocation\fR
is a transient staging area for this particular standby server, but
\fInot\fR
when the
\fIarchivelocation\fR
is intended as a long\-term WAL archive area, or when multiple standby servers are recovering from the same archive location\&.
.PP
When used as a standalone program all WAL files logically preceding the
\fIoldestkeptwalfile\fR
will be removed from
\fIarchivelocation\fR\&. In this mode, if you specify a
\&.partial
or
\&.backup
file name, then only the file prefix will be used as the
\fIoldestkeptwalfile\fR\&. This treatment of
\&.backup
file name allows you to remove all WAL files archived prior to a specific base backup without error\&. For example, the following example will remove all files older than WAL file name
000000010000003700000010:
.sp
.if n \{\
.RS 4
.\}
.nf
pg_archivecleanup \-d archive 000000010000003700000010\&.00000020\&.backup

pg_archivecleanup:  keep WAL file "archive/000000010000003700000010" and later
pg_archivecleanup:  removing file "archive/00000001000000370000000F"
pg_archivecleanup:  removing file "archive/00000001000000370000000E"
.fi
.if n \{\
.RE
.\}
.PP
pg_archivecleanup
assumes that
\fIarchivelocation\fR
is a directory readable and writable by the server\-owning user\&.
.SH "OPTIONS"
.PP
pg_archivecleanup
accepts the following command\-line arguments:
.PP
\fB\-d\fR
.RS 4
Print lots of debug logging output on
stderr\&.
.RE
.PP
\fB\-n\fR
.RS 4
Print the names of the files that would have been removed on
stdout
(performs a dry run)\&.
.RE
.PP
\fB\-V\fR
.br
\fB\-\-version\fR
.RS 4
Print the
pg_archivecleanup
version and exit\&.
.RE
.PP
\fB\-x\fR \fIextension\fR
.RS 4
Provide an extension that will be stripped from all file names before deciding if they should be deleted\&. This is typically useful for cleaning up archives that have been compressed during storage, and therefore have had an extension added by the compression program\&. For example:
\-x \&.gz\&.
.RE
.PP
\fB\-?\fR
.br
\fB\-\-help\fR
.RS 4
Show help about
pg_archivecleanup
command line arguments, and exit\&.
.RE
.SH "NOTES"
.PP
pg_archivecleanup
is designed to work with
PostgreSQL
8\&.0 and later when used as a standalone utility, or with
PostgreSQL
9\&.0 and later when used as an archive cleanup command\&.
.PP
pg_archivecleanup
is written in C and has an easy\-to\-modify source code, with specifically designated sections to modify for your own needs
.SH "EXAMPLES"
.PP
On Linux or Unix systems, you might use:
.sp
.if n \{\
.RS 4
.\}
.nf
archive_cleanup_command = \*(Aqpg_archivecleanup \-d /mnt/standby/archive %r 2>>cleanup\&.log\*(Aq
.fi
.if n \{\
.RE
.\}
.sp
where the archive directory is physically located on the standby server, so that the
\fIarchive_command\fR
is accessing it across NFS, but the files are local to the standby\&. This will:
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
produce debugging output in
cleanup\&.log
.RE
.sp
.RS 4
.ie n \{\
\h'-04'\(bu\h'+03'\c
.\}
.el \{\
.sp -1
.IP \(bu 2.3
.\}
remove no\-longer\-needed files from the archive directory
.RE
.SH "SEE ALSO"
\fBpg_standby\fR(1)

Hackfut Security File Manager

Editing: pg_archivecleanup.1

Upload File

Create Folder