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

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(dot)klaver(at)aklaver(dot)com<mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com