PopeRigby <poperigby@xxxxxxxxxxx> writes: > I've applied the following patch to postgres: > https://www.postgresql.org/message-id/attachment/122092/0002-earthdistance-sql-functions.patch Cool. You did actually install the new scripts into your target installation, right? > I'm still getting this error: > psql:all.sql:4102: ERROR: type "earth" does not exist > LINE 1: ...ians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth Hmmm ... a pg_dumpall output script shouldn't really contain that function body directly; it should just say "CREATE EXTENSION earthdistance". Is it possible that this database is so old that it contains a pre-extension (pre-9.1) version of earthdistance? regards, tom lane