Re: pg_dump/pg_restore issues - Mailing list pgsql-general

On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé <l.rame@griensu.com> wrote:

Hi, I'm backing up a big database using the --exclude-table option for
two tables, say table1 and table2. Then another backup of only those
tables, so, the final result are three backup files.

basic.backup
table1.backup
table2.backup

The problem I'm facing is at the restore moment is that basic.backup
contains view definitions related to table1 or table2, hence, the
restore does not create those views.

How do you recommend to workaround this?.

P.S.: I create three files because table1 and table2 are tables with
blob data, and we use basic.backup to create testing database where we
don't need blob data.

The --section option of pg_dump might allow you dump the views separately.
Alternatively, if you know the names of the views that will fail, you could pg_dump as you are doing now, but in custom format (-Fc), then use pg_restore to create a list file from the contents, comment out the views, pg_restore using the list file (minus those views), then pg_dump using another list file with *only* those views.