Postgres database from itis.gov

This might save you some head aches. The postgresql database dump of the taxonomic universe (according to the USGS) from http://www.itis.gov/ is provided in a latin1 character encoding (specifically it tries to create a database as ENCODING = ‘LATIN1’ LC_COLLATE = ‘en_US.ISO8859-1’ LC_CTYPE = ‘en_US.ISO8859-1’ ). In order to bring this dump into a modern Postgres instance you’ll likely have to deal with the encoding being different in the dump versus your system. Rather than changing the locale of your entire database (which is likely UTF-8). It’s easier to change the encoding of the SQL file they give you.