pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Can not restore a dumped database
2+ messages / 2 participants
[nested] [flat]

* Can not restore a dumped database
@ 2007-03-05 12:02  Josef Springer <Josef.Springer@joops.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Josef Springer @ 2007-03-05 12:02 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

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@joops.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 --


 

Attachments:

Postal.jpg (image/jpeg, 770B) download view image
Phone.jpg (image/jpeg, 802B) download view image
Phone.jpg (image/jpeg, 802B) download view image
Web.jpg (image/jpeg, 807B) download view image
Image120.jpg (image/jpeg, 7.6K) download view image
^ permalink raw reply [nested|flat] 2+ messages in thread

* Re: Can not restore a dumped database
@ 2007-03-09 05:17  Jeff Frost <jeff@frostconsultingllc.com>
  parent: Josef Springer <Josef.Springer@joops.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Jeff Frost @ 2007-03-09 05:17 UTC (permalink / raw)
  To: Josef Springer <Josef.Springer@joops.com>; +Cc: 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 Grüßen / best regards,
> Josef Springer
> (Geschäftsleitung/Management)
>
> [Postal]
> Address
> Josef.Springer@joops.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@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954


^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-03-09 05:17 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-05 12:02 Can not restore a dumped database Josef Springer <Josef.Springer@joops.com>
2007-03-09 05:17 ` Jeff Frost <jeff@frostconsultingllc.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox