GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  PGPOOL (8)


NAME

pgpool - PostgreSQL connection pool daemon

CONTENTS

Synopsis
Description
Invocation
Options
Files
See Also

SYNOPSIS

pgpool [ -c] [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ] [ -n ] [ -D ] [ -d ]

pgpool [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ] [ -m {s[mart]|f[ast]|i[mmediate]} ] stop

pgpool [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ] reload

DESCRIPTION

pgpool is a connection pool server for PostgreSQL. pgpool runs between PostgreSQL’s client and server. Any PostgreSQL client can connect to pgpool as if it’s a real PostgreSQL server. pgpool caches the connection to the PostgreSQL server to reduce the overhead involved in establishing the connection to it.

pgpool can also be used with two PostgreSQL servers for fail over purposes. If the first server goes down, pgpool will automatically switch to the secondary server.

pgpool is typically started and stopped via system initialization scripts.

INVOCATION

pgpool [ options... ]
  Starts as a daemon in the background (unless -n is given).
pgpool [ options... ] stop
  Shutdown.
pgpool [ options... ] reload
  Reloads the configuration.

OPTIONS

-a path
--hba-file path Sets the path to the pool_hba.conf configuration file (default: /usr/local/etc/pgpool_hba.conf).
-c
--clear-cache Clears the query cache.
-d
--debug Print lots of debug messages.
-f path
--config-file path Sets the path to the pgpool.conf configuration file (default: /usr/local/etc/pgpool.conf).
-F path
--pcp-config-file path Sets the path to the pcp.conf configuration file (default: /usr/local/etc/pcp.conf).
-h
--help Print a help message and exit.
-m mode
--mode mode Shutdown mode: smart, fast, or immediate.
-n
--no-daemon Foreground mode. Error messages go to stdout or stderr, which could be piped out to log processors such as logger(1) or rotatelogs(8). To daemonize, explicitly invoke pgpool in background.
-D
--discard-status Discard pgpool_status file and do not restore previous status.
-v
--version Print version and exit.

FILES

/usr/local/etc/pgpool.conf
  Default configuration file
/usr/local/etc/pool_hba.conf
  Host Based Access configuration file
/usr/local/etc/pcp.conf
  PCP commands configuration file

SEE ALSO

logger(1), postmaster(1), rotatelogs(8)

Additional information can be found in the pgpool README file.

Search for    or go to Top of page |  Section 8 |  Main Index


--> PGPOOL (8) 12 Oct 2009

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.