Hi Tom,
Thanks for this - I'm really impressed with the response. In the end I used
lo_export and PL/PGSQL procedure to dump all the files (60000 of them!) to
disk and I bz2 that up to backup each night. I'll revisit pg_restore/pg_dump
when I get a chance.
I realise that you guys probably have plenty of developers but I'm wanting to
get my C/C++ back up to scratch again and I love Postgres - anything that you
guys need someone to sink their teeth into that I could have a shot at?
Cheers,
Jason
On Monday 10 March 2003 06:41, Tom Lane wrote:
> Jason Godden <jasongodden@optushome.com.au> writes:
> > ./pg_restore -p5431 -dsomedb -Ft -N -X disable-triggers
> > /var/db/backup/data.tar
> > ERROR: Relation "BLOBs" does not exist
>
> Here's the patch if you need it.
>
> regards, tom lane
>
> *** src/bin/pg_dump/pg_backup_archiver.c~ Sat Feb 1 17:07:14 2003
> --- src/bin/pg_dump/pg_backup_archiver.c Sun Mar 9 14:36:40 2003
> ***************
> *** 293,299 ****
> * Maybe we can't do BLOBS, so check if this node is
> * for BLOBS
> */
> ! if ((strcmp(te->desc, "BLOBS") == 0) && !_canRestoreBlobs(AH))
> {
> ahprintf(AH, "--\n-- SKIPPED \n--\n\n");
>
> --- 293,300 ----
> * Maybe we can't do BLOBS, so check if this node is
> * for BLOBS
> */
> ! if ((strcmp(te->desc, "BLOBS") == 0) &&
> ! !_canRestoreBlobs(AH))
> {
> ahprintf(AH, "--\n-- SKIPPED \n--\n\n");
>
> ***************
> *** 445,450 ****
> --- 446,455 ----
> if (!ropt->dataOnly || !ropt->disable_triggers)
> return;
>
> + /* Don't do it for the BLOBS TocEntry, either */
> + if (te && strcmp(te->desc, "BLOBS") == 0)
> + return;
> +
> oldUser = strdup(AH->currUser);
> oldSchema = strdup(AH->currSchema);
>
> ***************
> *** 506,511 ****
> --- 511,520 ----
>
> /* This hack is only needed in a data-only restore */
> if (!ropt->dataOnly || !ropt->disable_triggers)
> + return;
> +
> + /* Don't do it for the BLOBS TocEntry, either */
> + if (te && strcmp(te->desc, "BLOBS") == 0)
> return;
>
> oldUser = strdup(AH->currUser);
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
