Re: Postgres back up error

On Thursday, April 26, 2018, Azimuddin Mohammed <azimeiu(at)gmail(dot)com> wrote:

> Hello All,
>
> I am trying to implement postgres database backup and restore on existing
> database. I am using the pg_dump utility to back up the database pg_dump -U
> postgres testdb -f testdb.sql
>
> My backup is successfully generated with the latest data in it BUT when I
> restore this file using the command “psql -U postgres db.sql testdb -f in
> another standby server I am getting this below error. I understand that its
> stopping me because the database already exist with table column as
> primary key column. How can I over write this I need to restore my database
> nightly on my standby server.
>

Basically dump/restore requires the target to be empty and the entire dump
is restored into it. Somewhere in your proces you need to send an
instruction to the "standby" server to "drop database" if you wish to use
dump/restore. If you'd like incremental backup you will want to use a
different toolset.

David J.