Search Postgresql Archives

Re: wal archiving question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



thank you so much for all the inputs.. One final question is , Do we have to stop the database when we create the base backup?

Regards



On Wed, Dec 5, 2012 at 4:45 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
akp geek <akpgeek@xxxxxxxxx> writes:
> thank you all. There is a mistake I did then. I created a base backup when
> I started the DB , that was exactly an year ago. I need to do that again
> and then delete the old files.

Yeah, you should be making new base backups a lot more frequently than
that, probably.  Consider: if your DB died today and you had to restore
from the base backup, you'd have to replay a year's worth of WAL to get
back where you were.  That'd take ages.  So the bloat in the archive
directory is just one reason not to do it like that.

                        regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux