Re: How do i get the location or -D paramter to accept a windows - Mailing list pgsql-admin

From Bruno LEVEQUE
Subject Re: How do i get the location or -D paramter to accept a windows
Date
Msg-id bikkp8$1muu$1@news.hub.org
Whole thread Raw
In response to How do i get the location or -D paramter to accept a windows path using cygwin postgresql  ("Chris Brown" <cbrown@aurigin.com>)
List pgsql-admin
The shell must be case sensitive.
Try :

[/]$ initlocation e:\pgDBs
[/]$ createdb -D 'e:\pgDBs' testdb

You see the differnce with yours ? (e:pgDBs)




Chris Brown wrote:

>Hi,
>
>I am trying to create a new database at the location E:\PGdbs on a
>system running cygwin postgresql.
>
>If I try to set this location using pgAdmin II it errors out complaining
>about the first character in the string.
>If I try to set this location using the -D paramater of create the
>following happens:
>*********************************************************************
>C:\Program Files\PostgreSQL\7.3\bin>bash
>[/] $ initlocation e:\pgDBs
>The location will be initialized with username "adminchris".
>This user will own all the files and must also own the server process.
>
>Fixing permissions on pre-existing directory e:pgDBs
>Fixing permissions on pre-existing directory e:pgDBs/base
>
>initlocation is complete.
>
>[/] $ createdb -D 'e:\pgDbs' testdb
>ERROR:  Postmaster environment variable 'e:pgDbs' not set
>createdb: database creation failed
>[/] $ initlocation e:/pgDBs
>The location will be initialized with username "adminchris".
>This user will own all the files and must also own the server process.
>
>Fixing permissions on pre-existing directory e:/pgDBs
>Fixing permissions on pre-existing directory e:/pgDBs/base
>
>initlocation is complete.
>
>[/] $ createdb -D 'e:/pgDbs' testdb
>ERROR:  Relative paths are not allowed as database locations
>createdb: database creation failed
>[/] $
>************************************************************************
>
>Is there a workaround of some kind?
>
>Thanks for any advice.
>Chris
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpgsql: Bush becomes a null, can not execute null query
Next
From: "Ludwig Heusser"
Date:
Subject: No user restriction, Why?