Hi,
What you'll really want is a disk array that is shared by 2 machines. The
primary database is allowed to modify the data in the array. When it dies,
the secondary database machine is allowed write access to it. This
basically how Oracle does things like this. Don't know if FreeBSD allows
y
Title: RE: [GENERAL] Postgres failover implementation
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 10:10 AM
>Performance across an NFS mount will doubtless suck badly.
It's a fact of life at this point. I'm hoping perf
"Schmidt, Peter" <[EMAIL PROTECTED]> writes:
>> Seems like this still means a single point of failure, ie the NFS box. So
>> what's the point?
> The idea is to have a failover for postmaster itself. I realize you stated
> that postmaster crashes are rare, but if the primary machine goes down we
Peter Schmidt wrote:
>
> PostgreSQL v7.0.2
>
> My company is looking for a way to implement failover w/Postgres.
>
Hi Peter,
We have "fight" with this kind of stuff and found two directions:
-software RAID 1 with nbd (for nbd you can search http://freshmeat.net
site)
-another toy named drbd (h
