Re: duplicate records after restore

Поиск
Список
Период
Сортировка
От Aaron Bono
Тема Re: duplicate records after restore
Дата
Msg-id bf05e51c0608281700y4bb89220l1692b9c4c645e160@mail.gmail.com
обсуждение исходный текст
Ответ на duplicate records after restore  ("Gera Mel Handumon" <geramel.h@gmail.com>)
Список pgsql-admin
On 8/28/06, Gera Mel Handumon <geramel.h@gmail.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
==================================================================

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Thomas Galla"
Дата:
Сообщение: Help about types please
Следующее
От: "Riho Maisa"
Дата:
Сообщение: Inserting bit-type value into integer-type column