BUG #13853: initdb to UNC path

From: NBoardman(at)idtus(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13853: initdb to UNC path
Date: 2016-01-07 16:14:34
Message-ID: 20160107161434.8698.95754@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13853
Logged by: Nuri Boardman
Email address: NBoardman(at)idtus(dot)com
PostgreSQL version: 9.4.2
Operating system: Windows 7
Description:

when i run this command (initdb with UNC path)
pg_ctl initdb -D \\localhost\Users\nboardman\test

i get the following (error) output

The files belonging to this database system will be owned by user
"NBoardman".
This user must also own the server process.

The database cluster will be initialized with locale "English_United
States.1252
".
The default database encoding has accordingly been set to "WIN1252".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory //localhost/Users/nboardman/test
... ok

creating subdirectories ... initdb: could not create directory
"//localhost/User
s": File exists
initdb: removing contents of data directory
"//localhost/Users/nboardman/test"
pg_ctl: database system initialization failed

finally, if this is illegal, the documentation does not indicate the path
has to be a windows path
from http://www.postgresql.org/docs/9.4/static/app-initdb.html

-D directory
--pgdata=directory
This option specifies the directory where the database cluster should be
stored. This is the only information required by initdb, but you can avoid
writing it by setting the PGDATA environment variable, which can be
convenient since the database server (postgres) can find the database
directory later by the same variable.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Francisco Olarte 2016-01-07 18:36:59 Re: BUG #13848: 2016 Week Number Error
Previous Message Alvaro Herrera 2016-01-07 15:11:08 Re: BUG #13594: pg_ctl.exe redirects stderr to Windows Events Log if stderr is redirected to pipe