Moving to -hackers. On Wed, May 17, 2006 at 12:13:49PM -0400, Tom Lane wrote: > "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.
Maybe it's time to look at improving pg_restore's ability to deal with cross-version issues, and make it the default for pg_dump. ISTM there's been a fair amount of contortions as of late around pg_dump SQL compatability. If the custom format at least included pg_dump version information, and pg_restore new what version of PostgreSQL it was restoring into, it could handle these cases more elegantly than is possible with just dumping straight into psql. Or it might make more sense for the custom format to be something that's less sensitive to some of these compatability issues. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(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
