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