Postgres Pro
Downloads
Home   >   mailing lists

ERROR: duplicate key value violates unique constraint "geocode_settings_pkey" - Mailing list pgsql-admin

From Ankur Kaushik
Subject ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Date
Msg-id CALXoLqzdvF=vEvb43+AXj+e0V0vTPw_ufU70GEHrOFmuETU4dA@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view

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.

pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Postgres dump using password on command line
Next
From: Albe Laurenz
Date:
Subject: Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"