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

From Chris Travers
Subject Re: Running Postgres Daemons with same data files
Date
Msg-id 1070975639.977.7.camel@localhost.localdomain
Whole thread Raw
In response to Re: Running Postgres Daemons with same data files  (Halford Dace <hal@stowe.co.za>)
Responses Re: Running Postgres Daemons with same data files
List pgsql-admin
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.

Don't try to do the same with PostgreSQL.

Best Wishes,
Chris Travers


pgsql-admin by date:

Previous
From: Halford Dace
Date:
Subject: Re: Running Postgres Daemons with same data files
Next
From: Sam Barnett-Cormack
Date:
Subject: Re: Running Postgres Daemons with same data files