Thread: duplicate records after restore
hi,
I have 2 pc pc1,pc2. i create a backup from pc1 and restore to pc2. After database restore it will create a duplicate records of my attendance table. i used pgadmin3 1.4.3 for backup/restore.
Any help would be greatly appreciated.
TIA,
Mel
I have 2 pc pc1,pc2. i create a backup from pc1 and restore to pc2. After database restore it will create a duplicate records of my attendance table. i used pgadmin3 1.4.3 for backup/restore.
Any help would be greatly appreciated.
TIA,
Mel
On 8/28/06, Gera Mel Handumon <geramel.h@gmail.com> wrote:
When I do backup/restore, I just use pg_dump to do the backup and then psql to import the backup. Note that before restoring, I drop the database and recreate it. This ensures the database is "clean" before the import.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
hi,
I have 2 pc pc1,pc2. i create a backup from pc1 and restore to pc2. After database restore it will create a duplicate records of my attendance table. i used pgadmin3 1.4.3 for backup/restore.
Any help would be greatly appreciated.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================