CREATE SERVER osm_proxy FOREIGN DATA WRAPPER nominatim_fdw OPTIONS ( url 'https://nominatim.openstreetmap.org', http_proxy 'http://172.19.42.100:3128'); \x SELECT osm_id, osm_type, class, type, display_name, place_id IS NOT NULL AND place_id > 0 AS valid_place_id, place_rank, lon, lat, boundingbox, importance, icon, timestamp IS NOT NULL AS valid_timestamp, attribution, querystring, polygon AS geom, exclude_place_ids, more_url, jsonb_pretty(entrances) AS entrances, jsonb_pretty(extratags) AS extratags, jsonb_pretty(namedetails) AS namedetails, jsonb_pretty(addressdetails) AS addressdetails FROM nominatim_search( server_name => 'osm_proxy', q => 'einsteinstraße 60, münster, germany', extratags => true, addressdetails => true, namedetails => true, polygon => 'polygon_text', email => 'jim.jones@uni-muenster.de', countrycodes => 'DE,BR,US', dedupe => true, exclude_place_ids => '42,73', viewbox => '7.6036345,51.9659397,7.6039893,51.9661584', polygon_threshold => 0.1, layer => 'address,poi', limit_result => 1, bounded => false, accept_language => 'de_DE,de,q=0.9', entrances => true); -[ RECORD 1 ]-----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- osm_id | 88291927 osm_type | way class | office type | university display_name | Center for Information Technology, 60, Einsteinstraße, Neutor, Innenstadtring, Münster-Mitte, Münster, Nordrhein-Westfalen, 48149, Deutschland valid_place_id | t place_rank | 30 lon | 7.6038115 lat | 51.9660873 boundingbox | 51.9659397,51.9661584,7.6036345,7.6039893 importance | 7.2159151598337e-05 icon | valid_timestamp | t attribution | Data © OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright querystring | einsteinstraße 60, münster, germany geom | POLYGON((7.6039866 51.9661584,7.6036377 51.9659605,7.6039893 51.9659626,7.6039866 51.9661584)) exclude_place_ids | W88291927,42,73 more_url | https://nominatim.openstreetmap.org/search?q=einsteinstra%C3%9Fe+60%2C+m%C3%BCnster%2C+germany&polygon_text=1&addressdetails=1&entrances=1&namedetails=1&extratags=1&polygon_threshold=0.1&limit=2&countrycodes=de%2Cbr%2Cus&exclude_place_ids=W88291927%2C42%2C73&viewbox=7.603635%2C51.96594%2C7.603989%2C51.96616&format=xml entrances | [ + | { + | "lat": "51.9659399", + | "lon": "7.6038173", + | "type": "yes", + | "osm_id": "1025561849" + | } + | ] extratags | { + | "building": "university", + | "roof:shape": "flat", + | "wheelchair": "yes", + | "roof:colour": "#A9A9A9", + | "old_short_name": "ZIV", + | "building:colour": "#D3D3D3", + | "building:levels": "2", + | "contact:website": "https://www.uni-muenster.de/IT/" + | } namedetails | { + | "name": "Center for Information Technology", + | "name:de": "Center for Information Technology", + | "old_name": "Zentrum für Informationsverarbeitung", + | "short_name": "CIT" + | } addressdetails | { + | "city": "Münster", + | "road": "Einsteinstraße", + | "state": "Nordrhein-Westfalen", + | "office": "Center for Information Technology", + | "suburb": "Innenstadtring", + | "country": "Deutschland", + | "postcode": "48149", + | "country_code": "de", + | "house_number": "60", + | "city_district": "Münster-Mitte", + | "neighbourhood": "Neutor", + | "ISO3166-2-lvl4": "DE-NW" + | } SELECT pg_sleep(2); -[ RECORD 1 ] pg_sleep | DROP SERVER osm_proxy; CREATE SERVER osm_proxy FOREIGN DATA WRAPPER nominatim_fdw OPTIONS ( url 'https://nominatim.openstreetmap.org', http_proxy 'http://172.19.42.101:3128'); CREATE USER MAPPING FOR postgres SERVER osm_proxy OPTIONS (proxy_user 'proxyuser', proxy_password 'proxypass'); SELECT osm_id, osm_type, class, type, display_name, place_id IS NOT NULL AND place_id > 0 AS valid_place_id, place_rank, lon, lat, boundingbox, importance, icon, timestamp IS NOT NULL AS valid_timestamp, attribution, querystring, polygon AS geom, exclude_place_ids, more_url, jsonb_pretty(entrances) AS entrances, jsonb_pretty(extratags) AS extratags, jsonb_pretty(namedetails) AS namedetails, jsonb_pretty(addressdetails) AS addressdetails FROM nominatim_search( server_name => 'osm_proxy', q => 'einsteinstraße 60, münster, germany', extratags => true, addressdetails => true, namedetails => true, polygon => 'polygon_text', email => 'jim.jones@uni-muenster.de', countrycodes => 'DE,BR,US', dedupe => true, exclude_place_ids => '42,73', viewbox => '7.6036345,51.9659397,7.6039893,51.9661584', polygon_threshold => 0.1, layer => 'address,poi', limit_result => 1, bounded => false, accept_language => 'de_DE,de,q=0.9', entrances => true); -[ RECORD 1 ]-----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- osm_id | 88291927 osm_type | way class | office type | university display_name | Center for Information Technology, 60, Einsteinstraße, Neutor, Innenstadtring, Münster-Mitte, Münster, Nordrhein-Westfalen, 48149, Deutschland valid_place_id | t place_rank | 30 lon | 7.6038115 lat | 51.9660873 boundingbox | 51.9659397,51.9661584,7.6036345,7.6039893 importance | 7.2159151598337e-05 icon | valid_timestamp | t attribution | Data © OpenStreetMap contributors, ODbL 1.0. http://osm.org/copyright querystring | einsteinstraße 60, münster, germany geom | POLYGON((7.6039866 51.9661584,7.6036377 51.9659605,7.6039893 51.9659626,7.6039866 51.9661584)) exclude_place_ids | W88291927,42,73 more_url | https://nominatim.openstreetmap.org/search?q=einsteinstra%C3%9Fe+60%2C+m%C3%BCnster%2C+germany&polygon_text=1&addressdetails=1&entrances=1&namedetails=1&extratags=1&polygon_threshold=0.1&limit=2&countrycodes=de%2Cbr%2Cus&exclude_place_ids=W88291927%2C42%2C73&viewbox=7.603635%2C51.96594%2C7.603989%2C51.96616&format=xml entrances | [ + | { + | "lat": "51.9659399", + | "lon": "7.6038173", + | "type": "yes", + | "osm_id": "1025561849" + | } + | ] extratags | { + | "building": "university", + | "roof:shape": "flat", + | "wheelchair": "yes", + | "roof:colour": "#A9A9A9", + | "old_short_name": "ZIV", + | "building:colour": "#D3D3D3", + | "building:levels": "2", + | "contact:website": "https://www.uni-muenster.de/IT/" + | } namedetails | { + | "name": "Center for Information Technology", + | "name:de": "Center for Information Technology", + | "old_name": "Zentrum für Informationsverarbeitung", + | "short_name": "CIT" + | } addressdetails | { + | "city": "Münster", + | "road": "Einsteinstraße", + | "state": "Nordrhein-Westfalen", + | "office": "Center for Information Technology", + | "suburb": "Innenstadtring", + | "country": "Deutschland", + | "postcode": "48149", + | "country_code": "de", + | "house_number": "60", + | "city_district": "Münster-Mitte", + | "neighbourhood": "Neutor", + | "ISO3166-2-lvl4": "DE-NW" + | } ALTER USER MAPPING FOR postgres SERVER osm_proxy OPTIONS (SET proxy_password 'WRONGPASS!!!'); -- This has to fail since the proxy password is wrong. SELECT osm_id, osm_type, class, type, display_name, place_id IS NOT NULL AND place_id > 0 AS valid_place_id, place_rank, lon, lat, boundingbox, importance, icon, timestamp IS NOT NULL AS valid_timestamp, attribution, querystring, polygon AS geom, exclude_place_ids, more_url, jsonb_pretty(entrances) AS entrances, jsonb_pretty(extratags) AS extratags, jsonb_pretty(namedetails) AS namedetails, jsonb_pretty(addressdetails) AS addressdetails FROM nominatim_search( server_name => 'osm_proxy', q => 'einsteinstraße 60, münster, germany', extratags => true, addressdetails => true, namedetails => true, polygon => 'polygon_text', email => 'jim.jones@uni-muenster.de', countrycodes => 'DE,BR,US', dedupe => true, exclude_place_ids => '42,73', viewbox => '7.6036345,51.9659397,7.6039893,51.9661584', polygon_threshold => 0.1, layer => 'address,poi', limit_result => 1, bounded => false, accept_language => 'de_DE,de,q=0.9', entrances => true); WARNING: request to 'https://nominatim.openstreetmap.org' failed (1/3) WARNING: request to 'https://nominatim.openstreetmap.org' failed (2/3) WARNING: request to 'https://nominatim.openstreetmap.org' failed (3/3) ERROR: nominatim HTTP request failed DETAIL: URL: "https://nominatim.openstreetmap.org/search?q=einsteinstra%C3%9Fe%2060%2C%20m%C3%BCnster%2C%20germany&format=xml&entrances=1&extratags=1&namedetails=1&addressdetails=1&polygon_text=1&accept-language=de_DE%2Cde%2Cq%3D0.9&countrycodes=DE%2CBR%2CUS&layer=address%2Cpoi&exclude_place_ids=42%2C73&viewbox=7.6036345%2C51.9659397%2C7.6039893%2C51.9661584&bounded=0&polygon_threshold=0.100000&email=jim.jones%40uni-muenster.de&limit=1" HINT: Check your request parameters and try again.