$ dropdb nrel_gis&&createdb nrel_gis&&pg_restore -d nrel_gis nrel_gis_11_03_2010.pgdump
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1174; 2612 178006 PROCEDURAL LANGUAGE plpgsql
pg_restore: [archiver (db)] could not execute query: ERROR:  language "plpgsql" already exists
    Command was: CREATE PROCEDURAL LANGUAGE plpgsql;
pg_restore: [archiver (db)] Error from TOC entry 61; 1255 178049 FUNCTION box2d_in(cstring) chelm
pg_restore: [archiver (db)] could not execute query: ERROR:  could not access file "/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1": No such file or directory
    Command was: CREATE FUNCTION box2d_in(cstring) RETURNS box2d
    AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2DFLOAT4_in'
    ...
pg_restore: [archiver (db)] could not execute query: ERROR:  function public.box2d_in(cstring) does not exist
    Command was: ALTER FUNCTION public.box2d_in(cstring) OWNER TO chelm;
pg_restore: [archiver (db)] Error from TOC entry 62; 1255 178050 FUNCTION box2d_out(box2d) chelm
pg_restore: [archiver (db)] could not execute query: ERROR:  type box2d does not exist
    Command was: CREATE FUNCTION box2d_out(box2d) RETURNS cstring
    AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX2DFLOAT4_out'
  ...
pg_restore: [archiver (db)] could not execute query: ERROR:  type "box2d" does not exist
    Command was: ALTER FUNCTION public.box2d_out(box2d) OWNER TO chelm;
pg_restore: [archiver (db)] Error from TOC entry 620; 1247 178048 TYPE box2d chelm
pg_restore: [archiver (db)] could not execute query: ERROR:  function box2d_in(cstring) does not exist
    Command was: CREATE TYPE box2d (
    INTERNALLENGTH = 16,
    INPUT = box2d_in,
    OUTPUT = box2d_out,
    ALIGNMENT = int4,
    STORAGE...
pg_restore: [archiver (db)] could not execute query: ERROR:  type "public.box2d" does not exist
    Command was: ALTER TYPE public.box2d OWNER TO chelm;
pg_restore: [archiver (db)] Error from TOC entry 51; 1255 178035 FUNCTION box3d_in(cstring) chelm
pg_restore: [archiver (db)] could not execute query: ERROR:  could not access file "/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1": No such file or directory
    Command was: CREATE FUNCTION box3d_in(cstring) RETURNS box3d
    AS '/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1', 'BOX3D_in'
    LANGUA...