You only need to use pg_restore with archives that are not in the
plain-text sql format. You can just do this:
psql -f <filename> -U OfficeTalk OfficeTalk
to restore.
On Mon, 5 Mar 2007, Josef Springer wrote:
iI habe dumped a database with
pg_dump --file="<filename>" -a --schema="OfficeTalk" -h localhost -U
OfficeTalk "OfficeTalk"
Restoring it with
pg_restore -d "OfficeTalk" -a -h localhost -U "OfficeTalk" "<filename>"
i get the error
pg_restore: [archiver] input file does not appear to be a valid archive
What to do ?
mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)
[Postal]
Address
Josef.Springer@xxxxxxxxx
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
[Phone]
Office
+49 (0)89 600 6920
[Phone]
Fax
+49 (0)89 600 69220
[Web]
Web
http://www.joops.com
[JOOPS]
-- the software company --
--
Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
