ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"

From: Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Date: 2015-06-15 09:42:41
Message-ID: CALXoLqzdvF=vEvb43+AXj+e0V0vTPw_ufU70GEHrOFmuETU4dA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I took Backup using below command
pg_dump "database name" | gzip > /root/dump.sql.gz

While restoring in fresh PostgreSQL server getting below error .

ERROR: duplicate key value violates unique constraint
"geocode_settings_pkey"
DETAIL: Key (name)=(debug_geocode_address) already exists.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2015-06-15 09:57:49 Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Previous Message Thomas Kellerer 2015-06-15 08:58:01 Re: Postgres dump using password on command line