Sharing Postgres Datafiles

I want to share a Postgres DB between 2 servers,

Both these systems will be running Postgres,I need to share the Database files,
these files need to be stored on a file server, Do I only copy the /base directory to the file server
and mount this directory on /var/lib/pgsql/base. ?

Both systems will not be accessing these at the same time, its only if one server goes down
the other will take over.


Sean
>From pgsql-admin-owner(at)postgresql(dot)org Wed Nov 8 08:40:03 2000
Received: from unknown-147.101.pilot.net (unknown-147-101.pilot.net [198.232.147.101])
by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA8Dajs89966
for <pgsql-admin(at)postgresql(dot)org>; Wed, 8 Nov 2000 08:36:45 -0500 (EST)
(envelope-from sameern(at)wiproge(dot)gsoi(dot)med(dot)ge(dot)com)
Received: from unknown-24-4.pilot.net (unknown-24-4.pilot.net [206.189.24.4]) by unknown-147.101.pilot.net with ESMTP id FAA09373 for <pgsql-admin(at)postgresql(dot)org>; Wed, 8 Nov 2000 05:36:13 -0800 (PST)
Received: from new02xbindge.geind.ge.com (localhost [127.0.0.1]) by unknown-24-4.pilot.net with ESMTP id FAA20187 for <pgsql-admin(at)postgresql(dot)org>; Wed, 8 Nov 2000 05:36:11 -0800 (PST)
Received: by new02xbindge.geind.ge.com with Internet Mail Service (5.5.2650.21)
id <WMDC18AX>; Wed, 8 Nov 2000 19:15:15 +0530
Received: from wiproge.gsoi.med.ge.com (3.70.200.53 [3.70.200.53]) by new02xbindge.geind.ge.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21)
id WMDC18A4; Wed, 8 Nov 2000 19:15:10 +0530
Received: from konark.gsoi.med.ge.com (root(at)konark [3.70.200.113])
by wiproge.gsoi.med.ge.com (8.9.3/8.9.3) with ESMTP id TAA17909
for <pgsql-admin(at)postgresql(dot)org>; Wed, 8 Nov 2000 19:01:46 -0500 (GMT)
Received: from wiproge.med.ge.com (mahadev [3.70.202.137])
by konark.gsoi.med.ge.com (8.8.8+Sun/8.8.8) with ESMTP id TAA00774
for <pgsql-admin(at)postgresql(dot)org>; Wed, 8 Nov 2000 19:00:35 -0500 (GMT)
From: Sameer N Navaratna <sameern(at)wiproge(dot)med(dot)ge(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Message-ID: <3A09E8B8(dot)99C3D181(at)wiproge(dot)med(dot)ge(dot)com>
Date: Wed, 08 Nov 2000 18:58:48 -0500
X-Mailer: Mozilla 4.73 [en] (X11; I; SunOS 5.5.1 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: request info on data recovery in pgsql
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200011/43
X-Sequence-Number: 52

Hi,
While working on a postgresql db table, I accidentally updated 929
records. Can you please tell me how to get back the previous data. The
query I executed was like this:
update stat_details set accomplishments='executed test case for
eTracker';
stat_details contained 929 records and all were updated because I forgot
to put the where clause.
Please help me out. Will you?
Thanks,
Sameer