Re: pg_dump failure in tar format. - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump failure in tar format.
Date
Msg-id 26528.1122942927@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump failure in tar format.  ("Tomeh, Husam" <htomeh@firstam.com>)
List pgsql-admin
"Tomeh, Husam" <htomeh@firstam.com> writes:
> I was told that because the data is on postgres 8.0 and I'm trying to
> restore on another database which 7.3 that I can not do that. However,
> researching more, I could not find a proof to what I was told, So, I
> will try to use -Fc  instead. Do you agree that I can restore with -Fc
> regardless of the different versions of the databases?

You're very likely going to have some issues with SQL command syntax,
but I don't believe that using -Ft instead of -Fc would help on that.

My recommendation is to try a schema-only dump (-s option) and make sure
you can load that, before you spend time making and loading a full dump.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Tomeh, Husam"
Date:
Subject: Re: pg_dump failure in tar format.
Next
From: Christopher Browne
Date:
Subject: Re: some databases have not been vacuumed ...