Re: The case of PostgreSQL on NFS Server (II)

From: Steve Atkins <steve(at)blighty(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: The case of PostgreSQL on NFS Server (II)
Date: 2015-04-03 00:32:48
Message-ID: 183FBB86-BA54-4ACA-9D1A-BBD94B7C8E20@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 2, 2015, at 5:09 PM, Octavi Fors <octavi(at)live(dot)unc(dot)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 it from wherever on the LAN you need to? Postgresql is a client-server database, and you can access it over the network as easily 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 other things.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2015-04-03 00:47:37 Re: The case of PostgreSQL on NFS Server (II)
Previous Message Dzmitry Nikitsin 2015-04-03 00:24:26 ERROR: out of memory