Re: - Mailing list pgsql-general

From William Dunn
Subject Re:
Date
Msg-id CAEva=V=ok1m9kRiFtaD8ww16Qrp0XDSL01gXGo5mwTdueKFxNQ@mail.gmail.com
Whole thread Raw
In response to Re:  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List 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 by date:

Previous
From: William Dunn
Date:
Subject: Re: SELECT .. WHERE id IN(..)
Next
From: "ben.play"
Date:
Subject: My index doesn't write anymore but read