X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5B923D1EBD6 for ; Fri, 19 Mar 2004 16:21:23 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 63420-10 for ; Fri, 19 Mar 2004 12:21:10 -0400 (AST) Received: from ecintweb.eldocomp.com (smtp.eldocomp.com [205.159.99.8]) by svr1.postgresql.org (Postfix) with ESMTP id 0CD4CD1EC12 for ; Fri, 19 Mar 2004 12:21:08 -0400 (AST) Received: by ecintweb.eldocomp.com with XWall v3.29 ; Fri, 19 Mar 2004 09:20:59 -0700 From: Naomi Walker To: "Mark M. Huber" Cc: "pgsql-admin@postgresql.org" Subject: Re: backup and recovery Date: Fri, 19 Mar 2004 09:20:57 -0700 X-Assembled-By: XWall v3.29 X-Mailer: QUALCOMM Windows Eudora Version 5.1 Message-ID: <5.1.0.14.2.20040319091720.0dc9be00@imap.eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/264 X-Sequence-Number: 12833 At 01:08 PM 3/18/2004, Mark M. Huber wrote: >Hi all I am reasonable new to postgres so any direction that you can give= =20 >in the regards I am sure will be helpful so thanks very much in advance. > >I am not sure if I am doing something wrong or what exactly is going on. I= =20 >have a db that I pg_dumped some tables out of and trying to recover them= =20 >has taken more than 15 hours and these tables only one of them has over=20 >500,000 rows so what am I missing? > >It seams that any backup and recovery sucks. My main db backup takes over= =20 >two hours to complete and 13 hours to recover what am I doing wrong? Any= =20 >hints?ideas? Recommendations? I'd expect this would take something more like 10 minutes. Things to=20 check, are you recovering in the same instance? Another machine? I've=20 noticed some funkyness when the table exists, but is emptied. I'd drop the= =20 tables and recreate. Also, it often goes much faster is you load without= =20 indexes, and create them later. You might also want to adjust your shared= =20 memory parameters up some, but you have to restart the postmaster for it to= =20 take effect. There is definitely something wrong, because i've seen recovery to be=20 pretty darn fast. >________________________________________ >Mark M. Huber >DataBase Administrator >(702)-938-9300 >markh@vmdirect.com >http://www.vmdirect.com >3035 E. Patrick Lane >Suite #1 >Las Vegas, NV 89120 > > <> > ---------------------------------------------------------------------------= ---------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100 ---------------------------------------------------------------------------= ---------------------------------------------- Forget past mistakes. Forget failures. Forget everything except what you're= =20 going to do now and do it. - William Durant, founder of General Motors ---------------------------------------------------------------------------= --------------------------------------------- -- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to w= hom it is addressed, and may contain information that is privileged, confid= ential and exempt from disclosure under applicable law. If you are not the = intended addressee, nor authorized to receive for the intended addressee, y= ou are hereby notified that you may not use, copy, disclose or distribute t= o anyone the message or any information contained in the message. If you ha= ve received this message in error, please immediately advise the sender by = reply email, and delete the message. Thank you.