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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
