Search Postgresql Archives

Upgrading 7.3.9 -> 7.4.8 - trouble with blobs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have a database with blobs, I dump it with the following command:

pg_dump\
--host=$SENSAGE_DB_HOST\
--port=$SENSAGE_DB_PORT\
-U $SENSAGE_DB_ROOT_USER\
--blobs\
--create\
--format=t\
--file="$upgrade_dump"\
$SENSAGE_DB_NAME

I then move the data directory to the side, install the new version in place, start it up, let it initialize it's new data storare, then I try restoring my database with this command:

pg_restore\
--host=$SENSAGE_DB_HOST\
--port=$SENSAGE_DB_PORT\
-U $SENSAGE_DB_ROOT_USER\
--create\
--format=t\
"$upgrade_dump"

Seems to work fine, except I get:

pg_restore: [archiver] WARNING: skipping large-object restoration

How do I ensure that the blobs get restored?
--
cg



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux