Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51352=pgsql-performance-ar@postgresql.org>)
 id 1WSJEj-0005PS-3k
 for pgsql-performance@arkaria.postgresql.org; Tue, 25 Mar 2014 04:45:17 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51352=pgsql-performance-ar@postgresql.org>)
 id 1WSJEi-0004OV-Dv
 for pgsql-performance@arkaria.postgresql.org; Tue, 25 Mar 2014 04:45:16 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <limpcaca@yahoo.com>) id 1WSJEg-0004NQ-34
 for pgsql-performance@postgresql.org; Tue, 25 Mar 2014 04:45:14 +0000
Received: from n11-vm10.bullet.mail.bf1.yahoo.com ([66.196.81.201])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <limpcaca@yahoo.com>) id 1WSJEc-0004ZK-Vu
 for pgsql-performance@postgresql.org; Tue, 25 Mar 2014 04:45:13 +0000
Received: from [66.196.81.176] by n11.bullet.mail.bf1.yahoo.com with NNFMP;
 25 Mar 2014 04:45:09 -0000
Received: from [98.139.212.230] by t6.bullet.mail.bf1.yahoo.com with NNFMP;
 25 Mar 2014 04:45:09 -0000
Received: from [127.0.0.1] by omp1039.mail.bf1.yahoo.com with NNFMP;
 25 Mar 2014 04:45:09 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 437936.21736.bm@omp1039.mail.bf1.yahoo.com
Received: (qmail 62775 invoked by uid 60001); 25 Mar 2014 04:45:09 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
 t=1395722709; bh=AAHq6RtWfiF7kEU+RtH1Rd8Y97Eun/bBBp5oqptbbdo=;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
 b=WC0JQmWUQT/vjlh4CrGxOILdVh0ltKRG/r0PrVNlwh9+0T5s0YBdwLlJt7E5Lsc24fpyjoIpZ6ZSVT4XUG3KR8keCCsqAeybI7FKkbo5FXHdKaw3jSdKha85lAeSkF8XwGHFuisKbNbSymGGYy97G5Dc8229FOsZMSe4R+kw5aY=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
 b=CK+U7aArO9hAVKOhWCGkXMWp173F8WnGoOxNiYR92X3DpVXqa9cbIyMGSJ9exF6nVX7g0GB4ldSyCp90klZwdqgo+kGime9XOY8n3NEx3z+U1gov7xILi9HH0z1lup7DYeMBZ4M5uStO+kLWEwsWcuneVw1Ti96KnjMyM/bAZqI=;
X-YMail-OSG: YNgTPeUVM1maBY7zAEJVWJoQT7MsCPeIedFrXtICJRETefF
 CDZ5ZB_Hyw67D92Ez89D9jLKU5tUppB.DfSRpdNGUD0TFVcbKQfTsGzCpQAk
 PYN9rqnRQnlrChffjS70FRzqGfs9Ir7uZHSKiF87q0RYi3ifEAKIWBr0cXBD
 qIX2zFBRhnrZS0yDg6MnFHHBpRJHe6dn8UyjTaVVVN8OL5B6.t.yuRukYoLa
 RRoCA3uXSbq5mr8wBjYSHPgdGS5KmjLUXLe74VANvJvdNCtKSR_C8htkBwfj
 zuxsMb_UMjvxaBXYTe_K4NjF84Ei3XDG22ymfWsP1OwZMZLVcqpEnq20wJtS
 JRx._98mYRgwliqLCYaBlYyEWW4j_KtQv1tf7lHNbYXqRP.UyzQk0OAz8OzO
 XP4xVga1HKgf9YzqzE2kRQX5m63KpyhXKoTsDwxLFsF7hPDvT1hwh3EIKwhI
 tFC.t8UlhZ1XBzVPJ0lwXWJSAyHAQPzpYtAzm4gPvws6GTQ6FJuF9gfhb7jc
 XPgWnogoj8OOvpEgm7ztOaoFlGXsrFLczRRU7T43ADj4wjzyqtVQ13NE1
Received: from [175.143.5.126] by web161601.mail.bf1.yahoo.com via HTTP;
 Mon, 24 Mar 2014 21:45:09 PDT
X-Rocket-MIMEInfo: 002.001,
 SGFpLAoKQ2FuIGFueW9uZSB0ZWxsIG1lIHRoZSBkaWZmZXJlbmNlIGFuZCBwZXJmb3JtYW5jZSBiZXR3ZWVuIHBnZHVtcCBhbmQgcGdfYmFzZWJhY2t1cCBpZiBJIHdhbnQgdG8gYmFja3VwIGEgbGFyZ2UgZGF0YWJhc2UuCgpUaGFua3MKATABAQEB
X-Mailer: YahooMailWebService/0.8.181.645
Message-ID: <1395722709.28433.YahooMailNeo@web161601.mail.bf1.yahoo.com>
Date: Mon, 24 Mar 2014 21:45:09 -0700 (PDT)
From: gianfranco caca <limpcaca@yahoo.com>
Reply-To: gianfranco caca <limpcaca@yahoo.com>
Subject: pg_dump vs pg_basebackup
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="-83809723-1750613254-1395722709=:28433"
X-Pg-Spam-Score: 0.2 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

---83809723-1750613254-1395722709=:28433
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hai,=0A=0ACan anyone tell me the difference and performance between pgdump =
and pg_basebackup if I want to backup a large database.=0A=0AThanks=0A
---83809723-1750613254-1395722709=:28433
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:ti=
mes new roman, new york, times, serif;font-size:12pt"><div>Hai,</div><div><=
br></div><div style=3D"color: rgb(0, 0, 0); font-size: 16px; font-family: t=
imes new roman,new york,times,serif; background-color: transparent; font-st=
yle: normal;">Can anyone tell me the difference and performance between pgd=
ump and pg_basebackup if I want to backup a large database.</div><div style=
=3D"color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new =
york,times,serif; background-color: transparent; font-style: normal;"><br><=
/div><div style=3D"color: rgb(0, 0, 0); font-size: 16px; font-family: times=
 new roman,new york,times,serif; background-color: transparent; font-style:=
 normal;">Thanks<br></div></div></body></html>
---83809723-1750613254-1395722709=:28433--