Christian Goetze <cg(at)sensage(dot)com> 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