Thread: wal files restoration

wal files restoration

From
"Amit Jain"
Date:
Hi
 
I need to take hot backup of production databae which size is around 500GB. since i cannot take full backup dailiy so i am archiving its transaction logs everyday which is around 2.5 gb daily can anyone suggest me that how would i restore from these transaction logs. i have following query regarding it.
 
1. how would i feed this wal files in to my online production database so it can take effect in product db.
2. how much time it will take if its size is around 2.5 gb.
3. am i need to keep entire wal files or only that date wal file which i need to restore.
 
I will highly appreciate your help take it on urgent basis plz.
 
Amit Jain.
iBoss Tech Solution Ltd.
sec-63 Noida.

Re: wal files restoration

From
Frank Wittig
Date:
Hello Amit,

Amit Jain schrieb:
> 1. how would i feed this wal files in to my online production database
> so it can take effect in product db.
I don't understand what effect feeding WAL files into a production
database should have. A production database installation keeps all WAL
files it produced since the last recovery checkpoint in its pg_xlog
directory and restores them automatically after it's started after an
ungraceful shutdown.

WAL file restoration is described in
http://www.postgresql.org/docs/current/static/continuous-archiving.html
There you find both - backup and restoration - procedures documented.

> 3. am i need to keep entire wal files or only that date wal file which i
> need to restore.
You need a base backup of the database and all WAL files written since
that backup was created. In your case this would be your 500GB database
and 2.5GB logs per day.

Greetings,
Frank Wittig


Attachment