I have postgres 9.3 database with postgis extension. I want to create a new database on different computer and import all the tables from the source database.
In mssql it would be simple , just backup -> restore.
In postgres when I try to backup and restore using pgAdmin i keep getting different problems.
- The PostGIS tables (with the geometries columns) are not being backedup
- I get errors when resoring that sequence does not exits
Is there a simple way / tool on windows to backup / restore postgres db with gis extension ?