Re: Partial dump backup -T parameter and sequence incorrect inclusion - Mailing list pgsql-admin

From Sergey Konoplev
Subject Re: Partial dump backup -T parameter and sequence incorrect inclusion
Date
Msg-id CAL_0b1su64uBiK9GyZrr-NRBOMM6agetOk=61doX0i22mdAAVQ@mail.gmail.com
Whole thread Raw
In response to Partial dump backup -T parameter and sequence incorrect inclusion  (Daniel Vázquez <daniel2d2art@gmail.com>)
List pgsql-admin
On Thu, Jun 27, 2013 at 9:47 AM, Daniel Vázquez <daniel2d2art@gmail.com> wrote:
> Postgres 9.1
>
> pg_backup with -T parameter excluding dump explicit table. Then when
> pg_restore any object of excluded table are restored EXCEPT the sequence.
> That's a problem because if use -c to clean try to drop existent sequence
> object and then raises dependency error.

Please, show both pg_dump and pg_restore commands exactly like you
use, and the error message you get.

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray.ru@gmail.com


pgsql-admin by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: pg_upgrade / postgis issue
Next
From: Magnus Hagander
Date:
Subject: Re: Ubuntu Precise and auto startup of pg databases