Using pg_admin III and PostgreSQL 8.1 (both test and development)

I want to backup Development and restore it in test and vice-versa.

So when I do a backup of the db (开发者_JAVA百科in PGAdmin III), it backs it up. But when I restore it, all primary key information is gone and no data is in the tables.

Any help would be much appreciated. Thanks.

---

pgAdmin uses the client programs pg_dump for making backups and pg_restore for restoring (it's only a GUI). Try to dump and to restore with these programs directly and see if you get any errors or warnings.

Offtopic: Support for version 8.1 ends this year, you should upgrade to a newer version.