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

From Leonardo M. Ramé
Subject Re: pg_dump/pg_restore issues
Date
Msg-id 20140219182153.GB6299@leonardo-laptop
Whole thread Raw
In response to Re: pg_dump/pg_restore issues  (bricklen <bricklen@gmail.com>)
List pgsql-general
On 2014-02-19 10:08:19 -0800, bricklen wrote:
> 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.

The good news are that I'm using -Fc, now I'll generate the list. I've
found there's a sequence related to one of those tables and I'm
wondering if there's a way to backup the sequence only.

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: bricklen
Date:
Subject: Re: pg_dump/pg_restore issues
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump/pg_restore issues