Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgresSQL on a networked drive with multiple users

PostgresSQL on a networked drive with multiple users

From
J Ottery
Date:
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 have some leaning to do on this.

Jeff

Re: PostgresSQL on a networked drive with multiple users

From
Craig Ringer
Date:
J Ottery wrote:
> Thanks Craig for making me look like an idiot. I feel bad now.
>
That wasn't my intent, so I'm sorry for making you feel bad about it. I
was just trying to stress the importance of only ever having one pg
instance using a data directory. If you're used to shared-access systems
it's a natural question, and the documentation:

http://www.postgresql.org/docs/8.3/static/creating-cluster.html

doesn't explicitly spell out that it's a bad idea to have multiple Pg
servers accessing a database cluster.

--
Craig Ringer

Re: PostgresSQL on a networked drive with multiple users

From
Raymond O'Donnell
Date:
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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Re: PostgresSQL on a networked drive with multiple users

From
Geoffrey
Date:
J Ottery wrote:
> Thanks Craig for making me look like an idiot. I feel bad now.

You don't look like an idiot, you look like someone who has just learned
something.  If we don't learn from our mistakes, then we are idiots... ;)

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin