PG Bug reporting form <noreply@postgresql.org> writes:
> While restoring backup-file to another schema, I got following error:
> "pg_restore: could not execute query: ERROR "<table_name>" already
> exists.
> Despite the error, the rows in the tables doubled.
That sounds like the expected result if you try to restore over
an existing table. Use --clean to drop and recreate the target
tables.
regards, tom lane