The following bug has been logged on the website: Bug reference: 6751 Logged by: Arne Scheffer Email address: pilum...@uni-muenster.de PostgreSQL version: 9.1.4 Operating system: Unix (RHEL 6) Description:
We've been using PostgreSQL for years now. It's great. Only the usage of pg_restore is annoying (Version 8.3 to 9.1 tested). Please fix the following issues: a.) pg_dump -f sdfsdf.dump sdfsdf pg_restore -d sdfsdf sdfsdf.dump Given Answer: pg_restore: [archiver] input file does not appear to be a valid archive (The User ist shocked. Dump possibly corrupted may be considered.) Better: pg_restore: no archive, plain SQL-File detected, use psql -f instead (or \i from console) b.) pg_restore --create -d sdfsdf sdfsdf.dump (Dump also correctly using sdfsdf as name in the SQL commands as documented) Given answer: Database 'sdfsdf' does not exist. (The User is confused, because therefore --create was used.) Better: Simply make the intended happen. Workaround: Tell the user in the answer how to use template0 as intended. Many newcomers to PostgreSQL will appreciate that fix (and we could shorten our introductions ;-)). At least these issues should be mentioned in the documentation. Thank you in advance Arne Scheffer Abteilung 3 ZIV Muenster University -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
