pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brendan Duddridge <brendan@clickspace.com>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Recovery will take 10 hours
Date: Thu, 20 Apr 2006 17:11:01 -0600
Message-ID: <BCAE93E6-B799-4B6F-9F78-AA694342A169@clickspace.com> (raw)
In-Reply-To: <Pine.LNX.4.64.0604201419130.1527@glacier.frostconsultingllc.com>
References: <85A15B2E-F59C-4FEF-82D4-61F48ABDCDE5@clickspace.com>
	<Pine.LNX.4.64.0604201419130.1527@glacier.frostconsultingllc.com>

Hi Jeff,

The WAL files are stored on a separate server and accessed through an  
NFS mount located at /wal_archive.

However, the restore failed about 5 hours in after we got this error:

[2006-04-20 16:41:28 MDT] LOG: restored log file  
"000000010000018F00000034" from archive
[2006-04-20 16:41:35 MDT] LOG: restored log file  
"000000010000018F00000035" from archive
[2006-04-20 16:41:38 MDT] LOG: restored log file  
"000000010000018F00000036" from archive
sh: line 1: /wal_archive/000000010000018F00000037.gz: No such file or  
directory
[2006-04-20 16:41:46 MDT] LOG: could not open file "pg_xlog/ 
000000010000018F00000037" (log file 399, segment 55): No such file or  
directory
[2006-04-20 16:41:46 MDT] LOG: redo done at 18F/36FFF254
sh: line 1: /wal_archive/000000010000018F00000036.gz: No such file or  
directory
[2006-04-20 16:41:46 MDT] PANIC: could not open file "pg_xlog/ 
000000010000018F00000036" (log file 399, segment 54): No such file or  
directory
[2006-04-20 16:41:46 MDT] LOG: startup process (PID 9190) was  
terminated by signal 6
[2006-04-20 16:41:46 MDT] LOG: aborting startup due to startup  
process failure
[2006-04-20 16:41:46 MDT] LOG: logger shutting down



The /wal_archive/000000010000018F00000037.gz is there accessible on  
the NFS mount.

Is there a way to continue the restore process from where it left off?

Thanks,

____________________________________________________________________
Brendan Duddridge | CTO | 403-277-5591 x24 |  brendan@clickspace.com

ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB  T2G 0V9

http://www.clickspace.com

On Apr 20, 2006, at 3:19 PM, Jeff Frost wrote:

> On Thu, 20 Apr 2006, Brendan Duddridge wrote:
>
>> Hi,
>>
>> We had a database issue today that caused us to have to restore to  
>> our most recent backup. We are using PITR so we have 3120 WAL  
>> files that need to be applied to the database.
>>
>> After 45 minutes, it has restored only 230 WAL files. At this  
>> rate, it's going to take about 10 hours to restore our database.
>>
>> Most of the time, the server is not using very much CPU time or I/ 
>> O time. So I'm wondering what can be done to speed up the process?
>
> Brendan,
>
> Where are the WAL files being stored and how are they being read back?
>
> -- 
> Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
> Frost Consulting, LLC 	http://www.frostconsultingllc.com/
> Phone: 650-780-7908	FAX: 650-649-1954
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that  
> your
>       message can get through to the mailing list cleanly
>





view thread (21+ messages)  latest in thread

Message-ID: <BCAE93E6-B799-4B6F-9F78-AA694342A169@clickspace.com>
Permalink:  ../BCAE93E6-B799-4B6F-9F78-AA694342A169@clickspace.com/
Also on:    postgresql.org/message-id/BCAE93E6-B799-4B6F-9F78-AA694342A169@clickspace.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: brendan@clickspace.com, jeff@frostconsultingllc.com
  Subject: Re: Recovery will take 10 hours
  In-Reply-To: <BCAE93E6-B799-4B6F-9F78-AA694342A169@clickspace.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox