From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
---|---|
To: | Josef Springer <Josef(dot)Springer(at)joops(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Can not restore a dumped database |
Date: | 2007-03-09 05:17:56 |
Message-ID: | Pine.LNX.4.64.0703082116300.11609@discord.home.frostconsultingllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 Gren / best regards,
> Josef Springer
> (Geschftsleitung/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
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2007-03-09 08:05:24 | Re: Pg_dump and bytaA |
Previous Message | Lukas | 2007-03-08 20:02:07 | Pg_dump and bytaA |