Re: Backup Method

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: howardnews(at)selestial(dot)com
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Backup Method
Date: 2015-07-03 10:39:26
Message-ID: CAECtzeUOEWcnUQEbeKXnP3kuxsEi3VCfCeYk-26chfE+CgoN6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le 3 juil. 2015 12:31 PM, "howardnews(at)selestial(dot)com" <
howardnews(at)selestial(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message howardnews@selestial.com 2015-07-03 11:00:18 Re: Backup Method
Previous Message Jean-Gérard Pailloncy 2015-07-03 10:35:07 Fwd: PostgreSQL & VMWare