Re: PostgresSQL on a networked drive with multiple users

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: J Ottery <jottery(at)becsystems(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgresSQL on a networked drive with multiple users
Date: 2008-04-11 10:40:50
Message-ID: 47FF4032.4090300@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/04/2008 09:58, J Ottery wrote:
> Thanks Craig for making me look like an idiot. I feel bad now.
>
> When I posted I suspected that what you have just replied with was the
> case.

I'm sure that wasn't Craig's intent. I'd hazard a guess that you've been
using Access or a similar single-file-based DB where the you simply
point the front-end at the data file, and the front-end looks after
locking and concurrency (I think - I may be way off on this). PostgreSQL
and other "heavyweight" DBMSs require a different mind-set - think of
the server as a black box at which you fire off your SQL and get back
the results.

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrea 2008-04-11 11:41:06 Problems in PITR backup&recovery
Previous Message Craig Ringer 2008-04-11 10:03:59 Re: Postgres on shared network drive