Marcos Cano wrote: [missing data after dump/restore of DB with PostGIS] > i found this in the file... > > ERROR: could not access file "$libdir/rtpostgis-2.0": No such file or > directory Could it be that PostGIS was not installed as an extension in the old database, so that the dump contains the individual CREATE FUNCTION statements rather than on "CREATE EXTENSION postgis"? Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general