Re: Large Database Restore

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Large Database Restore
Дата
Msg-id 464CDD02.4060403@cox.net
обсуждение исходный текст
Ответ на Re: Large Database Restore  ("Michael Nolan" <htfoot@gmail.com>)
Ответы Re: Large Database Restore  ("Michael Nolan" <htfoot@gmail.com>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/17/07 16:49, Michael Nolan wrote:
> I don't know if my database is typical (as there probably is no such
> thing), but to restore a full dump (pg_dumpall) takes over 4 hours on my
> backup server, but to restore a low level backup (about 35GB)

Meaning a tarball of $PGDATA?

>                                                               and then
> process 145 WAL files (since Tuesday morning when the last low level
> backup was run) took me around 2 hours today

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGTN0BS9HxQb37XmcRArY4AKCzTzoe2XP1COyjpdWD+wGp5ACYoACfd9fx
336CjyTBXkgu/lXZewagcOA=
=+/58
-----END PGP SIGNATURE-----

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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: 8.0, UTF8, and CLIENT_ENCODING
Следующее
От: "Robert James"
Дата:
Сообщение: Privs on deleted objects