"Jim C. Nasby" <decibel(at)decibel(dot)org> 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