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 do I read a JSON file with coordinates and plot them on a map?
- How to display the map scale in leaflet.js
- Content Security Policy for OpenStreetMap
- Is there a way to generate a .mbtiles file from .osm.pbf file
- Latitude is not scaling the same way as longitude when plot on thunderforest/ openstreet map
- how to color countries and display only world-wide level map using osmroid
- How to get the OSM file to generate width of the streets?
- How to adjust text inside a specific column of a CSV text file as shell script?
- OSM version of gmplot
- OSMnx not showing amenities despite available data on OSM
- Easy OpenStreetMap tile displaying for Python
- GDAL ogr2ogr is taking too long while importing OSM data to PostGIS
- Fuzzy Search with OpenStreetMap
- Indicating one way trail direction with arrows in leaflet and OSM
- Broken Protomaps (pmtiles) rivers rendering, both leaflet and maplibregl
- Calculate driving time with OSM and Itinero
- Protobuf-net Error: Type is not expected, and no contract can be inferred: BlockHeader
- Include all OSM tags in OpenMapTiles
- How to Display Municipalities Without Notaries in a Department Using Overpass Turbo?
- Self-hosted OpenRouteService (Python) geocoding error
- How do I show custom marker in openmaptiles?
- Query all primary roads from PostGis Database filled with OSM Data within a boundary
- setZoom not working in Chrome but is working in other browsers
- Can someone advice me how to convert or upgrade an old openlayers OSM map code?
- Plotly mapbox layer not displaying image
- Get relation data from osmdata
- Number of POIs per H3 hexagon for cities in streamlit app - hexagons not showing
- Use OpenStreetMap (OSM) with .Net Maui control "Microsoft.Maui.Controls.Maps"
- How to set active region correctly in this Leaflet map?
- Filter OpenStreetMap edges on `Surface` type