Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 2:42 PM, Geoffrey <li...@serioustechnology.com> wrote:
Scott Marlowe wrote:
On Mon, Jun 21, 2010 at 1:45 PM, Geoffrey <li...@serioustechnology.com>
wrote:
John R Pierce wrote:
On 06/21/10 5:37 AM, Geoffrey wrote:
So I've got 13 different databases on 13 different postmasters, now
does
pgpool know which databases I'm trying to connect to?
you would need 13 different connection pools.
Can this be done?
Yes
Can you point me to any docs that explain how this is done? As there is
only one pgpool.conf file, I'm wondering how to go about that process.
sudo apt-get install pgpool2
(password, yes, wait...)
pgpool --help
Usage:
pgpool [ -c] [ -f CONFIG_FILE ] [ -F PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ]
[ -n ] [ -d ]
pgpool [ -f CONFIG_FILE ] [ -F PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ]
[ -m SHUTDOWN-MODE ] stop
pgpool [ -f CONFIG_FILE ] [ -F PCP_CONFIG_FILE ] [ -a HBA_CONFIG_FILE ] reload
Common options:
-a HBA_CONFIG_FILE Sets the path to the pool_hba.conf configuration file
(default: /etc/pool_hba.conf)
-f CONFIG_FILE Sets the path to the pgpool.conf configuration file
(default: /etc/pgpool.conf)
-F PCP_CONFIG_FILE Sets the path to the pcp.conf configuration file
(default: /etc/pcp.conf)
-h Prints this help
Looks like there's a -f and -F option to use various files.
Admittedly, you might not be starting it up with /etc/init.d/pgpool2
each time now. But the basics are there.
Thanks muchly, that should give me a good kick start.
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
