| From: | Sam Barnett-Cormack <s(dot)barnett-cormack(at)lancaster(dot)ac(dot)uk> |
|---|---|
| To: | Chris Travers <chris(at)travelamericas(dot)com> |
| Cc: | Halford Dace <hal(at)stowe(dot)co(dot)za>, Bhartendu Maheshwari <bhartendum(at)jataayusoft(dot)com>, Sam Barnett-Cormack <s(dot)barnett-cormack(at)lancaster(dot)ac(dot)uk>, PgSQL Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Running Postgres Daemons with same data files |
| Date: | 2003-12-09 14:26:52 |
| Message-ID: | Pine.LNX.4.50.0312091426290.13392-100000@short.lancs.ac.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-12-09 14:31:48 | Re: Error compiling PostgreSQL 7.4 for Fedora Core 1 |
| Previous Message | Teodor Sigaev | 2003-12-09 13:18:20 | Re: Full textsearch & gist (fwd) |