Thread: Partial dump backup -T parameter and sequence incorrect inclusion
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!
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