Thread: Partial dump backup -T parameter and sequence incorrect inclusion

Partial dump backup -T parameter and sequence incorrect inclusion

From
Daniel Vázquez
Date:
Hi here!

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. 

Thanks!

Re: Partial dump backup -T parameter and sequence incorrect inclusion

From
Sergey Konoplev
Date:
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