开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜