Re: Postgres 9.1 issues running data directory from VMware shared folder - Mailing list pgsql-general

From Arze, Cesar
Subject Re: Postgres 9.1 issues running data directory from VMware shared folder
Date
Msg-id etPan.53fd2b8c.180115be.1d1@carze-mbp.local
Whole thread Raw
In response to Re: Postgres 9.1 issues running data directory from VMware shared folder  (Steve Atkins <steve@blighty.com>)
Responses Re: Postgres 9.1 issues running data directory from VMware shared folder  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Thanks for the info, will look into what version of Workstation I am running (think I have 9.0) and will see if I can’t get an upgraded copy and see if it alleviates the issue.

On August 26, 2014 at 8:36:23 PM, Steve Atkins (steve@blighty.com) wrote:


On Aug 26, 2014, at 3:08 PM, Arze, Cesar <CArze@som.umaryland.edu> wrote:
>
> I probably should be posting to the VMware mailing list with this question but I wanted to see if anyone had any insight or suggestions here. I’ve seen many similar issues but none of the solutions proposed there worked for me.

This might not be what you're seeing, but there was a hideous bug in the shared folder (hgfs) driver for linux guest OSes that'll silently corrupt your filesystem if it's accessed via more than one filehandle (e.g. multiple opens, multiple processes, ...).

If you're using vmware tools bundled with workstation 10.0.1 or fusion 6.0.2, you have that bug and cannot safely use hgfs mounts for any files, let alone postgresql. (There was a different bug, with similar results, for earlier versions too, including at least fusion 5.0.1). VMWare claim it's fixed in the tools bundled with 10.0.2 / 6.0.3 (I've not tested it). If you're not running the very latest vmware, upgrade to it and install the latest tools (or avoid using hgfs).

Cheers,
Steve



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: "Arze, Cesar"
Date:
Subject: Re: Postgres 9.1 issues running data directory from VMware shared folder
Next
From: "Huang, Suya"
Date:
Subject: Re: how to query against nested hstore data type