Thread: How do i get the location or -D paramter to accept a windows path using cygwin postgresql
How do i get the location or -D paramter to accept a windows path using cygwin postgresql
From
"Chris Brown"
Date:
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
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