'\" t
.\"     Title: pcp_detach_node
.\"    Author: The Pgpool Global Development Group
.\" Generator: DocBook XSL Stylesheets vsnapshot <http://docbook.sf.net/>
.\"      Date: 2023
.\"    Manual: pgpool-II 4.3.7 Documentation
.\"    Source: pgpool-II 4.3.7
.\"  Language: English
.\"
.TH "PCP_DETACH_NODE" "1" "2023" "pgpool-II 4.3.7" "pgpool-II 4.3.7 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"
pcp_detach_node \- detaches the given node from Pgpool\-II\&. Existing connections to Pgpool\-II are forced to be disconnected\&.
.SH "SYNOPSIS"
.HP \w'\fBpcp_detach_node\fR\ 'u
\fBpcp_detach_node\fR [\fIoptions\fR...] [\fInode_id\fR] [\fIgracefully\fR]
.SH "DESCRIPTION"
.PP
\fBpcp_detach_node\fR
detaches the given node from
Pgpool\-II\&. If
failover_command
and/or
follow_primary_command
are specified, they are executed too\&. Existing connections to
Pgpool\-II
are forced to be disconnected\&.
.PP
\fBpcp_detach_node\fR
just detaches the node, and does not touch running backend behind the node\&. This command is useful when admin needs to maintain the
PostgreSQL
node\&. He/she can shutdown or stop the backend as many times as he/she wants\&.
.PP
The safest way to re\-attach the detached node is, stopping the backend and apply
\fBpcp_recovery_node\fR(1)\&. However if you are sure that there\*(Aqs no replication delay (or the delay will be recovered later on) and the role of the node (primary/standby) will not be changed, you can use
\fBpcp_attach_node\fR(1)\&.
.SH "OPTIONS"
.PP
.PP
\fB\-n \fR\fB\fInode_id\fR\fR
.br
\fB\-\-node_id=\fR\fB\fInode_id\fR\fR
.RS 4
The index of backend node to detach\&.
.RE
.PP
\fB\-g\fR
.br
\fB\-\-gracefully\fR
.RS 4
wait until all clients are disconnected (unless client_idle_limit_in_recovery is \-1 or recovery_timeout is expired)\&.
.RE
.PP
\fBOther options \fR
.RS 4
See
\fBpcp_common_options\fR(1)\&.
.RE