Re: BUG #5979: postgres service cannot be started if database is located in NAS - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: BUG #5979: postgres service cannot be started if database is located in NAS
Date
Msg-id BANLkTi=FpexZSMHgG+ynr4zMdAhhrbZwEg@mail.gmail.com
Whole thread Raw
In response to BUG #5979: postgres service cannot be started if database is located in NAS  ("qintao" <qintao@huaweisymantec.com>)
List pgsql-bugs
On Thu, Apr 14, 2011 at 22:57, qintao <qintao@huaweisymantec.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05979
> Logged by: =A0 =A0 =A0 =A0 =A0qintao
> Email address: =A0 =A0 =A0qintao@huaweisymantec.com
> PostgreSQL version: 8.4.7
> Operating system: =A0 windows server 2008
> Description: =A0 =A0 =A0 =A0postgres service cannot be started if databas=
e is
> located in NAS
> Details:
>
> steps to reproduce
> 1. Share a directory (say \data) from a NAS
> 2. map the shared directory to a Windows server 2008 R2 host to be a netw=
ork
> drive (say Z:)
> 3. install postgresql to the Windows Server 2008 R2 with the database as
> z:\db\.
> 4. try to start the postgresql service from service.msc
> =A0It's failed with a log in the event viewer:
> postgres cannot access the server configuration file
> "C:/symbollink/postgresql.conf": No such file or directory
>
> 5. start a Command Prompt, execute the below cmd:
> C:/Program Files (x86)/PostgreSQL/8.4/bin/pg_ctl.exe start -N
> "postgresql-8.4" -D "C:/symbollink" -w
>
> the service can be started.

Mounts are per-session in Windows. When the service starts, it is in a
different session, and can thus not see your mount point.

That said, PostgreSQL is not supported over SMB mounts anyway. It
requires a local NFTS filesystem. SMB mounts cannot be trusted for
databases.

--=20
=A0Magnus Hagander
=A0Me: http://www.hagander.net/
=A0Work: http://www.redpill-linpro.com/

pgsql-bugs by date:

Previous
From: "M709199"
Date:
Subject: BUG #5980: Installation can't running
Next
From: Dave Page
Date:
Subject: Re: BUG #5981: Attempt to install language pltcl fails on 64-bit installation