[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] duplicate records after restore
From:       "Aaron Bono" <postgresql () aranya ! com>
Date:       2006-08-29 0:00:45
Message-ID: bf05e51c0608281700y4bb89220l1692b9c4c645e160 () mail ! gmail ! com
[Download RAW message or body]

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
==================================================================

[Attachment #3 (text/html)]

On 8/28/06, <b class="gmail_sendername">Gera Mel Handumon</b> &lt;<a \
href="mailto:geramel.h@gmail.com">geramel.h@gmail.com</a>&gt; wrote:<div><span \
class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px \
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> \
<div>hi,<br><br>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. <br><br>Any help would be greatly \
appreciated. </div></blockquote><div><br>&nbsp;</div>When I do backup/restore, I just \
use pg_dump to do the backup and then psql to import the backup.&nbsp; Note that \
before restoring, I drop the database and recreate it.&nbsp; This ensures the \
database is &quot;clean&quot; before the import. \
<br></div><br>==================================================================<br>&nbsp;&nbsp; \
Aaron Bono<br>&nbsp;&nbsp; Aranya Software Technologies, Inc.<br>&nbsp;&nbsp; <a \
href="http://www.aranya.com">http://www.aranya.com</a><br>&nbsp;&nbsp; <a \
href="http://codeelixir.com"> \
http://codeelixir.com</a><br>==================================================================




[prev in list] [next in list] [prev in thread] [next in thread]