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

["Arze, Cesar" <CArze@xxxxxxxxxxxxxxxxx>]

So what is the host OS? 

Where is the shared directory located, which OS? 

What file system is the directory located on? 

Host OS is Redhat 5.4

The shared directory is located on the host OS of Redhat 5.4 and is located on a local drive of the desktop.

The directory is on an ext3 filesystem.

What is in /mnt/pg_data after the error? 

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@xxxxxxxxxxx) 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@xxxxxxxxxxx