Re: The case of PostgreSQL on NFS Server (II) - Mailing list pgsql-general

From Steve Atkins
Subject Re: The case of PostgreSQL on NFS Server (II)
Date
Msg-id 183FBB86-BA54-4ACA-9D1A-BBD94B7C8E20@blighty.com
Whole thread Raw
In response to Re: The case of PostgreSQL on NFS Server (II)  (Octavi Fors <octavi@live.unc.edu>)
List pgsql-general
On Apr 2, 2015, at 5:09 PM, Octavi Fors <octavi@live.unc.edu> wrote:

>
> And second, because I need the database to be accessible from two computers in the same LAN.

If you do this, you will destroy your database[1].

Why not have the database running on one machine, all the time, potentially with a real disk subsystem then just access
itfrom wherever on the LAN you need to? Postgresql is a client-server database, and you can access it over the network
aseasily as you can from the machine it's running on. 

Cheers,
  Steve

[1] Almost certainly, unless you make absolutely sure postgresql is only started on one machine at a time, amongst
otherthings. 



pgsql-general by date:

Previous
From: Dzmitry Nikitsin
Date:
Subject: ERROR: out of memory
Next
From: "David G. Johnston"
Date:
Subject: Re: The case of PostgreSQL on NFS Server (II)