From KARTHIKEYAN.Nagalingam@netapp.com Tue Mar 10 05:48:07 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 3DD5A632296; Tue, 10 Mar 2009 02:48:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 26099-01; Tue, 10 Mar 2009 02:47:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx2.netapp.com (mx2.netapp.com [216.240.18.37]) by mail.postgresql.org (Postfix) with ESMTP id C2FC6632D77; Tue, 10 Mar 2009 02:47:53 -0300 (ADT) X-IronPort-AV: E=Sophos;i="4.38,334,1233561600"; d="scan'208,217";a="138690827" Received: from smtp2.corp.netapp.com ([10.57.159.114]) by mx2-out.netapp.com with ESMTP; 09 Mar 2009 22:47:51 -0700 Received: from sacrsexc1-prd.hq.netapp.com (sacrsexc1-prd.hq.netapp.com [10.99.115.27]) by smtp2.corp.netapp.com (8.13.1/8.13.1/NTAP-1.6) with ESMTP id n2A5lpN2015291; Mon, 9 Mar 2009 22:47:51 -0700 (PDT) Received: from btcrsexc1-prd.hq.netapp.com ([10.73.251.109]) by sacrsexc1-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959); Mon, 9 Mar 2009 22:47:45 -0700 Received: from BTCMVEXC1-PRD.hq.netapp.com ([10.73.251.107]) by btcrsexc1-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 10 Mar 2009 11:17:44 +0530 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C9A143.BB92DB2A" Subject: postgres deployment Date: Tue, 10 Mar 2009 11:17:43 +0530 Message-ID: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35970@BTCMVEXC1-PRD.hq.netapp.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: postgres deployment Thread-Index: AcmhQ7tI1kXkPtUYSFC03VwpL0ETdQ== From: "Nagalingam, Karthikeyan" To: , X-OriginalArrivalTime: 10 Mar 2009 05:47:44.0347 (UTC) FILETIME=[BBDCF2B0:01C9A143] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/116 X-Sequence-Number: 31616 This is a multi-part message in MIME format. ------_=_NextPart_001_01C9A143.BB92DB2A Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, Can I know the effective solution to do the backup and recovery for Postgres in storage environment.=20 =20 Please share Any existing deployment and solution for backup and recovery for Postgres in storage =20 Any suggestion and recommendation are welcome. =20 Regards=20 Karthikeyan.N =20 =20 ------_=_NextPart_001_01C9A143.BB92DB2A Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Hi,
       Can I know the effective = solution to=20 do the backup and recovery for Postgres in storage environment.=20
 
Please share Any=20 existing deployment and solution for backup and recovery for Postgres in = storage
 
Any = suggestion and=20 recommendation are welcome.
 
Regards
Karthikeyan.N
 
 
------_=_NextPart_001_01C9A143.BB92DB2A-- From michael.monnerie@is.it-management.at Tue Mar 10 07:05:20 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id BB6EF632492 for ; Tue, 10 Mar 2009 04:05:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 45032-08 for ; Tue, 10 Mar 2009 04:05:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailsrv1.zmi.at (mailsrv1.zmi.at [212.69.162.198]) by mail.postgresql.org (Postfix) with ESMTP id 58B4562DDA8 for ; Tue, 10 Mar 2009 04:05:12 -0300 (ADT) Received: from mailsrv2.i.zmi.at (h081217054243.dyn.cm.kabsi.at [81.217.54.243]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (Client CN "mailsrv2.i.zmi.at", Issuer "power4u.zmi.at" (not verified)) by mailsrv1.zmi.at (Postfix) with ESMTP id 9ADC544B2 for ; Tue, 10 Mar 2009 08:05:09 +0100 (CET) Received: from saturn.localnet (saturn.i.zmi.at [10.0.0.2]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mailsrv2.i.zmi.at (Postfix) with ESMTPSA id D503840017E for ; Tue, 10 Mar 2009 08:05:09 +0100 (CET) From: Michael Monnerie Organization: it-management http://it-management.at To: pgsql-admin@postgresql.org Subject: Re: postgres deployment Date: Tue, 10 Mar 2009 08:05:09 +0100 User-Agent: KMail/1.10.3 (Linux/2.6.27.19-ZMI; KDE/4.1.3; x86_64; ; ) References: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35970@BTCMVEXC1-PRD.hq.netapp.com> In-Reply-To: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35970@BTCMVEXC1-PRD.hq.netapp.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200903100805.09616@zmi.at> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/117 X-Sequence-Number: 31617 On Dienstag 10 M=E4rz 2009 Nagalingam, Karthikeyan wrote: > Can I know the effective solution to do the backup and recovery > for Postgres in storage environment. Did you read this? http://www.postgresql.org/docs/8.3/static/warm-standby.html http://www.postgresql.org/docs/8.3/static/pgstandby.html http://scale-out-blog.blogspot.com/2009/02/simple-ha-with-postgresql-point-= in-time.html mfg zmi =2D-=20 // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 From KARTHIKEYAN.Nagalingam@netapp.com Tue Mar 10 07:12:47 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 64955632492 for ; Tue, 10 Mar 2009 04:12:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 46049-08 for ; Tue, 10 Mar 2009 04:12:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx2.netapp.com (mx2.netapp.com [216.240.18.37]) by mail.postgresql.org (Postfix) with ESMTP id 5EA76631FE0 for ; Tue, 10 Mar 2009 04:12:42 -0300 (ADT) X-IronPort-AV: E=Sophos;i="4.38,335,1233561600"; d="scan'208";a="138719579" Received: from smtp2.corp.netapp.com ([10.57.159.114]) by mx2-out.netapp.com with ESMTP; 10 Mar 2009 00:12:40 -0700 Received: from sacrsexc2-prd.hq.netapp.com (sacrsexc2-prd.hq.netapp.com [10.99.115.28]) by smtp2.corp.netapp.com (8.13.1/8.13.1/NTAP-1.6) with ESMTP id n2A7CYLw028608; Tue, 10 Mar 2009 00:12:40 -0700 (PDT) Received: from btcrsexc1-prd.hq.netapp.com ([10.73.251.109]) by sacrsexc2-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 10 Mar 2009 00:12:35 -0700 Received: from BTCMVEXC1-PRD.hq.netapp.com ([10.73.251.107]) by btcrsexc1-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 10 Mar 2009 12:41:49 +0530 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Re: postgres deployment Date: Tue, 10 Mar 2009 12:41:48 +0530 Message-ID: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35A12@BTCMVEXC1-PRD.hq.netapp.com> In-Reply-To: <200903100805.09616@zmi.at> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] postgres deployment Thread-Index: AcmhTq2n+NfK7uOqSzyQZlcYJmGBswAALJlg References: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35970@BTCMVEXC1-PRD.hq.netapp.com> <200903100805.09616@zmi.at> From: "Nagalingam, Karthikeyan" To: "Michael Monnerie" , X-OriginalArrivalTime: 10 Mar 2009 07:11:49.0503 (UTC) FILETIME=[7B02A8F0:01C9A14F] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/118 X-Sequence-Number: 31618 Nice link Michael Monnerie, Can I get any more suggestion from real = deployment...=20 Regards=20 Karthikeyan.N =20 -----Original Message----- From: Michael Monnerie [mailto:michael.monnerie@is.it-management.at]=20 Sent: Tuesday, March 10, 2009 12:35 PM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] postgres deployment On Dienstag 10 M=E4rz 2009 Nagalingam, Karthikeyan wrote: > Can I know the effective solution to do the backup and recovery for=20 > Postgres in storage environment. Did you read this? http://www.postgresql.org/docs/8.3/static/warm-standby.html http://www.postgresql.org/docs/8.3/static/pgstandby.html http://scale-out-blog.blogspot.com/2009/02/simple-ha-with-postgresql-poin= t-in-time.html mfg zmi --=20 // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make = changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin From simon@2ndQuadrant.com Tue Mar 10 08:50:56 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 9651F633226; Tue, 10 Mar 2009 05:50:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 68301-06; Tue, 10 Mar 2009 05:50:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128154.authsmtp.net (outmail128154.authsmtp.net [62.13.128.154]) by mail.postgresql.org (Postfix) with ESMTP id C49E56331DE; Tue, 10 Mar 2009 05:50:52 -0300 (ADT) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt3.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2A8omTg065803; Tue, 10 Mar 2009 08:50:48 GMT Received: from [192.168.0.3] (85-211-101-172.dyn.gotadsl.co.uk [85.211.101.172]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n2A8olIS074360; Tue, 10 Mar 2009 08:50:47 GMT Subject: Re: [GENERAL] postgres deployment From: Simon Riggs To: "Nagalingam, Karthikeyan" Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35970@BTCMVEXC1-PRD.hq.netapp.com> References: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35970@BTCMVEXC1-PRD.hq.netapp.com> Content-Type: text/plain Date: Tue, 10 Mar 2009 08:55:05 +0000 Message-Id: <1236675305.31880.359.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 8ca63315-0d50-11de-8156-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksachtFaQVbYFhD HGQLW11EUFV7XGN/ bw0fZQBDYEtPQQRq UVZIRVBNFgBqBAMB SEAcIxEtK3wleHl0 ZkBiEHFZWUI0fRUs RE1XFGgbZTNlaH0e URQNagtVdQVXfh9E a1h6AHAKZjZWKBg1 TUcAEB0XEA92DBEd WgYWMV0ITF1DEjMk QxcTGDgpASVf X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/119 X-Sequence-Number: 31619 On Tue, 2009-03-10 at 11:17 +0530, Nagalingam, Karthikeyan wrote: > Can I know the effective solution to do the backup and recovery > for Postgres in storage environment. > > Please share Any existing deployment and solution for backup and > recovery for Postgres in storage > > Any suggestion and recommendation are welcome. Postgres has sophisticated techniques for backup and recovery, proven in the field over many years. Please start here http://developer.postgresql.org/pgdocs/postgres/backup.html Integration is possible with 3rd party devices and software. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support From KARTHIKEYAN.Nagalingam@netapp.com Tue Mar 10 08:57:59 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 08880633226; Tue, 10 Mar 2009 05:57:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 70452-04; Tue, 10 Mar 2009 05:57:52 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx2.netapp.com (mx2.netapp.com [216.240.18.37]) by mail.postgresql.org (Postfix) with ESMTP id 064296331DE; Tue, 10 Mar 2009 05:57:48 -0300 (ADT) X-IronPort-AV: E=Sophos;i="4.38,335,1233561600"; d="scan'208";a="138743988" Received: from smtp2.corp.netapp.com ([10.57.159.114]) by mx2-out.netapp.com with ESMTP; 10 Mar 2009 01:57:45 -0700 Received: from sacrsexc2-prd.hq.netapp.com (sacrsexc2-prd.hq.netapp.com [10.99.115.28]) by smtp2.corp.netapp.com (8.13.1/8.13.1/NTAP-1.6) with ESMTP id n2A8vinZ015734; Tue, 10 Mar 2009 01:57:44 -0700 (PDT) Received: from btcrsexc1-prd.hq.netapp.com ([10.73.251.109]) by sacrsexc2-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 10 Mar 2009 01:57:44 -0700 Received: from BTCMVEXC1-PRD.hq.netapp.com ([10.73.251.107]) by btcrsexc1-prd.hq.netapp.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 10 Mar 2009 14:27:05 +0530 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: [GENERAL] postgres deployment Date: Tue, 10 Mar 2009 14:27:04 +0530 Message-ID: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35A88@BTCMVEXC1-PRD.hq.netapp.com> In-Reply-To: <1236675305.31880.359.camel@ebony.2ndQuadrant> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [GENERAL] postgres deployment Thread-Index: AcmhXYye8MsXJyQjR5Wr7GgevnUHbgAAIlSg References: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35970@BTCMVEXC1-PRD.hq.netapp.com> <1236675305.31880.359.camel@ebony.2ndQuadrant> From: "Nagalingam, Karthikeyan" To: "Simon Riggs" Cc: , X-OriginalArrivalTime: 10 Mar 2009 08:57:05.0222 (UTC) FILETIME=[2F78E660:01C9A15E] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/120 X-Sequence-Number: 31620 Thanks Simon Riggs, I am following the same. Can I get some real time backup solution in production. =20 Regards=20 Karthikeyan.N =20 -----Original Message----- From: Simon Riggs [mailto:simon@2ndQuadrant.com]=20 Sent: Tuesday, March 10, 2009 2:25 PM To: Nagalingam, Karthikeyan Cc: pgsql-general@postgresql.org; pgsql-admin@postgresql.org Subject: Re: [GENERAL] postgres deployment On Tue, 2009-03-10 at 11:17 +0530, Nagalingam, Karthikeyan wrote: > Can I know the effective solution to do the backup and recovery > for Postgres in storage environment. > =20 > Please share Any existing deployment and solution for backup and=20 > recovery for Postgres in storage > =20 > Any suggestion and recommendation are welcome. Postgres has sophisticated techniques for backup and recovery, proven in the field over many years. Please start here http://developer.postgresql.org/pgdocs/postgres/backup.html Integration is possible with 3rd party devices and software. --=20 Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support From scott.marlowe@gmail.com Tue Mar 10 09:42:40 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7E3F96351F8; Tue, 10 Mar 2009 06:42:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 81569-03; Tue, 10 Mar 2009 06:42:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.30]) by mail.postgresql.org (Postfix) with ESMTP id 617F963515B; Tue, 10 Mar 2009 06:42:34 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 5so1075963ywh.73 for ; Tue, 10 Mar 2009 02:42:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=TyZMrTK/cMw05f9km1lb3xhE9hryss6pX3bd7LDOZGw=; b=p7/pPrLHh7ZJDQwUm9JhMU3jkuFnaSvAzxZTv6eic4k5CjOPvW6Nv909Gx3tq0bFza 7LgwiTANML3WrbyxA2GNfBSdtLqZ7fMgJVM82lj5H29Hed9DdV/5DurWbkRt9yaYQ/s4 bqeZyJ+b3OT6e/5Ac6vRG7oE9NK5MOyvrgLHY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=d5b4FSXncb1i0TjEQPyzRTu/mDPHxaiYJApxx7FpHMHG7Ayr2o3KmnBo001Nlhky02 JkcxxlHhqWKDNtoCUxMmbuqygNbwdgCMlKn4/vV5RyhyDHByWzSIqrF+nR6SFnGOSSpx wrHI2u2j7PqXIjtodh9JDjt9Toj36mekoZHf4= MIME-Version: 1.0 Received: by 10.151.156.1 with SMTP id i1mr12551169ybo.247.1236678152583; Tue, 10 Mar 2009 02:42:32 -0700 (PDT) In-Reply-To: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35A88@BTCMVEXC1-PRD.hq.netapp.com> References: <5FFF8E9361C5D84EBBAF70C1931CDDE303A35970@BTCMVEXC1-PRD.hq.netapp.com> <1236675305.31880.359.camel@ebony.2ndQuadrant> <5FFF8E9361C5D84EBBAF70C1931CDDE303A35A88@BTCMVEXC1-PRD.hq.netapp.com> Date: Tue, 10 Mar 2009 03:42:32 -0600 Message-ID: Subject: Re: [GENERAL] postgres deployment From: Scott Marlowe To: "Nagalingam, Karthikeyan" Cc: Simon Riggs , pgsql-general@postgresql.org, pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/121 X-Sequence-Number: 31621 On Tue, Mar 10, 2009 at 2:57 AM, Nagalingam, Karthikeyan wrote: > Thanks Simon Riggs, I am following the same. > > Can I get some real time backup solution in production. I'm pretty sure that's what Michael Monnerie posted. Those ARE the strategies used in REAL deployments.