Timeline for ogr2ogr PostGIS to GeoJSON using batch file
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 25, 2023 at 13:16 | answer | added | GeoLady | timeline score: 2 | |
| Oct 10, 2020 at 11:18 | comment | added | daustin | @Ian,@user30184, Yes - there is an exclamation mark in my password. Is there any way to tell Windows to ignore this in the batch file or do I have to change my password? | |
| Oct 10, 2020 at 8:37 | comment | added | Ian Turton | most likely problem is that there is a "special" character in your password or user name that windows doesn't like. | |
| Oct 10, 2020 at 6:02 | comment | added | daustin |
@Ian, @user30184, I added ogrinfo PG:"host=**** port=**** dbname=**** user=**** password=****" --debug on to the batch file and I got the FAILURE: Unable to open datasource message. However, I also wrote this same command directly in Windows command and it correctly listed all tables in my database. I have not changed the connection parameters, but I am using a French computer (could language parameters possibly change how ogr2ogr deals with a batch command rather than a direct command?)
|
|
| Oct 9, 2020 at 14:53 | comment | added | user30184 |
Works for me also from a batch file. Add ogrinfo PG:"host=**** port=**** dbname=**** user=**** password=****" --debug on as the first line into your batch file. Perhaps it prints some useful info for you. Do you have any odd characters that may have a special meaning for the batch file in your connection parameters?
|
|
| Oct 9, 2020 at 14:18 | history | edited | Kadir Şahbaz | CC BY-SA 4.0 |
deleted 22 characters in body
|
| Oct 9, 2020 at 13:58 | comment | added | daustin | I tested the connection using ogrinfo and there is no problem. It's only when I launch this command as a .bat file that the problem occurs. | |
| Oct 9, 2020 at 13:49 | comment | added | Ian Turton | first thing to test is using ogrinfo to check if you can connect to the database | |
| Oct 9, 2020 at 13:46 | review | First posts | |||
| Oct 9, 2020 at 14:18 | |||||
| Oct 9, 2020 at 13:43 | history | asked | daustin | CC BY-SA 4.0 |