Re: [GENERAL] can postgres run well on NFS mounted partitions?

Another good idea is to do a grep FATAL: your_postgres_log and see if PostgreSQL is complaining about anything relating to table. index or WAL access, otherwise, usually the only "acceptable" FATAL's are related to pg_hba.conf authorization or other connection problems. On Mon, Nov 16, 2015 at

Re: [GENERAL] can postgres run well on NFS mounted partitions?

anj patnaik wrote: > How do you tell if a database is corrupted? Are there specific error > messages/symptoms to look for? That's actually a pretty tough question. The standard test is to run "pg_dumpall", see if it finishes without error and if the dump can be restored without error. That

Re: [GENERAL] can postgres run well on NFS mounted partitions?

How do you tell if a database is corrupted? Are there specific error messages/symptoms to look for? I have tried running multiple readers/writers, inserted data and verified the byte count from doing fetches. I also ran a reboot and checked that the db came back up after it with data. I still

Re: [GENERAL] can postgres run well on NFS mounted partitions?

John McKown wrote: > All of the above make we curious about using NFS for the data files, but > having the WAL files on a > local, perhaps SSD, device.​ I am not knowledgeable about WAL. Of course, I > don't know why the OP wants > to put the database files on an NFS. If the data file storage

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On Thu, Nov 12, 2015 at 12:49 PM, Scott Marlowe wrote: > On Thu, Nov 12, 2015 at 11:19 AM, anj patnaik wrote: > > The Linux VM where postgres is running over NFS is in a different > location > > than where I am. Both the NFS mounted storage and VM are

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On 11/12/2015 10:19 AM, anj patnaik wrote: The Linux VM where postgres is running over NFS is in a different location than where I am. Both the NFS mounted storage and VM are on the same network connected via 1GB ethernet switch. and earlier... I do need reliability and high speed. you

Re: [GENERAL] can postgres run well on NFS mounted partitions?

The Linux VM where postgres is running over NFS is in a different location than where I am. Both the NFS mounted storage and VM are on the same network connected via 1GB ethernet switch. The physical server for the Linux VM has UPS. Is there any specific test I can run to do power failure? Can

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On Thu, Nov 12, 2015 at 11:49 AM, Scott Marlowe wrote: > On Thu, Nov 12, 2015 at 11:19 AM, anj patnaik wrote: >> The Linux VM where postgres is running over NFS is in a different location >> than where I am. Both the NFS mounted storage and VM are on

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On Thu, Nov 12, 2015 at 11:19 AM, anj patnaik wrote: > The Linux VM where postgres is running over NFS is in a different location > than where I am. Both the NFS mounted storage and VM are on the same network > connected via 1GB ethernet switch. > > The physical server for the

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On 11/11/2015 12:37 AM, Albe Laurenz wrote: It would be good to know of other pitfalls; I (and no doubt not only I) keep getting asked why we shouldn't run PostgreSQL on NFS when Oracle has no problem with it (and don't tell me that Oracle does not care about data corruption). Last I looked,

Re: [GENERAL] can postgres run well on NFS mounted partitions?

Scott Mead wrote: > Don't do it. Period. I've used 4 big-vendor appliances with NFS as well as > my own server. With > maybe 3 exceptions, most of the 'total-data-loss' scenarios I've dealt with > regarding transactional > data was due to NFS. Can you share more details? What happened and

Re: [GENERAL] can postgres run well on NFS mounted partitions?

John R Pierce wrote: > On 11/11/2015 12:37 AM, Albe Laurenz wrote: > > It would be good to know of other pitfalls; I (and no doubt not only I) > > keep getting asked why we shouldn't run PostgreSQL on NFS when Oracle > > has no problem with it (and don't tell me that Oracle does not care > > about

Re: [GENERAL] can postgres run well on NFS mounted partitions?

anj patnaik wrote: > Can anyone advise if there are problems running postgres over NFS mounted > partitions? > > I do need reliability and high speed. I have got the advice not to use NFS from a number of people who should know, but there are also knowledgable people who use PostgreSQL with

Re: [GENERAL] can postgres run well on NFS mounted partitions?

Thanks for the feedback. I have setup a second Linux VM (running RHEL 5.11) and Postgres 9.4. I ran some insertions today from a client running on Windows. The client does a loop of 30 updates. I am seeing about 10-20% increase in latency in the case where DB is on NFS (over TCP) compared to

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On Tue, Nov 10, 2015 at 6:26 PM, anj patnaik wrote: > Thanks for the feedback. I have setup a second Linux VM (running RHEL > 5.11) and Postgres 9.4. I ran some insertions today from a client running > on Windows. The client does a loop of 30 updates. > > I am seeing about

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On Tue, Nov 10, 2015 at 4:26 PM, anj patnaik wrote: > Thanks for the feedback. I have setup a second Linux VM (running RHEL 5.11) > and Postgres 9.4. I ran some insertions today from a client running on > Windows. The client does a loop of 30 updates. > > I am seeing about

Re: [GENERAL] can postgres run well on NFS mounted partitions?

-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.

[GENERAL] can postgres run well on NFS mounted partitions?

Can anyone advise if there are problems running postgres over NFS mounted partitions? I do need reliability and high speed. Thank you.

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On Mon, Nov 9, 2015 at 1:09 PM, Patric Bechtel 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