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" 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
