Re: Postgres on shared network drive

Tomasz Ostrowski wrote:
> On 2008-04-11 08:53, J Ottery wrote:
>
> > 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.
>
> This is not the way it is meant to work, and it can eat your data.

Change that to it *will* eat your data.

This is absolutely not supported. If it works, it's pure luck and very
temporary...

> > Now I install postgresSQL on another client machine and point it to
> > the same data directory on the network drive.
>
> Wrong. You have to install PostgreSQL on one computer, with data
> directory on local hard drive, and allow many client computers to
> connect to it.

Correct, that's how you do it.

If you for some reason need to run the server locally on each machine,
you need to still have the data directory locally, and set up
replication (with Slony for example) between the nodes. But I don't
think that's what you want.

//Magnus