Postgres Pro
Downloads
Home   >   mailing lists

pg admin III and primary keys (for backup/restore) - Mailing list pgsql-general

From Assad Jarrahian
Subject pg admin III and primary keys (for backup/restore)
Date
Msg-id 4bd3e1480601041412m9f2832dud3613347a26fea3e@mail.gmail.com
Whole thread Raw
Responses Re: pg admin III and primary keys (for backup/restore)  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
Environment: Deployed on Debian. Test and Development on Windows.
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 (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.

-assad

pgsql-general by date:

Previous
From: "ctobini"
Date:
Subject: Re: postgresql7.4 can't start (SSL)
Next
From: Sven Willenberger
Date:
Subject: Re: insert serial numbers