Re: Large Database Restore

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Large Database Restore
Дата
Msg-id 20070518175524.GC15691@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Large Database Restore  (Richard Huxton <dev@archonet.com>)
Ответы Re: Large Database Restore  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Richard Huxton escribió:
> Alvaro Herrera wrote:
> >Lee Keel escribió:
> >>So then the best way to do this kind of backup\restore is to use pg_dump?
> >>Is there any plan in the future to be able to do some sort of file-level
> >>backup like SqlServer?
> >
> >Actually you can do single databases, but you must also include some
> >other directories besides the database directory.  You would need to
> >include everything, excluding things in the "base" directory, but not
> >exclude your databases directory in "base".
>
> Will that not cause trouble if you've added users though?

Huh, maybe it will, but then I don't see how.  Can you be more specific?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Large Database Restore
Следующее
От: Thomas Lopatic
Дата:
Сообщение: Re: Data replication through disk replication