"Tomeh, Husam" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
