ERROR:  type "geometry" does not exist 

I fixed this error by running following code in SQL editor of your selected database in pgAdmin.

CREATE EXTENSION postgis;




Comments are welcomed!. Cheers!! ;)