Upgrading 7.3.9 -> 7.4.8 - trouble with blobs

Started by Christian Goetzeover 20 years ago2 messagesgeneral
Jump to latest
#1Christian Goetze
cg@sensage.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Christian Goetze (#1)
Re: Upgrading 7.3.9 -> 7.4.8 - trouble with blobs

Christian Goetze <cg@sensage.com> writes:

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

You need "-d template1" in there as well. Without a -d, --host and
--port don't actually do anything, I believe; you just get a text SQL
dump on stdout.

regards, tom lane