Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WSLeH-0002LV-GJ for pgsql-performance@arkaria.postgresql.org; Tue, 25 Mar 2014 07:19:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WSLeH-0003VZ-0d for pgsql-performance@arkaria.postgresql.org; Tue, 25 Mar 2014 07:19:49 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WSLeF-0003VS-Mn for pgsql-performance@postgresql.org; Tue, 25 Mar 2014 07:19:47 +0000 Received: from nm24-vm0.bullet.mail.bf1.yahoo.com ([98.139.213.161]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WSLeC-0008W2-Lw for pgsql-performance@postgresql.org; Tue, 25 Mar 2014 07:19:47 +0000 Received: from [98.139.212.153] by nm24.bullet.mail.bf1.yahoo.com with NNFMP; 25 Mar 2014 07:19:44 -0000 Received: from [98.139.212.200] by tm10.bullet.mail.bf1.yahoo.com with NNFMP; 25 Mar 2014 07:19:44 -0000 Received: from [127.0.0.1] by omp1009.mail.bf1.yahoo.com with NNFMP; 25 Mar 2014 07:19:43 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 991265.97761.bm@omp1009.mail.bf1.yahoo.com Received: (qmail 73288 invoked by uid 60001); 25 Mar 2014 07:19:43 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1395731983; bh=kt3D2xoreg358tm1i72++ncIgCqrSccLsQ97mGwz2Ik=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=GTmc6ctq+GeIZ+GItNAkpwpDPtJEPulwwQaOP6bks3UDPVjHOkkZF/p26juIvWCCd/SjJ8rfZ818G47VIAQrVPBNhHyRE5mmlsnQnC1O2+kst6bPB3A0sKdGmJZsYvsAsnXneuppKs3o3z4LdJ447grj1RYKqV8NW6CrrpBaLfs= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=r3kZs5OL9hD14flmRsN8A5K4DFJMKfpYvqUslaXeO0WaAtGkjBSsOHEd+kLD4FLg3yw7hy/iWtf+tTZUHS+JOdH58c18Eq2m91CPdT1IT9Fc64uoo5qxlFO8pnp8xIY4ggt6g65YPQFQd2VdbYmVKyMNcXDiCyC1pZZRs+D2p0I=; X-YMail-OSG: dZmU7ZcVM1kESQAynGTsHy0sqMkpPIm27pMyWbLXh1.OurK g5KvLza5cGCu6cXCN1D7j9cCMXdwXOeJ6zBfCDIOvLDPmlvmqDSRmKLTBhyZ _ednRhIycVLqjevC5FjdMWOKlb3MTlYRVw5awh4N5.QpOdZQtRxU5qllnQ.X Sh4GgaeuLGg.8xQfWrLqzy71YB2S.HplM7SqOURf44whhb1utFUOqK0dFZdJ gEjpK511T5Dk_1FvJ3bybe3kPwe30IhQQqrReTgrIF1f6pwBmIzmCybD__C0 Z3maTliNv_l3mQY5N5UboPHLkSsTvK3fA0s9VG79tCVxEAX84LJnS4QVNeFW nGKlEMnsLX7lDI5z7VXIRStk.qPTSgtAylENlKfSp9km92XJWPl73lVcxx3_ 3kQOcw6_BEwV.KDIOUXFkiDG8Joep8bqNAAbeIAalbTIwpzfgmqxEj4VGKo8 qbksS6WM7nBqy3JE77tE7cm2JJ3kvYattKrBjhB8wPTA2P3xSQX4V_zyXgs3 Uel9cxRuO_zmKV34fmqaA_x.uZB9p.XNkfAA6PCre9bu5yLKD1pfqLT6ChmX vUT986ZKfg_vZ6GSfcqWXGOgak6KuH1dbUXQqswiO4NcVO5siJFztpxjdqF3 V7ZCLydNQVwmAFhAdLmQiJ_xQ5Ss- Received: from [175.143.5.126] by web161602.mail.bf1.yahoo.com via HTTP; Tue, 25 Mar 2014 00:19:43 PDT X-Rocket-MIMEInfo: 002.001, SGFpIGlseWEsCgpUaGFua3MgZm9yIHRoZSByZXNwb25kLiBUaGUgZGF0YWJhc2UgaXMgZXN0aW1hdGVkIG92ZXIgMTAwZ2IgYW5kIHRoZSB3b3JrbG9hZCB3aWxsIGJlIGhpZ2guIENhbiB3ZSB1c2UgYSBwZ19iYXNlYmFja3VwIHdpdGggcGl0ciB0byByZXN0b3JlIGJhc2VkIG9uIHRyYW5zYWN0aW9uIHRpbWU_CgpUaGFua3MKCgoKCk9uIFR1ZXNkYXksIDI1IE1hcmNoIDIwMTQsIDE1OjEzLCBJbHlhIEtvc21vZGVtaWFuc2t5IDxpbHlhLmtvc21vZGVtaWFuc2t5QHBvc3RncmVzcWwtY29uc3VsdGluZy5jb20BMAEBAQE- X-Mailer: YahooMailWebService/0.8.181.645 References: <1395722709.28433.YahooMailNeo@web161601.mail.bf1.yahoo.com> Message-ID: <1395731983.63241.YahooMailNeo@web161602.mail.bf1.yahoo.com> Date: Tue, 25 Mar 2014 00:19:43 -0700 (PDT) From: gianfranco caca Reply-To: gianfranco caca Subject: Re: pg_dump vs pg_basebackup To: "ik@postgresql-consulting.com" Cc: "pgsql-performance@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="406169123-1223912721-1395731983=:63241" X-Pg-Spam-Score: -0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --406169123-1223912721-1395731983=:63241 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hai ilya,=0A=0AThanks for the respond. The database is estimated over 100gb= and the workload will be high. Can we use a pg_basebackup with pitr to res= tore based on transaction time?=0A=0AThanks=0A=0A=0A=0A=0AOn Tuesday, 25 Ma= rch 2014, 15:13, Ilya Kosmodemiansky wrote:=0A =0AHi gianfranco,=0A=0A=0AHow exactly large is your dat= abase and how heavy is a workload on it?=0AUsually if you have more than ~2= 00Gb, better to use pg_basebackup=0Abecause pg_dump will take too long time= . And please take in mind, that=0Apg_dump makes dump, which is=A0 actually = not the same thing as a backup.=0A=0ABest regards,=0AIlya=0A=0A=0AOn Tue, M= ar 25, 2014 at 5:45 AM, gianfranco caca wrote:=0A> Hai= ,=0A>=0A> Can anyone tell me the difference and performance between pgdump = and=0A> pg_basebackup if I want to backup a large database.=0A>=0A> Thanks= =0A=0A=0A=0A-- =0AIlya Kosmodemiansky,=0A=0APostgreSQL-Consulting.com=0Atel= . +14084142500=0Acell. +4915144336040=0Aik@postgresql-consulting.com=0A=0A= =0A-- =0ASent via pgsql-performance mailing list (pgsql-performance@postgre= sql.org)=0ATo make changes to your subscription:=0Ahttp://www.postgresql.or= g/mailpref/pgsql-performance --406169123-1223912721-1395731983=:63241 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hai ilya,

Than= ks for the respond. The database is estimated over 100gb and the workload w= ill be high. Can we use a pg_basebackup with pitr to restore based on trans= action time?

Thanks


On Tuesday, 25 March 2014, 15:13, Ilya Kosmodemiansky &= lt;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 tim= e. And please take in mind, that
pg_dump makes dump, whic= h is  actually not the same thing as a backup.

Best regards,
Ilya




--
Ilya Kosmodemiansky,

Pos= tgreSQL-Consulting.com
tel. +14084142500
cell. +4915144336040
ik@postgresql-consulting.com


--
Sent = via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make change= s to your subscription:
http://www= .postgresql.org/mailpref/pgsql-performance



<= /div>
--406169123-1223912721-1395731983=:63241--