Re: Importing data only

From: Anand Raman <araman(at)india-today(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Importing data only
Date: 2001-03-16 06:37:32
Message-ID: 20010316120732.E11013@india-today.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If u dont want to recreate the db , u will have to atleast delete the
data before moving on .. Try a delete * from <ur_table> and then
import..

Thanks
Anand

On Wed, Mar 07, 2001 at 03:58:16PM +0100, Lisa Goulet wrote:
>Hi,
>
>I've set up a secondary server and want to keep the db updated with a
>combination of pgdump and rsync. Here's what I do:
>
>pgdump -a mydb > mydb.pgdump
>cat mydb.pgdump | psql mydb
>
>which results in several "Cannot insert a duplicate key into unique index"
>errors. What's the best way to overwrite existing data without a
>dropdb+createdb etc?
>
>Thanks in advance,
>Lisa
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Piotr Kasprzyk 2001-03-16 09:41:52 No response from backend
Previous Message Anand Raman 2001-03-16 06:36:25 Re: COPY again...