pg_dump/pg_restore issues - Mailing list pgsql-general

From Leonardo M. Ramé
Subject pg_dump/pg_restore issues
Date
Msg-id 20140219175722.GA6299@leonardo-laptop
Whole thread Raw
Responses Re: pg_dump/pg_restore issues
List pgsql-general
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.

Regards,
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Issues with patitionning and triggers
Next
From: Jeff Janes
Date:
Subject: Re: How do I track down a possible locking problem?