| From: | Leonardo M(dot) Ramé <l(dot)rame(at)griensu(dot)com> |
|---|---|
| To: | PostgreSql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_dump/pg_restore issues |
| Date: | 2014-02-19 17:57:22 |
| Message-ID: | 20140219175722.GA6299@leonardo-laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2014-02-19 17:59:20 | Re: How do I track down a possible locking problem? |
| Previous Message | Tom Lane | 2014-02-19 17:19:52 | Re: Issues with patitionning and triggers |