Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"

Поиск
Список
Период
Сортировка
От Ankur Kaushik
Тема Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Дата
Msg-id CALXoLqxGFNYDESrgTFrWBYD0Zg6pMLEGE1JNpzaZBvf1_mcEQQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Ответы Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-admin
Дерево обсуждения
Yes I have checked now using -c with pg_dump is right way to take backup and restore . which has worked fine for me.

One more question which is faster way to restore psql < dump.sql or using pg_restore ?

On Wed, Jun 17, 2015 at 3:13 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Ankur Kaushik wrote:
> So is there any way to restore database without any error , or Can we put one line in database backup
> file , DROP TABLE 'table name' just before CREATE TABLE.

You mean like the -c option in pg_dump or pg_restore?

Yours,
Laurenz Albe

В списке pgsql-admin по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"