Search Postgresql Archives

Re: Postgres on shared network drive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux