Postgres Pro
Downloads
Home   >   mailing lists

Re: Lost my blobs and can't restore. - Mailing list pgsql-general

From Tom Lane
Subject Re: Lost my blobs and can't restore.
Date
Msg-id 23472.1091825771@sss.pgh.pa.us
Whole thread Raw
In response to Lost my blobs and can't restore.  (Jerry LeVan <jerry.levan@eku.edu>)
List pgsql-general
Tree view 
Jerry LeVan <jerry.levan@eku.edu> writes:
> pg_restore: [archiver] WARNING: skipping large-object restoration

> OK, what am I doing wrong?

You have to run pg_restore with a direct connection to a database.  If
we could implement blob restoration with a noninteractive script, then
pg_dump would just emit scripts to do it ...

            regards, tom lane

pgsql-general by date:

Previous
From: Jerry LeVan
Date:
Subject: Lost my blobs and can't restore.
Next
From: MichaelHoeller@t-online.de (Michael Hoeller)
Date:
Subject: probelm migrating from 7.3.4 to 7.42