search

colinwilson / comments

0 stars 0 forks source link

How to import MaxMind's GeoLite2 Database to PostgreSQL | Colin Wilson #7

Open utterances-bot opened 3 years ago

utterances-bot commented 3 years ago

How to import MaxMind's GeoLite2 Database to PostgreSQL

How to import MaxMind's GeoLite2 Database to PostgreSQL (≥9.6)

https://colinwilson.uk/2019/07/22/how-to-import-maxminds-geolite2-database-to-postgresql/

devarshigoswami commented 3 years ago

Im getting this error while copying the ASN csv ERROR: invalid input syntax for integer: "1.0.0.0/24" CONTEXT: COPY geoip_locations, line 2, column geoname_id: "1.0.0.0/24"

colinwilson commented 3 years ago

@devarshigoswami I think you may be attempting to copy the country blocks csv file (meant for the geoip_blocks table) into the geoip_locations table. Or your table columns are not ordered correctly.

At what point in the tutorial do you see this error?

mbto commented 3 years ago

https://github.com/mbto/maxmind-geoip2-csv2sql-converter