Login or Register to Ask a Question and Join Our Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

pg_config(1) [redhat man page]

PG_CONFIG(1)						  PostgreSQL Client Applications					      PG_CONFIG(1)

NAME

       pg_config - retrieve information about the installed version of PostgreSQL

SYNOPSIS

       pg_config { --bindir | --includedir | --includedir-server | --libdir | --pkglibdir | --configure | --version }...

DESCRIPTION

       The  pg_config utility prints configuration parameters of the currently installed version of PostgreSQL. It is intended, for example, to be
       used by software packages that want to interface to PostgreSQL to facilitate finding the required header files and libraries.

OPTIONS

       To use pg_config, supply one or more of the following options:

       --bindir
	      Print the location of user executables. Use this, for example, to find the psql program. This is normally also  the  location  where
	      the pg_config program resides.

       --includedir
	      Print the location of C header files of the client interfaces.

       --includedir-server
	      Print the location of C header files for server programming.

       --libdir
	      Print the location of object code libraries.

       --pkglibdir
	      Print  the  location  of dynamically loadable modules, or where the server would search for them. (Other architecture-dependent data
	      files may also be installed in this directory.)

       --configure
	      Print the options that were given to the configure script when PostgreSQL was configured for building.  This can be used	to  repro-
	      duce  the  identical  configuration, or to find out with what options a binary package was built. (Note however that binary packages
	      often contain vendor-specific custom patches.)

       --version
	      Print the version of PostgreSQL and exit.

       If more than one option (except for --version) is given, the information is printed in that order, one item per line.

NOTES

       The option --includedir-server is new in PostgreSQL 7.2. In prior releases, the server include files were installed in the same location as
       the  client  headers,  which could be queried with the --includedir. To make your package handle both cases, try the newer option first and
       test the exit status to see whether it succeeded.

       In releases prior to PostgreSQL 7.1, before the pg_config came to be, a method for finding the equivalent configuration information did not
       exist.

HISTORY

       The pg_config utility first appeared in PostgreSQL 7.1.

SEE ALSO

       PostgreSQL Programmer's Guide

Application							    2002-11-22							      PG_CONFIG(1)

Check Out this Related Man Page

PGPOOL(8)						      System Manager's Manual							 PGPOOL(8)

NAME

       pgpool - PostgreSQL connection pool daemon

SYNOPSIS

       pgpool [ -c] [ -f config_file ] [ -F pcp_config_file ] [ -a hba_file ] [ -n ] [ -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: /etc/pgpool2/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: /etc/pgpool2/pgpool.conf).

       -F path

       --pcp-config-file path Sets the path to the pcp.conf configuration file (default: /etc/pgpool2/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.

       -v

       --version Print version and exit.

FILES

       /etc/pgpool2/pgpool.conf
	      Default configuration file

       /etc/pgpool2/pool_hba.conf
	      Host Based Access configuration file

       /etc/pgpool2/pcp.conf
	      PCP commands configuration file

SEE ALSO

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

       Additional information can be found in the pgpool README file.

								    12 Oct 2009 							 PGPOOL(8)
Man Page