My backup file containing about 50-60 tables , but I am able to just load only 6 tables for a new db and 31 tables for postgis dbase . And this was the error when I restore a backup file.
pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 1393; 0 0 SHELL TYPE box2d postgres pg_restore: [archiver (db)] could not execute query: ERROR: type "box2d" already exists Command was: CREATE TYPE box2d;
I should I resolve this problem. I am using PostgreSQL 9.1 and please help me how can I load all tables without any errors.my backup file contains 90 MB.