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
