Can anyone recommend a good solution for connection pooling? Here is our setup:
2 PostgreSQL 9.1 servers (1 master, 1 hot standby).
1 Apache 2.2.17
We have a pretty extensive web application running on the apache server that
talks to both of the database servers. Updates and small tasks (simp
:
On Thu, Oct 6, 2011 at 3:57 PM, Brandon Phelps mailto:bphe...@gls.com>> wrote:
Can anyone recommend a good solution for connection pooling? Here is our
setup:
2 PostgreSQL 9.1 servers (1 master, 1 hot standby).
1 Apache 2.2.17
We have a pretty extensive web application r
o
my postgresql database?
Sorry, not quite understanding.
On 10/07/2011 02:05 PM, Guillaume Lelarge wrote:
On Fri, 2011-10-07 at 13:51 -0400, Brandon Phelps wrote:
So we decided to go with pgpool-II. The documentation is a little lacking for
pgpool-II so I have one question:
How are connec
Hello all,
I have written a script which stops postgres on my standby server, executes
pg_start_backup on the master, rsync's the data directory and tablespaces over
to the standby, executes pg_stop_backup on the master, and attempts to then
start postgresql on the standby. My problem is the
Hello all,
I use Nagios to monitor various things on a few servers and have recently set
up a hot-standby server and would obviously like to include the state of
streaming replication in my monitoring.
I know about the pg_stat_replication view on the master and the
pg_last_xlog_receive_locati
By default the postgres user's group is 'daemon' on my Mac. This is
probably true for you as well. Change occurrences of
'postgres:postgres' in your chown commands to 'postgres:daemon'.
On 10/23/2011 8:16 PM, René Fournier wrote:
[…]
---> Installing postgresql90-server @9.0
Why do you have host= without a hostname? Where is your closing "?
Brandon Phelps
Global Linking Solutions
O: (704) 973-6855
C: (704) 222-2103
E: bphe...@gls.com
On 11/02/2011 02:34 PM, Prashant Bharucha wrote:
Hello All
For replication ,Created cluster and after I run Slon command
ge
Carlos,
Streaming replication was introduced in PostgreSQL 9.0 and should do
what you want.
http://wiki.postgresql.org/wiki/Streaming_Replication
On 11/04/2011 11:47 AM, Carlos Mennens wrote:
We had a 8.4.8 production server of PostgreSQL on a Dell blade server
which ran for 3 years fine. T
-Brandon
On 11/04/2011 11:58 AM, Carlos Mennens wrote:
On Fri, Nov 4, 2011 at 11:52 AM, Brandon Phelps wrote:
Carlos,
Streaming replication was introduced in PostgreSQL 9.0 and should do what
you want.
http://wiki.postgresql.org/wiki/Streaming_Replication
Oh great! I didn't see that in
Hello all,
Could someone give me an example as to how I would accomplish something
like this with a function?:
3 tables:
tableA: id (serial), name (varchar), description (varchar), subcat_id
(integer)
tableB: id (serial), subcat_name (varchar), cat_id (integer)
tableC: id (serial), cat_name
On 11/5/2011 10:35 AM, Raymond O'Donnell wrote:
On 05/11/2011 04:34, Brandon Phelps wrote:
Hello all,
Could someone give me an example as to how I would accomplish something
like this with a function?:
3 tables:
tableA: id (serial), name (varchar), description (varchar), subcat_id
(in
On 11/14/2011 05:42 PM, John R Pierce wrote:
On 11/14/11 2:32 PM, Josh Kupershmidt wrote:
How does this client compare to pgAdmin (as a graphical client) or
psql (as a client in general)?
its a MS Windows only program using the .NET framework, and it just
executes manually entered SQL commands
12 matches
Mail list logo