On Wed, Apr 06, 2016 at 10:25:29AM +0000, Blumentrath, Stefan wrote: > pg_restore: [archiver (db)] could not execute query: ERROR: operator does not exist: public.geometry && public.geometry Did you add postgis to the target database prior to restore the data from the dump ? Did you use postgis_restore.pl ? --strk;