Skip site navigation (1) Skip section navigation (2)

Re: duplicate records after restore

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: (view raw, whole thread or download thread mbox)
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.

In response to

pgsql-admin by date

Next:From: Riho MaisaDate: 2006-08-29 08:32:35
Subject: Inserting bit-type value into integer-type column
Previous:From: Thomas GallaDate: 2006-08-28 22:25:02
Subject: Help about types please

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group