Brad Nicholson wrote:
One further thing to mention - all of these solutions are based on
making the physical blocks available (actually, I'm not sure about
Streaming replication in 9.0).
You're right here; the SR feature in 9.0 is essentially near real-time
partial WAL file shipping, and the W
Thomas Kellerer wrote:
The manual lists three possible solutions to HA: shared disk failover,
file system replication and Warm/Hot Standby. I'm not an admin (nor a
DBA), so my question might sound a bit stupid: from my point of view
solutions using shared disk failover of file system replicatio
"Gnanakumar" wrote:
> We have our java servlet code running in Tomcat and the connection
> is managed by pgpool.
If you're running under Tomcat, you might not even need pgpool; see
this recent post:
http://archives.postgresql.org/pgsql-performance/2010-07/msg00154.php
> When we did a Load
On Mon, 2010-07-12 at 08:58 +0200, Thomas Kellerer wrote:
> Greg Smith, 10.07.2010 14:44:
> >> Is there a difference in how much data could potentially be lost in
> >> case of a failover? E.g. because 9.0 replicates the changes quicker than
> >> 8.4?
> >
> > There's nothing that 9.0 does that you
