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_recvlogical.1

'\" t
.\"     Title: pg_recvlogical
.\"    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_RECVLOGICAL" "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_recvlogical \- control PostgreSQL logical decoding streams
.SH "SYNOPSIS"
.HP \w'\fBpg_recvlogical\fR\ 'u
\fBpg_recvlogical\fR [\fIoption\fR...]
.SH "DESCRIPTION"
.PP
\fBpg_recvlogical\fR
controls logical decoding replication slots and streams data from such replication slots\&.
.PP
It creates a replication\-mode connection, so it is subject to the same constraints as
\fBpg_receivexlog\fR(1), plus those for logical replication (see
Chapter 47, Logical Decoding, in the documentation)\&.
.SH "OPTIONS"
.PP
At least one of the following options must be specified to select an action:
.PP
\fB\-\-create\-slot\fR
.RS 4
Create a new logical replication slot with the name specified by
\fB\-\-slot\fR, using the output plugin specified by
\fB\-\-plugin\fR, for the database specified by
\fB\-\-dbname\fR\&.
.RE
.PP
\fB\-\-drop\-slot\fR
.RS 4
Drop the replication slot with the name specified by
\fB\-\-slot\fR, then exit\&.
.RE
.PP
\fB\-\-start\fR
.RS 4
Begin streaming changes from the logical replication slot specified by
\fB\-\-slot\fR, continuing until terminated by a signal\&. If the server side change stream ends with a server shutdown or disconnect, retry in a loop unless
\fB\-\-no\-loop\fR
is specified\&.
.sp
The stream format is determined by the output plugin specified when the slot was created\&.
.sp
The connection must be to the same database used to create the slot\&.
.RE
.PP
\fB\-\-create\-slot\fR
and
\fB\-\-start\fR
can be specified together\&.
\fB\-\-drop\-slot\fR
cannot be combined with another action\&.
.PP
The following command\-line options control the location and format of the output and other replication behavior:
.PP
\fB\-f \fR\fB\fIfilename\fR\fR
.br
\fB\-\-file=\fR\fB\fIfilename\fR\fR
.RS 4
Write received and decoded transaction data into this file\&. Use
\-
for
stdout\&.
.RE
.PP
\fB\-F \fR\fB\fIinterval_seconds\fR\fR
.br
\fB\-\-fsync\-interval=\fR\fB\fIinterval_seconds\fR\fR
.RS 4
Specifies how often
pg_recvlogical
should issue
\fBfsync()\fR
calls to ensure the output file is safely flushed to disk\&.
.sp
The server will occasionally request the client to perform a flush and report the flush position to the server\&. This setting is in addition to that, to perform flushes more frequently\&.
.sp
Specifying an interval of
0
disables issuing
\fBfsync()\fR
calls altogether, while still reporting progress to the server\&. In this case, data could be lost in the event of a crash\&.
.RE
.PP
\fB\-I \fR\fB\fIlsn\fR\fR
.br
\fB\-\-startpos=\fR\fB\fIlsn\fR\fR
.RS 4
In
\fB\-\-start\fR
mode, start replication from the given LSN\&. For details on the effect of this, see the documentation in
Chapter 47, Logical Decoding, in the documentation
and
Section 51.3, \(lqStreaming Replication Protocol\(rq, in the documentation\&. Ignored in other modes\&.
.RE
.PP
\fB\-\-if\-not\-exists\fR
.RS 4
Do not error out when
\fB\-\-create\-slot\fR
is specified and a slot with the specified name already exists\&.
.RE
.PP
\fB\-n\fR
.br
\fB\-\-no\-loop\fR
.RS 4
When the connection to the server is lost, do not retry in a loop, just exit\&.
.RE
.PP
\fB\-o \fR\fB\fIname\fR\fR\fB[=\fR\fB\fIvalue\fR\fR\fB]\fR
.br
\fB\-\-option=\fR\fB\fIname\fR\fR\fB[=\fR\fB\fIvalue\fR\fR\fB]\fR
.RS 4
Pass the option
\fIname\fR
to the output plugin with, if specified, the option value
\fIvalue\fR\&. Which options exist and their effects depends on the used output plugin\&.
.RE
.PP
\fB\-P \fR\fB\fIplugin\fR\fR
.br
\fB\-\-plugin=\fR\fB\fIplugin\fR\fR
.RS 4
When creating a slot, use the specified logical decoding output plugin\&. See
Chapter 47, Logical Decoding, in the documentation\&. This option has no effect if the slot already exists\&.
.RE
.PP
\fB\-s \fR\fB\fIinterval_seconds\fR\fR
.br
\fB\-\-status\-interval=\fR\fB\fIinterval_seconds\fR\fR
.RS 4
This option has the same effect as the option of the same name in
\fBpg_receivexlog\fR(1)\&. See the description there\&.
.RE
.PP
\fB\-S \fR\fB\fIslot_name\fR\fR
.br
\fB\-\-slot=\fR\fB\fIslot_name\fR\fR
.RS 4
In
\fB\-\-start\fR
mode, use the existing logical replication slot named
\fIslot_name\fR\&. In
\fB\-\-create\-slot\fR
mode, create the slot with this name\&. In
\fB\-\-drop\-slot\fR
mode, delete the slot with this name\&.
.RE
.PP
\fB\-v\fR
.br
\fB\-\-verbose\fR
.RS 4
Enables verbose mode\&.
.RE
.PP
The following command\-line options control the database connection parameters\&.
.PP
\fB\-d \fR\fB\fIdatabase\fR\fR
.br
\fB\-\-dbname=\fR\fB\fIdatabase\fR\fR
.RS 4
The database to connect to\&. See the description of the actions for what this means in detail\&. This can be a
libpq
connection string; see
Section 32.1.1, \(lqConnection Strings\(rq, in the documentation
for more information\&. Defaults to user name\&.
.RE
.PP
\fB\-h \fR\fB\fIhostname\-or\-ip\fR\fR
.br
\fB\-\-host=\fR\fB\fIhostname\-or\-ip\fR\fR
.RS 4
Specifies the host name of the machine on which the server is running\&. If the value begins with a slash, it is used as the directory for the Unix domain socket\&. The default is taken from the
\fBPGHOST\fR
environment variable, if set, else a Unix domain socket connection is attempted\&.
.RE
.PP
\fB\-p \fR\fB\fIport\fR\fR
.br
\fB\-\-port=\fR\fB\fIport\fR\fR
.RS 4
Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections\&. Defaults to the
\fBPGPORT\fR
environment variable, if set, or a compiled\-in default\&.
.RE
.PP
\fB\-U \fR\fB\fIuser\fR\fR
.br
\fB\-\-username=\fR\fB\fIuser\fR\fR
.RS 4
User name to connect as\&. Defaults to current operating system user name\&.
.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
.br
\fB\-\-password\fR
.RS 4
Force
pg_recvlogical
to prompt for a password before connecting to a database\&.
.sp
This option is never essential, since
pg_recvlogical
will automatically prompt for a password if the server demands password authentication\&. However,
pg_recvlogical
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
.PP
The following additional options are available:
.PP
\fB\-V\fR
.br
\fB\-\-version\fR
.RS 4
Print the
pg_recvlogical
version and exit\&.
.RE
.PP
\fB\-?\fR
.br
\fB\-\-help\fR
.RS 4
Show help about
pg_recvlogical
command line arguments, and exit\&.
.RE
.SH "ENVIRONMENT"
.PP
This utility, like most other
PostgreSQL
utilities, uses the environment variables supported by
libpq
(see
Section 32.14, \(lqEnvironment Variables\(rq, in the documentation)\&.
.SH "EXAMPLES"
.PP
See
Section 47.1, \(lqLogical Decoding Examples\(rq, in the documentation
for an example\&.
.SH "SEE ALSO"
\fBpg_receivexlog\fR(1)

Hackfut Security File Manager

Editing: pg_recvlogical.1

Upload File

Create Folder