Re: BUG #13853: initdb to UNC path - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #13853: initdb to UNC path
Date
Msg-id 568EB32F.7060001@hogranch.com
Whole thread Raw
In response to BUG #13853: initdb to UNC path  (NBoardman@idtus.com)
Responses Re: BUG #13853: initdb to UNC path
List pgsql-bugs
On 1/7/2016 8:14 AM, NBoardman@idtus.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      13853
> Logged by:          Nuri Boardman
> Email address:NBoardman@idtus.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/Users": 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
> fromhttp://www.postgresql.org/docs/9.4/static/app-initdb.html

does it work if you leave out the \\localhost part?   using network
paths for database storage is NOT recommended.

the documentation is OS independent, things like 'paths' are OS specific

--
john r pierce, recycling bits in santa cruz

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #13848: 2016 Week Number Error
Next
From: Tom Lane
Date:
Subject: Re: BUG #13853: initdb to UNC path