Re: [GENERAL] Error dumping and restoring postgis db

2006-07-23 Thread Michael Fuhr
On Sun, Jul 23, 2006 at 11:22:18AM -0700, Claire McLister wrote: > We have a database with Postgis extensions installed. When we do a > full dump of the database (using pg_dump -Ft), somehow the "geometry" > type does not get dumped, so the restore fails. What are the exact dump and restore c

[GENERAL] Error dumping and restoring postgis db

2006-07-23 Thread Claire McLister
Hi, We have a database with Postgis extensions installed. When we do a full dump of the database (using pg_dump -Ft), somehow the "geometry" type does not get dumped, so the restore fails. If I try to load the geometry type before restoring, then I have to createlang 'plpgsql' because p