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).
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).