Backup very large databases

Поиск
Список
Период
Сортировка
От Nikolay Mihaylov
Тема Backup very large databases
Дата
Msg-id 000001c1e556$2854d180$97e309d9@protos
обсуждение исходный текст
Ответы Re: Backup very large databases  (Francisco Reyes <lists@natserv.com>)
Список pgsql-general
Hi all,

I have the following problem - when I;m backuping my database (4 GB+ is
single database) the website (is used from a web site) going too slow,
because of the backup.

Database is 7.0, pg_dump is from 7.2.1

Any ideas how I can make the process for backup to be with low priority,
or can I use second readonly!?!?!?! Postgres server on same machine?

Im also are interested to join/make? New group for very large postgres
databases. Is there other people that running simillar large databases?


-----------------------------------------------------------
The Reboots are for hardware upgrades,
Found more here: http://www.nmmm.nu
Nikolay Mihaylov nmmm@nmmm.nu


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

Предыдущее
От: "Miia Leino"
Дата:
Сообщение: ON DELETE CASCADE doesn't work
Следующее
От: tom dyson
Дата:
Сообщение: Java as PG Procedural Language