Assad Jarrahian wrote:
> 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.
What precise series of steps are you following?
As what (postgresql) user?
Do you get any error messages?
Does pg_dump/pg_restore show the same problem?
--
Richard Huxton
Archonet Ltd