Re:

Поиск
Список
Период
Сортировка
От William Dunn
Тема Re:
Дата
Msg-id CAEva=V=ok1m9kRiFtaD8ww16Qrp0XDSL01gXGo5mwTdueKFxNQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re:  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список pgsql-general
Hello Sachin,

I hate to respond by suggesting an alternative but it may be good to try using pg_basebackup (Doc: http://www.postgresql.org/docs/9.1/static/app-pgbasebackup.html) to back-up your database. It takes a copy of the file system files rather than querying the data as an ordinary connection which is much faster. Straight file system backup is fast too but it may be more difficult to restore the database to a consistent state. At this point pg_dump is very good for exporting specific tables or schemas or for loading data into another dbms but it is slow and has a lot of overhead because of MVCC. pg_basebackup is faster, but does require you take a backup of the entire cluster.

Will J. Dunn

On Fri, May 15, 2015 at 8:09 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Sachin Srivastava wrote:
> How can I fast my daily pg_dump backup. Can I use parallel option(Which is introduced in Postgres 9.3)
> with Postgres 9.1. There is any way I can use this is for 9.1 database.

You cannot do that.

Switch to file system backup, that is much faster.

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: William Dunn
Дата:
Сообщение: Re: SELECT .. WHERE id IN(..)
Следующее
От: "ben.play"
Дата:
Сообщение: My index doesn't write anymore but read