osm2pgsql error Trying to import .osm to postGis on AWS
I'm trying to import osm data using osm2pgsql onto an aws rds instance. I get an error saying Osm2pgsql failed due to ERROR: Open failed for 'insights_poi': No such file or directory but I am providing all the necessary files.
Locally, I'm running osm2pgsql -c -d insights_poi -U insights_poi -H beta.cyrrprcqeykj.us-east-1.rds.amazonaws.com -S default.style austin_texas.osm.pbf -W insights_poi -r .pbf
and the default.style and the austin_texas.osm.pbf file are in the same folder I'm running this from. Why is it saying it can't find the file?
It actually gets pretty far after I run the command
For the -W, the docs specified -w forces password prompt which I treated as a parameter. so The error Osm2pgsql failed due to ERROR: Open failed for 'insights_poi': No such file or directory was a result of -W insights_poi since nothing was really expected after the -W, it was treating the insights_poi value as the name of a file there that didn't exist.
In the end this did it, osm2pgsql -c -d insights_poi -U insights_poi -H beta.cyrrprcqeykj.us-east-1.rds.amazonaws.com -r .pbf -S default.style -W austin_texas.osm.pbf
- How to set active region correctly in this Leaflet map?
- Filter OpenStreetMap edges on `Surface` type
- OpenStreetMap licence not understood (Open Database License)
- Building IO2D fails
- leaflet map shows up grey
- How to get the OSM file to generate width of the streets?
- Mapping latitude and longitude from OpenStreetMap to X and Y points on Canvas in JavaScript
- Reading OSM Map (or other format) files to determine shortest distance from coordinate to path
- Easy OpenStreetMap tile displaying for Python
- no logs for renderd inside of docker
- Handling Average of a lot of Values
- Is this Overpass query correctly finding a way given two nodes? Can anyone find a counterexample?
- How to add multiple markers to flutter map
- how to access elements inside svg object with selenium
- How to display a map within the flutter app instead of opening it in a web view
- Regular expression inside of a if statement overpass OpenStreerMap
- Is there a way to generate a .mbtiles file from .osm.pbf file
- How can I make my two R leaflet maps synchronise with each other?
- OSMDroid - Map does not display
- Setting a custom_filter in graph_from_bbox results in more nodes than not having a filter
- Prepopulating PostGIS with OSM data works with Docker Desktop, but not with Azure pipeline
- How can I load a map using pyrosm?
- Why do I get neighboring states when mapping in R with osmdata?
- GraphHopper - Using truck profile
- Plotly mapbox layer not displaying image
- How can I get geoJSON file read correctly in JavaScript?
- Import osm data in Docker postgresql
- Using oe_get() from osmextract package to translate and read only selection of keys/tags from a pbf into a gpkg
- flutter_map zoom not updating
- Why am I getting different length and travel time from OSMnx or networkx when comparing it with Google Maps?