[postgis-users] no default operator class for access method "gist"

Vinko Vrsalovic vinko at cprsig.cl
Thu Aug 15 03:02:57 PDT 2002


On Thu, Aug 15, 2002 at 10:11:14AM +0200, Thomas Haechler wrote:
> Hi everybody,
> 
> Following the instructions on: 
> http://postgis.refractions.net/docs/x444.html#AEN509
> I built both a GIST and OID index for my layers and could visualize them
> in mapserver. Then I wanted to see if I can do a backup and restore of
> the database:

Or you're running an old version of Postgres, or you forgot

> $ pg_dump -o [dbname] > [outfile] 
> $ createdb [newdb]

  $ createlang plpgsql [newdb]
  $ psql -f /path/to/postgis.sql [newdb]

> $ psql -d [newdb] -f [outfile]
 
or something else :-)

-- 
Vinko Vrsalovic <vinko[|- at -|]cprsig.cl>
http://www.cprsig.cl




More information about the postgis-users mailing list