./pg_dump postgres -Fp -f textdump ./pg_restore -Fp -d postgres textdump pg_restore: error: unrecognized archive format "p"; please specify "c", "d", or "t"
./pg_restore -d postgres textdump pg_restore: error: input file appears to be a text format dump. Please use psql. wouldn't it be nice if we get the error message as same as when we didn't gave format option and pg_restore finds the format using _discoverArchiveFormat there it suggests to try psql ,instead of saying "p/plain text" format is a invalid format,as we are doing currently in pg. thoughts? Regards, Srinath Reddy Sadipiralla, EDB:http://www.enterprisedb.com