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
