On 2025-01-25 Sa 8:12 AM, Srinath Reddy wrote:
./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?
Probably not exactly the same, because in one case you're explicitly
saying it's a text dump. But maybe something closer would work, like
"text format not supported. Please use psql."
cheers
andrew
--
Andrew Dunstan
EDB: https://www.enterprisedb.com
