Re: Backup Method - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Backup Method
Date
Msg-id CAECtzeUOEWcnUQEbeKXnP3kuxsEi3VCfCeYk-26chfE+CgoN6Q@mail.gmail.com
Whole thread Raw
In response to Re: Backup Method  ("howardnews@selestial.com" <howardnews@selestial.com>)
Responses Re: Backup Method  ("howardnews@selestial.com" <howardnews@selestial.com>)
List pgsql-general

Le 3 juil. 2015 12:31 PM, "howardnews@selestial.com" <howardnews@selestial.com> a écrit :
>
>
>
> On 03/07/2015 11:15, Guillaume Lelarge wrote:
>>
>>
>> pg_dumpall is not more efficient than pg_dump. As far as I can tell, you're looking for PITR backups.
>>
>
> Thanks Guillame.
>
> In that case is there any recommendation for how often to make base backups in relation to the size of the cluster and the size of the WAL?
>

Nope, not really. That depends on a lot of things. Our customers usually do one per day.

--
Guillaume

pgsql-general by date:

Previous
From: Jean-Gérard Pailloncy
Date:
Subject: Fwd: PostgreSQL & VMWare
Next
From: "howardnews@selestial.com"
Date:
Subject: Re: Backup Method