From robertngo@perridot.com Sun Oct 2 12:06:58 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 95341D9755 for ; Sun, 2 Oct 2005 09:06:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56095-06 for ; Sun, 2 Oct 2005 12:06:51 +0000 (GMT) Received: from ns2.perridot.com (unknown [202.71.97.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3BBECD8EF0 for ; Sun, 2 Oct 2005 09:06:45 -0300 (ADT) Received: (qmail 2342 invoked by uid 503); 2 Oct 2005 12:06:53 -0000 Received: from 219.95.155.184 by ns2.perridot.com (envelope-from , uid 108) with qmail-scanner-1.24-st-qms (iscan: v3.1/v7.000-1011/867/109226. spamassassin: 3.0.2. perlscan: 1.24-st-qms. Clear:RC:0(219.95.155.184):. Processed in 0.752791 secs); 02 Oct 2005 12:06:53 -0000 Received: from unknown (HELO 965b9bb7cd27414) (robertngo@perridot.com@219.95.155.184) by mail.tanahmas.com.my with SMTP; 2 Oct 2005 12:06:52 -0000 From: "Robert Ngo" To: Subject: backup software for postgresql Date: Sun, 2 Oct 2005 20:06:25 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C5C78C.D4187A50" X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcXHSbZIyo40rDeXR3CV04CqCXbBaQ== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Qmail-Scanner-Message-ID: <112825481310552334@ns2.perridot.com> Message-Id: <20051002120645.3BBECD8EF0@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.045 required=5 tests=[AWL=-0.660, HTML_MESSAGE=0.001, MSGID_FROM_MTA_ID=1.704] X-Spam-Level: * X-Archive-Number: 200510/5 X-Sequence-Number: 19077 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C5C78C.D4187A50 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, Which backup software out there work well with postgresql, I cannot find one with backup agent for postgres. I am looking for a backup solution that will backup the postgres database from a fiber channel san to a fiber channel tape library, any one here have experience with similar setup? ------=_NextPart_000_0000_01C5C78C.D4187A50 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

Which backup software out there work well with = postgresql, I cannot find one with backup agent for = postgres.

 

I am looking for a backup solution that will backup = the postgres database from a fiber channel san to a fiber channel tape = library, any one here have experience with similar = setup?

------=_NextPart_000_0000_01C5C78C.D4187A50-- From uwe@oss4u.com Sun Oct 2 23:04:30 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3CFCED998C for ; Sun, 2 Oct 2005 20:04:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51811-09 for ; Sun, 2 Oct 2005 23:04:27 +0000 (GMT) Received: from solanne.parasun.net (solanne.parasun.net [204.174.16.15]) by svr1.postgresql.org (Postfix) with ESMTP id A293BD995F for ; Sun, 2 Oct 2005 20:04:27 -0300 (ADT) Received: from dynamic-204-95-16-127.sanbrunocable.com ([204.95.16.127] helo=oss4u.com) by solanne.parasun.net with smtp (Exim 4.43) id 1EMCse-00010Y-Lw for pgsql-admin@postgresql.org; Sun, 02 Oct 2005 16:04:30 -0700 Received: (qmail 32258 invoked from network); 2 Oct 2005 22:57:25 -0000 Received: from tiburon.oss4u.com (192.168.1.4) by gw.oss4u.com (192.168.1.1) with ESMTP; 02 Oct 2005 22:57:25 -0000 From: "Uwe C. Schroeder" To: pgsql-admin@postgresql.org Subject: Re: backup software for postgresql Date: Sun, 2 Oct 2005 16:04:22 -0700 User-Agent: KMail/1.7.1 Cc: "Robert Ngo" References: <20051002120645.3BBECD8EF0@svr1.postgresql.org> In-Reply-To: <20051002120645.3BBECD8EF0@svr1.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200510021604.22876.uwe@oss4u.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.23 required=5 tests=[AWL=0.180, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/6 X-Sequence-Number: 19078 I'm going the easy route with that one. I do a full dump every night - which goes to tape (using any type of tape backup software) and is mirrored to another machine using rdist. For continuous backup I use Slony to replicate the master database to two off-site backup servers. That way there are 3 live copies and one daily copy at any given time - although I never needed a backup (knock on wood). UC On Sunday 02 October 2005 05:06, Robert Ngo wrote: > Hi, > > > > Which backup software out there work well with postgresql, I cannot find > one with backup agent for postgres. > > > > I am looking for a backup solution that will backup the postgres database > from a fiber channel san to a fiber channel tape library, any one here have > experience with similar setup? -- Open Source Solutions 4U, LLC 2570 Fleetwood Drive Phone: +1 650 872 2425 San Bruno, CA 94066 Cell: +1 650 302 2405 United States Fax: +1 650 872 2417 From bill.footcow@gmail.com Sun Oct 2 23:36:59 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 981E5D95CF for ; Sun, 2 Oct 2005 20:36:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63279-04 for ; Sun, 2 Oct 2005 23:35:42 +0000 (GMT) Received: from smtp4-g19.free.fr (smtp4-g19.free.fr [212.27.42.30]) by svr1.postgresql.org (Postfix) with ESMTP id 695E7D94F8 for ; Sun, 2 Oct 2005 20:35:43 -0300 (ADT) Received: from [192.168.0.1] (tru75-6-82-240-32-109.fbx.proxad.net [82.240.32.109]) by smtp4-g19.free.fr (Postfix) with ESMTP id 3E3102BEF6; Mon, 3 Oct 2005 01:35:40 +0200 (CEST) From: =?iso-8859-15?q?Herv=E9_Piedvache?= To: pgsql-admin@postgresql.org Subject: Re: backup software for postgresql Date: Mon, 3 Oct 2005 01:35:38 +0200 User-Agent: KMail/1.8.2 Cc: "Robert Ngo" References: <20051002120645.3BBECD8EF0@svr1.postgresql.org> In-Reply-To: <20051002120645.3BBECD8EF0@svr1.postgresql.org> X-Face: Q~R=,(z%>18cais1AC25|#(q>ihP; 4[0^5ZM!|rrF`; J\cq%{ei$`jaEfrxkS9NtP{X'KUd]\gZGcj3#r|*.[; @'w}feV"=?utf-8?q?=607=607j=60=7E=0A=09f7=7EF?=){$[oAPG)?M2ro}dZKHoYd8P?1JTUr$>6@G0yQV9Y\FNpONS+i.Y1M{=eAFuJo6.}6d-k:zp+_*@/mec@(<=?utf-8?q?=5B=26*aFBsp*FRX8=24=0A=09=27czo-6h=23kce+f?=(Z?KlRecYCEEb,vA{Lq MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200510030135.38540.bill.footcow@gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-1.321 required=5 tests=[AWL=-1.321] X-Spam-Level: X-Archive-Number: 200510/7 X-Sequence-Number: 19079 Hi, Arkeia do this ... but the PostregSQL agent is not free. regards, Le Dimanche 2 Octobre 2005 14:06, Robert Ngo a =E9crit : > Hi, > > > > Which backup software out there work well with postgresql, I cannot find > one with backup agent for postgres. > > > > I am looking for a backup solution that will backup the postgres database > from a fiber channel san to a fiber channel tape library, any one here ha= ve > experience with similar setup? =2D-=20 Herv=E9 Piedvache From lst_hoe01@kwsoft.de Mon Oct 3 10:35:36 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BD149D9E2E for ; Mon, 3 Oct 2005 07:35:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67421-07 for ; Mon, 3 Oct 2005 10:35:32 +0000 (GMT) Received: from mailin.kwsoft.de (mailin.kwsoft.de [213.164.67.82]) by svr1.postgresql.org (Postfix) with ESMTP id A2C9BD9E06 for ; Mon, 3 Oct 2005 07:35:32 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailin.kwsoft.de (Postfix) with ESMTP id F3AC751DC1 for ; Mon, 3 Oct 2005 12:35:30 +0200 (CEST) Received: from mail.79365-rheinhausen.de (mail.79365-rheinhausen.de [213.240.180.221]) by webmail.kwsoft.de (Horde MIME library) with HTTP; Mon, 03 Oct 2005 12:35:30 +0200 Message-ID: <20051003123530.55yxxtwrj3ks8scg@webmail.kwsoft.de> Date: Mon, 03 Oct 2005 12:35:30 +0200 From: lst_hoe01@kwsoft.de To: pgsql-admin@postgresql.org Subject: Re: backup software for postgresql References: <20051002120645.3BBECD8EF0@svr1.postgresql.org> In-Reply-To: <20051002120645.3BBECD8EF0@svr1.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.0.3-RC1) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.055 required=5 tests=[FROM_ENDS_IN_NUMS=0.516, FROM_HAS_ULINE_NUMS=0.361, NO_REAL_NAME=0.178] X-Spam-Level: * X-Archive-Number: 200510/27 X-Sequence-Number: 19099 Zitat von Robert Ngo : > Hi, > > > > Which backup software out there work well with postgresql, I cannot find one > with backup agent for postgres. > > > > I am looking for a backup solution that will backup the postgres database > from a fiber channel san to a fiber channel tape library, any one here have > experience with similar setup? > There are a number of products which can do this : http://www.bakbone.com/products/backup_and_restore/ http://www.sep.de/sesam/overview_us.php and maybe many others. Regards Andreas > From cbbrowne@acm.org Wed Oct 5 16:04:24 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B1778DA22A for ; Wed, 5 Oct 2005 13:04:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42599-07 for ; Wed, 5 Oct 2005 16:04:19 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 2DC79DA220 for ; Wed, 5 Oct 2005 13:04:19 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j95G4Iam072746 for ; Wed, 5 Oct 2005 16:04:18 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j95G45jC072480 for pgsql-admin@postgresql.org; Wed, 5 Oct 2005 16:04:05 GMT (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: backup software for postgresql Date: Wed, 05 Oct 2005 12:00:19 -0400 Organization: cbbrowne Computing Inc Lines: 14 Message-ID: <60ek70lzsc.fsf@dba2.int.libertyrms.com> References: <20051002120645.3BBECD8EF0@svr1.postgresql.org> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.17 (Jumbo Shrimp, linux) Cancel-Lock: sha1:/c0xVimA8v5nR4+XtUi/onQ+QXk= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.482 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.338] X-Spam-Level: X-Archive-Number: 200510/70 X-Sequence-Number: 19142 robertngo@perridot.com ("Robert Ngo") writes: > Which backup software out there work well with postgresql, I cannot > find one with backup agent for postgres.:p> You don't need one. You can simply schedule a job that runs "pg_dump" every so often (daily is common) to save data to a file. Most competent backup systems can backup data in files, so can pull the pg_dump output... -- let name="cbbrowne" and tld="ntlug.org" in name ^ "@" ^ tld;; http://www3.sympatico.ca/cbbrowne/backup.html "sic transit discus mundi" -- From the System Administrator's Guide, by Lars Wirzenius From apogoreliy@gmail.com Tue Jun 23 15:41:31 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z7QKJ-0005jx-2V for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2015 15:41:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Z7QKI-0001jo-I1 for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2015 15:41:30 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Z6yH4-0000cn-Ad for pgsql-admin@postgresql.org; Mon, 22 Jun 2015 09:44:18 +0000 Received: from mbob.nabble.com ([162.253.133.15]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1Z6yH0-00083y-Vr for pgsql-admin@postgresql.org; Mon, 22 Jun 2015 09:44:16 +0000 Received: from msam.nabble.com (unknown [162.253.133.85]) by mbob.nabble.com (Postfix) with ESMTP id D7B42F7EEFE for ; Mon, 22 Jun 2015 02:44:46 -0700 (PDT) Date: Mon, 22 Jun 2015 02:44:13 -0700 (MST) From: apogoreliy To: pgsql-admin@postgresql.org Message-ID: <1434966253784-5854682.post@n5.nabble.com> In-Reply-To: <20051002120645.3BBECD8EF0@svr1.postgresql.org> References: <20051002120645.3BBECD8EF0@svr1.postgresql.org> Subject: Re: backup software for postgresql MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.3 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Robert Ngo wrote > Hi, > > > > Which backup software out there work well with postgresql, I cannot find > one > with backup agent for postgres. > > > > I am looking for a backup solution that will backup the postgres database > from a fiber channel san to a fiber channel tape library, any one here > have > experience with similar setup? I would like to recommend this tool to backup postgresql database scheduled - PostgreSQL Backup http://postgresql-backup.com/ PostgreSQL Backup runs on Windows machine and backups remote PostgreSQL databases via TCP/IP connection. -- View this message in context: http://postgresql.nabble.com/backup-software-for-postgresql-tp2078003p5854682.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin From scott_ribe@elevated-dev.com Tue Jun 23 16:19:16 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z7Quq-00079L-7s for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2015 16:19:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Z7Qup-0000pS-KJ for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2015 16:19:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Z7Quo-0000pB-NN for pgsql-admin@postgresql.org; Tue, 23 Jun 2015 16:19:14 +0000 Received: from mailout.easymail.ca ([64.68.201.169]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Z7Qul-0000Fd-8C for pgsql-admin@postgresql.org; Tue, 23 Jun 2015 16:19:14 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 794F3E2B8; Tue, 23 Jun 2015 12:19:07 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at mailout.easymail.ca X-Spam-Flag: NO X-Spam-Score: -3.86 X-Spam-Level: X-Spam-Status: No, score=-3.86 required=5 tests=[ALL_TRUSTED=-1.8, AWL=-0.153, BAYES_00=-2.599, DNS_FROM_AHBL_RHSBL=0.692] Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (easymail-mailout.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id nUBMnlSnpjtg; Tue, 23 Jun 2015 12:19:06 -0400 (EDT) Received: from [192.168.2.16] (unknown [8.39.228.5]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 5E08FE239; Tue, 23 Jun 2015 12:19:06 -0400 (EDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2098\)) Subject: Re: backup software for postgresql From: Scott Ribe In-Reply-To: <1434966253784-5854682.post@n5.nabble.com> Date: Tue, 23 Jun 2015 10:19:03 -0600 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit Message-Id: References: <20051002120645.3BBECD8EF0@svr1.postgresql.org> <1434966253784-5854682.post@n5.nabble.com> To: apogoreliy X-Mailer: Apple Mail (2.2098) X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Jun 22, 2015, at 3:44 AM, apogoreliy wrote: > > I would like to recommend this tool to backup postgresql database scheduled > - PostgreSQL Backup http://postgresql-backup.com/ PostgreSQL Backup runs on > Windows machine and backups remote PostgreSQL databases via TCP/IP > connection. And it uses pg_dump, thus not solving OP's problem with pg_dump failing. -- Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ https://www.linkedin.com/in/scottribe/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin