Re: Postgres on shared network drive - Mailing list pgsql-general

From J Ottery
Subject Re: Postgres on shared network drive
Date
Msg-id 0c9e4618-e53e-4534-9b84-d47d45a45f32@l28g2000prd.googlegroups.com
Whole thread Raw
In response to Postgres on shared network drive  (J Ottery <jottery@becsystems.com.au>)
List pgsql-general
On Apr 11, 5:34 pm, andreas.kretsch...@schollglas.com ("A.
Kretschmer") wrote:
> am  Thu, dem 10.04.2008, um 23:53:18 -0700 mailte J Ottery folgendes:
>
> > Using windows XP and TCP/IP network.
>
> > I install PostgreSQL on a client PC and put the data files on a
> > networked drive (instead of the local drive).  Postgres as user and
> > localport. This works well.
>
> > Now I install postgresSQL on another client machine and point it to
> > the same data directory on the network drive.
>
> Sure, you can do that. But there are faster ways to destroy your data.
>
>
>
> > Will this setup work OK for multiple / concurrent users and accessing
> > the same tables on either of the client machines or is there something
> > else I need to be aware of?
>
> You idea is complete ill. PostgreSQL is a Server-Client-database, with
> one Server and multiple Clients. You can't access to the same
> database-files with multiple database-servers.
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA  http://wwwkeys.de.pgp.net
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

I understand now Andreas. Thanks for the advice.

pgsql-general by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: begin transaction locks out other connections
Next
From: Raymond O'Donnell
Date:
Subject: Re: PostgresSQL on a networked drive with multiple users