From: gianfranco caca <limpcaca@yahoo.com>
To: ik@postgresql-consulting.com <ik@postgresql-consulting.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: pg_dump vs pg_basebackup
Date: Tue, 25 Mar 2014 00:19:43 -0700 (PDT)
Message-ID: <1395731983.63241.YahooMailNeo@web161602.mail.bf1.yahoo.com> (raw)
In-Reply-To: <CAG95seUjO2Az7bgwz66RvAzfWNV-ApXd0B+CoFhc_jabsf6X2g@mail.gmail.com>
References: <1395722709.28433.YahooMailNeo@web161601.mail.bf1.yahoo.com>
<CAG95seUjO2Az7bgwz66RvAzfWNV-ApXd0B+CoFhc_jabsf6X2g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hai ilya,
Thanks for the respond. The database is estimated over 100gb and the workload will be high. Can we use a pg_basebackup with pitr to restore based on transaction time?
Thanks
On Tuesday, 25 March 2014, 15:13, Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com> wrote:
Hi gianfranco,
How exactly large is your database and how heavy is a workload on it?
Usually if you have more than ~200Gb, better to use pg_basebackup
because pg_dump will take too long time. And please take in mind, that
pg_dump makes dump, which is actually not the same thing as a backup.
Best regards,
Ilya
On Tue, Mar 25, 2014 at 5:45 AM, gianfranco caca <limpcaca@yahoo.com> wrote:
> Hai,
>
> Can anyone tell me the difference and performance between pgdump and
> pg_basebackup if I want to backup a large database.
>
> Thanks
--
Ilya Kosmodemiansky,
PostgreSQL-Consulting.com
tel. +14084142500
cell. +4915144336040
ik@postgresql-consulting.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: limpcaca@yahoo.com, ik@postgresql-consulting.com
Subject: Re: pg_dump vs pg_basebackup
In-Reply-To: <1395731983.63241.YahooMailNeo@web161602.mail.bf1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox