Search Postgresql Archives

Re: Restore a PG database in Windows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



josh@xxxxxxxxxxxxxxxx <josh@xxxxxxxxxxxxxxxx> schrieb:

> I am having an extremely difficult time restoring the backup.gz I have on 
> my Desktop.

How is this backup.gz created?


> So, I tried using PSQL, but I'm still not having any luck.
> 
> Can anyone direct me to a good resource that explains how to go about 
> restoring a database on a Windows box?

Can you unzip the backup.gz and is this then plain ascii with plain sql?
If so, than you can call 'psql dbname < backup' (the unzipped file).

Sorry, i'm a linux-user, but i think, this should work under windows
too.

http://www.postgresql.org/docs/current/static/backup.html


HTH, Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux