Have you looked at a 'shared storage' solution based on DRBD ? I configured a
test environment using SLES HAE and DRBD with relative ease and it behaved very
well (can probably supply a build script if you like), there are lots of people
running production systems on similar setups although I th
Is shared storage an option for you ? We've had a fairly pleasant experience
with shared storage partnered up with SLES and its HAE (high availability
extension) suite using a Pacemaker cluster for resource control. On top of this
we replicate to a hot standby server offsite, however used for re
The first and most obvious check will be the pg_hba.conf file for the allowed
hosts ... these files are specific to the instance.
From: Jacques Lamothe
To: "pgsql-general@postgresql.org"
Sent: Wednesday, 21 December 2011 10:02 AM
Subject: [GENERAL] Help with
I've performed a very similar upgrade including postgis upgrade at the same
time, we used the following command examples ... also put some simple scripting
together to dump multiple databases in parallel as downtime was critical:
Dump database data: pg_dump -Fc database --compress=1 > /mnt/dumps
No suggestions about where to get the phantom RPM's ? I've managed to locate a
source RPM for 9.0.3 which I'm going to look at using with source from 9.0.5
____
From: David Morton
To: "pgsql-general@postgresql.org"
Sent: Monday,
I'm desperately trying to get a hold of the latest RPM's for PostgreSQL 9.0..5
for SLES 11 SP1 x86_64 I simply can not find these anywhere !!
It seems that the good folk over at software.opensuse.org are only compiling
9.1.x now. Rather annoying to say the least for those of us who don't wa
I'm desperately trying to get a hold of the latest RPM's for PostgreSQL 9.0..5
for SLES 11 SP1 x86_64 ... I simply can not find these anywhere !!
It seems that the good folk over at software.opensuse.org are only compiling
9.1.x now. Rather annoying to say the least for those of us who don't wan