Re: Upgrading 7.3.9 -> 7.4.8 - trouble with blobs - Mailing list pgsql-general

From Tom Lane
Subject Re: Upgrading 7.3.9 -> 7.4.8 - trouble with blobs
Date
Msg-id 7790.1123858237@sss.pgh.pa.us
Whole thread Raw
In response to Upgrading 7.3.9 -> 7.4.8 - trouble with blobs  (Christian Goetze <cg@sensage.com>)
List pgsql-general
Christian Goetze <cg@sensage.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

pgsql-general by date:

Previous
From: Frodo Larik
Date:
Subject: Re: Access NEW and OLD from function called by a rule
Next
From: Ulrich Wisser
Date:
Subject: Re: vacuum error "left link changed unexpectedly"