Postgres Pro
Downloads
Home   >   mailing lists

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

From Daniel Vázquez
Subject Partial dump backup -T parameter and sequence incorrect inclusion
Date
Msg-id CA+KJVfzCrOGPEfxvJbBSMH5TojOFHQRW0-LeRQw2wZc_=gBtpg@mail.gmail.com
Whole thread Raw
Responses Re: Partial dump backup -T parameter and sequence incorrect inclusion  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-admin
Tree view
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!

pgsql-admin by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: pg_upgrade / postgis issue
Next
From: Sergey Konoplev
Date:
Subject: Re: pg_upgrade / postgis issue