Re: Running Postgres Daemons with same data files - Mailing list pgsql-admin

From Sam Barnett-Cormack
Subject Re: Running Postgres Daemons with same data files
Date
Msg-id Pine.LNX.4.50.0312091426290.13392-100000@short.lancs.ac.uk
Whole thread Raw
In response to Re: Running Postgres Daemons with same data files  (Chris Travers <chris@travelamericas.com>)
List pgsql-admin
On Tue, 9 Dec 2003, Chris Travers wrote:

> Case in point:
>
> MS Access was designed to have multiple database managers manipulating
> the files themselves directly and uses another file for locking
> information.  However-- as anyone who has ever worked with the process
> will tell you: Don't do it.  Data corruption (often unrecoverable) will
> result.
>
> The lessons we have learned from MS Access are:
> 1) Don't have 2 unrelated backends trying to access the same data and
> 2) Don't do it across a network.
>
> IMO, this shows a fundamental design flaw in MS Access at least given
> how it is marketed.

That all said, anyone who tells you MS Access is really an RDBMS should
lose their job...

--

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

pgsql-admin by date:

Previous
From: Chris Travers
Date:
Subject: Re: Running Postgres Daemons with same data files
Next
From: Jodi Kanter
Date:
Subject: lost database