[postgis-users] Backup and Restore of a PostGis database

[Maria Arias de Reyna]

El Wednesday 04 August 2010, Luís de Sousa escribió:
> 1. Creating a fresh empty database at server B and then restoring.
> With this process PostGres complains of not having permissions to
> create basic types.

Are you executing that restore with a user who has permissions to create basic 
types? User 'postgres' perhaps?

Probably this can be the easiest solution.

Anyway, pg_dump has a lot of options, you can try to look for a better 
combination of them.

-- 
María Arias de Reyna Domínguez
Área de Operaciones

Emergya Consultoría 
Tfno: +34 954 51 75 77 / +34 607 43 74 27
Fax: +34 954 51 64 73 
www.emergya.es