| From: | John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: can postgres run well on NFS mounted partitions? |
| Date: | 2015-11-09 19:15:31 |
| Message-ID: | CAAJSdjgc7sSfwc2tDZz7bCNxPfgwEi2vpLndiOnxTRk0MfvMEA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Nov 9, 2015 at 1:09 PM, Patric Bechtel <patric(dot)bechtel(at)gmail(dot)com>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Anj,
>
> anj patnaik schrieb am 06.11.2015 um 23:37:
> > Can anyone advise if there are problems running postgres over NFS
> mounted partitions?
> >
> > I do need reliability and high speed.
>
> then don't do this. Period. Put postgres where your data is.
>
I agree. This was discussed, in depth, a while back over on the SQLite
forum. Basically NFS does not reliably implement all the file system
protocols, such as locking, which are really needed by a data base. NFS is
excellent for stuff like backups and even source code repositories.
>
> /Patric
>
--
Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.
Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
| From | Date | Subject | |
|---|---|---|---|
| Next Message | anj patnaik | 2015-11-09 19:40:02 | run 2 instances of postgres 9.4 on same linux VM |
| Previous Message | Patric Bechtel | 2015-11-09 19:09:12 | Re: can postgres run well on NFS mounted partitions? |