From: | "Aaron Bono" <postgresql(at)aranya(dot)com> |
---|---|
To: | "Gera Mel Handumon" <geramel(dot)h(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: duplicate records after restore |
Date: | 2006-08-29 00:00:45 |
Message-ID: | bf05e51c0608281700y4bb89220l1692b9c4c645e160@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 8/28/06, Gera Mel Handumon <geramel(dot)h(at)gmail(dot)com> wrote:
>
> 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.
>
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
==================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Riho Maisa | 2006-08-29 08:32:35 | Inserting bit-type value into integer-type column |
Previous Message | Thomas Galla | 2006-08-28 22:25:02 | Help about types please |