Re: [DOCS] Mention pg_dump version portability

[Jim C. Nasby]

Grr, deleted Tom's email before I replied...

pg_dump -Fc | pg_restore will only match the output of pg_dump if
everything's the same version though, right? Or wrong? What happens if
pg_dump -Fc is and older version and pg_restore is the current version?

Or is the custom format the same as the text/SQL dump, just with some
fancy wrappers around it?
-- 
Jim C. Nasby, Database Architect[EMAIL PROTECTED] 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

---(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

Re: [DOCS] Mention pg_dump version portability

[Tom Lane]

"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> pg_dump -Fc | pg_restore will only match the output of pg_dump if
> everything's the same version though, right? Or wrong? What happens if
> pg_dump -Fc is and older version and pg_restore is the current version?

There would probably be some small differences, but 99% of pg_restore's
output is just regurgitating SQL it finds in the dump file.

regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly