Re: Postgres 9.1 issues running data directory from VMware shared folder

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 base

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 global

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 pg_clog

-rw------- 1 postgres postgres  4476 2014-08-26 21:58 pg_hba.conf

-rw------- 1 postgres postgres  1636 2014-08-26 21:58 pg_ident.conf

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 pg_multixact

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 pg_notify

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 pg_serial

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 pg_stat_tmp

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 pg_subtrans

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 pg_tblspc

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 pg_twophase

-rw------- 1 postgres postgres     4 2014-08-26 21:58 PG_VERSION

drwx------ 1 postgres postgres  4096 2014-08-26 21:58 pg_xlog

-rw------- 1 postgres postgres 19169 2014-08-26 21:58 postgresql.conf

On August 26, 2014 at 7:30:41 PM, Adrian Klaver (adrian.klaver@aklaver.com) wrote:

On 08/26/2014 03:08 PM, Arze, Cesar wrote:
> Hi,
>
> I’ve recently encountered an issue running Postgres (both 8.4 and 9.1)
> on a VMware VM running Ubuntu 10.04 LTS as the guest OS with the data
> directory running out of a VMware shared folder. Previously on 8.4 this
> had worked out for me but after upgrading VMware and re-building my VM
> I’ve started to encounter this issue. It seems like the problem occurs
> when I run initdb, I get the following error:

So what is the host OS?

Where is the shared directory located, which OS?

What file system is the directory located on?

>
> # sudo -u postgres /usr/lib/postgresql/9.1/bin/initdb --noclean -D
> /mnt/pg_data/

> creating template1 database in /mnt/pg_data/base/1 ... FATAL: could not
> open file "pg_xlog/000000010000000000000001" (log file 0, segment 1): No
> such file or directory
>
> child process exited with exit code 1
> initdb: data directory "/mnt/pg_data" not removed at user's request
>

What is in /mnt/pg_data after the error?


> Thanks for any help,
>
> Cesar
>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com