Re: trouble migrating large objects from 7.1.3 to 7.3.2 - Mailing list pgsql-admin

From Tom Lane
Subject Re: trouble migrating large objects from 7.1.3 to 7.3.2
Date
Msg-id 19017.1050977647@sss.pgh.pa.us
Whole thread Raw
In response to trouble migrating large objects from 7.1.3 to 7.3.2  ("John M. Layman" <jml@frijid.net>)
List pgsql-admin
"John M. Layman" <jml@frijid.net> writes:
> I'm using the following command to migrate the data:

> pg_dump -p 6543 -b -Ft -v -o dbase | pg_restore -p 5432 -Ft -v -o -d dbase

The tar-archive code seems to have some bugs in it :-(.  I will look at
that, but the primary problem you are going to face here is that
pg_restore needs to seek in the dump file to implement this operation,
and it can't seek a pipe.

I think you will need to (a) use -Fc not -Ft, and (b) write the dump to
a temp file that pg_restore reads as a separate operation.

            regards, tom lane


pgsql-admin by date:

Previous
From: "John M. Layman"
Date:
Subject: trouble migrating large objects from 7.1.3 to 7.3.2
Next
From: "John M. Layman"
Date:
Subject: Re: trouble migrating large objects from 7.1.3 to 7.3.2