Re: BUG #5979: postgres service cannot be started if database is located in NAS

On Thu, Apr 14, 2011 at 22:57, qintao <qintao(at)huaweisymantec(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5979
> Logged by:          qintao
> Email address:      qintao(at)huaweisymantec(dot)com
> PostgreSQL version: 8.4.7
> Operating system:   windows server 2008
> Description:        postgres service cannot be started if database 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 network
> 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
>  It'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.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/