Skip site navigation (1) Skip section navigation (2)

Re: backup and recovery

From: Naomi Walker <nwalker(at)eldocomp(dot)com>
To: "Mark M(dot) Huber" <MHuber(at)VMdirect(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: backup and recovery
Date: 2004-03-19 16:20:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 
>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 
>have a db that I pg_dumped some tables out of and trying to recover them 
>has taken more than 15 hours and these tables only one of them has over 
>500,000 rows so what am I missing?
>It seams that any backup and recovery sucks. My main db backup takes over 
>two hours to complete and 13 hours to recover what am I doing wrong? Any 
>hints?ideas? Recommendations?

I'd expect this would take something more like 10 minutes.  Things to 
check, are you recovering in the same instance?  Another machine?  I've 
noticed some funkyness when the table exists, but is emptied.  I'd drop the 
tables and recreate.  Also, it often goes much faster is you load without 
indexes, and create them later.  You might also want to adjust your shared 
memory parameters up some, but you have to restart the postmaster for it to 
take effect.

There is definitely something wrong, because i've seen recovery to be 
pretty darn fast.

>Mark M. Huber
>DataBase Administrator
>3035 E. Patrick Lane
>Suite #1
>Las Vegas, NV 89120
>  <<Mark M. Huber.vcf>>

Naomi Walker                         Chief Information Officer
                                               Eldorado Computing, Inc.
nwalker(at)eldocomp(dot)com           602-604-3100
Forget past mistakes. Forget failures. Forget everything except what you're 
going to do now and do it.
- William Durant, founder of General Motors


This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.

pgsql-admin by date

Next:From: scott.marloweDate: 2004-03-19 16:48:43
Subject: Re: date style
Previous:From: scott.marloweDate: 2004-03-19 15:51:46
Subject: Re: Re-Init database cluster.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group