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"
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