PostgreSQL Clustering: HA-JDBC
A little while ago I posted about PostgreSQL clustering and I said that I was going to evaluate HA-JDBC as an option.
The reason I wanted to use HA-JDBC is that I was looking for a no-coding required solution for seamless fail over. (Similar to Oracle RAC) for PostgreSQL.
I’ll be using a Shared Disk / Heartbeat [...]
Parsing large files with pgfouine in linux
pgfouine is a nice logfile analyzer for PostgreSQL written in php.
I’m doing a trace on a very long running ETL process and the logfile generated is ~11GB.
I’m running up against a 2GB barrier in php for fopen(). If you’ve got a 64bit machine and can recompile php with -D_FILE_OFFSET_BITS=64 then you’re good to go. But [...]
PostgreSQL Clustering: JDBC
Now that I’ve got my basic active/passive cluster setup using the shared disk Linux heartbeat method mentioned
PostgreSQL HA Clustering Options
I’ve been evaluating PostgreSQL clustering options for my current project.
The reason I’m looking at clustering is that the DB server will be handling a large number of users and any downtime is catastrophic. So reliability comes before any performance or administrative concerns in a clustering solution.
My platform is PostgreSQL 8.3 and SLES Linux.
I looked at [...]
