Re: Can not restore a dumped database

[Jeff Frost <jeff(at)frostconsultingllc(dot)com>]

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(dot)Springer(at)joops(dot)com
> 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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954