Re: [GENERAL] Upgrading 7.3.9 -> 7.4.8 - trouble with blobs

2005-08-12 Thread Tom Lane
Christian Goetze <[EMAIL PROTECTED]> 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 bel

Re: [GENERAL] Upgrading 7.3.9 -> 7.4.8 - trouble with blobs

2005-08-11 Thread Tom Lane
Christian Goetze <[EMAIL PROTECTED]> writes: >>> 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

Re: [GENERAL] Upgrading 7.3.9 -> 7.4.8 - trouble with blobs

2005-08-11 Thread Christian Goetze
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. Does this mean that

Re: [GENERAL] Upgrading 7.3.9 -> 7.4.8 - trouble with blobs

2005-08-11 Thread Tom Lane
Christian Goetze <[EMAIL PROTECTED]> 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, y