ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
From: Ankur Kaushik <ankurkaushik@xxxxxxxxx>
Date: Mon, 15 Jun 2015 15:12:41 +0530

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.

Follow-Ups:
- Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
  - From: Albe Laurenz

Prev by Date: Re: Postgres dump using password on command line
Next by Date: Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Previous by thread: Postgres dump using password on command line
Next by thread: Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux