7.4 pg_dump and restore (with postGIS/GEOS)

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Gregory S. Williamson

    #1

    7.4 pg_dump and restore (with postGIS/GEOS)

    An attempt to use pg_restore to recreate a database from a pg_dump file hasfailed miserably. It apparently does not do the GIS stuff at all.

    Have I missed something utterly ? Do I really have to do a table by table unload and recreate the thing by hand ?

    TIA,

    Greg Williamson
    DBA (hah!)
    GlobeXplorer LLC


    ---------------------------(end of broadcast)---------------------------
    TIP 9: the planner will ignore your desire to choose an index scan if your
    joining column's datatypes do not match

Working...