PDA

View Full Version : Backup Questions



fifilein
06-27-2010, 04:22 PM
Hi,

i want to reduce my database and have some questions about it, couldnt find it in the FAQ as this is just the pgAdmin handling.

i have a database of around 1year, and i would like to split backups into quarterly chunks. thats not easy, but doable (backup complete DB, purge everything but the quarter, backup db -> voila; backup file with just one quarter). i plan do that now on a regular basis.

but is it possible to join those backup files back together to one database in case i want to look at all my hands?

restore according to faq needs an empty DB, so thats not the solution. or just restore file after file? (havent tried it yet).

morny
06-27-2010, 08:42 PM
I dont think it would be possible unless you backed up to 4 empty databases, exported and imported them into 1 database, but thats just making everything very complicated, maybe keep the original hand histories on a usb stick in case you need them down the road.

fifilein
06-28-2010, 03:03 AM
and imported them into 1 database

so are you saying, i can restore more than one backup into one database and it just adds the hands?

netsrak
06-28-2010, 03:19 AM
No, thats not possible. The only way is to import the hands.