Christian Goetze <cg@xxxxxxxxxxx> writes: > 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 IIRC, you get that if you're asking it to emit a text script rather than connect directly to the destination database server. I think you need a "-d databasename" switch to make that happen. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
