How do i get the location or -D paramter to accept a windows path using cygwin postgresql

Поиск
Список
Период
Сортировка
От Chris Brown
Тема How do i get the location or -D paramter to accept a windows path using cygwin postgresql
Дата
Msg-id 56510AAEF435D240958D1CE8C6B1770A014C25E7@mailc03.aurigin.com
обсуждение исходный текст
Список pgsql-cygwin
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





В списке pgsql-cygwin по дате отправления:

Предыдущее
От: "Chigurupati, Prasad"
Дата:
Сообщение: Re: running postgresql7.3.4 under windows
Следующее
От: s0lao@netscape.net (S. L.)
Дата:
Сообщение: Re: How do i get the location or -D paramter to accept a windows path using cygwin postgresql