Re: Restore a PG database in Windows

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Restore a PG database in Windows
Дата
Msg-id 20051115172346.GA2410@kaufbach.delug.de
обсуждение исходный текст
Ответ на Restore a PG database in Windows  ("josh@segrestfarms.com" <josh@segrestfarms.com>)
Список pgsql-general
josh@segrestfarms.com <josh@segrestfarms.com> 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°

В списке pgsql-general по дате отправления:

Предыдущее
От: "josh@segrestfarms.com"
Дата:
Сообщение: Restore a PG database in Windows
Следующее
От: Bob Pawley
Дата:
Сообщение: Is it databases in general, SQL or Postgresql?