From: | pilum(dot)70(at)uni-muenster(dot)de |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6751: usage flaws in pg_restore |
Date: | 2012-07-24 12:45:56 |
Message-ID: | E1SteUu-0002ER-Nm@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 6751
Logged by: Arne Scheffer
Email address: pilum(dot)70(at)uni-muenster(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-07-25 01:21:06 | Re: [BUGS] BUG #6748: sequence value may be conflict in some cases |
Previous Message | Jeff Davis | 2012-07-24 00:16:01 | event triggers patch breaks with -DCLOBBER_CACHE_ALWAYS |