Creating and preparing database postgres "no such file or directory"

Question

During preparing database according to How to import OpenStreetMap data into PostgreSQL i always get error message C:/Program: No such file or directory after writing psql -U postgres -d gis -f PATH_TO_POSTGRES/share/contrib/postgis-1.5/postgis.sql In my case path looks like : C:\Program Files\PostgreSQL\9.3\share\contrib\postgis-2.1\postgis.sql Thank you for help or advices

Try quoting you path or prepending a `\` to the space in your path. — TheConstructor
– TheConstructor, Commented Jul 23, 2014 at 9:28
I have tried add "\" to the space it did not work but quoting my path worked perfectly! Thank you so much ;) — L.s.
– L.s., Commented Jul 23, 2014 at 9:42

Ilesh Patel · Accepted Answer · 2014-07-23 10:40:18Z

1

psql -U postgres -d gis 
   -f "C:\Program Files\PostgreSQL\9.3\share\contrib\postgis-2.1\postgis.sql"

Here Program Files is separated with space so you need to add double quote around the path.

answered Jul 23, 2014 at 10:40

Ilesh Patel

2,15516 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating and preparing database postgres "no such file or directory"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related