| From: | "Chris Brown" <cbrown(at)aurigin(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | How do i get the location or -D paramter to accept a windows path using cygwin postgresql |
| Date: | 2003-08-27 18:08:25 |
| Message-ID: | 56510AAEF435D240958D1CE8C6B1770AFD3975@mailc03.aurigin.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yuji Shinozaki | 2003-08-27 18:15:04 | Re: pg_ctl won't start postgres, but postmaster will?! |
| Previous Message | scott.marlowe | 2003-08-27 15:29:46 | Re: postgresql and replication |