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

Why I lost the last pg_xlog file?

From: Waldomiro <waldomiro(at)shx(dot)com(dot)br>
To: pgsql-performance(at)postgresql(dot)org
Subject: Why I lost the last pg_xlog file?
Date: 2011-01-27 12:10:01
Message-ID: 4D416099.8060107@shx.com.br (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

Yesterday I perform a crash test, but I lost the last pg_xlog file.
Let me explain:

First I did the pg_start_backup
Second I copied the phisical files to the slave server
Third I did the pg_stop_backup

So I run a test,

1) In the master server I created a 100.000 records table
2) I Runned the "checkpoint" command to be sure the table will be saved.
3) I check the pg_xlog, there was created 6 logs, but in the archive 
there was only 5.
4) I copied the achives files to the slave server and I created a 
recovery.conf and started the slave postgres.
5) Postgres recovered the 5 log files correctly,  but the new table did 
not came to the slave. I think because the last pg_xlog file was not 
archived.

I did not understand why the last file wasnt archieved?
There is a command to be sure all pg_xlog is archived? or I need to copy 
the last file to the slave before recovery?

How is the correctly way to perform a recovery in this case?

Thanks,

Waldomiro Caraiani


Responses

pgsql-performance by date

Next:From: Justin PittsDate: 2011-01-27 12:30:54
Subject: Re: High load,
Previous:From: C├ędric VillemainDate: 2011-01-27 11:58:02
Subject: Re: High load,

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