Re: pgbackrest creating new directories (messing up cron jobs).

From: mimble9(at)danwin1210(dot)me
To: "Stephen Frost" <sfrost(at)snowman(dot)net>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: pgbackrest creating new directories (messing up cron jobs).
Date: 2020-03-11 00:08:05
Message-ID: f15eb088fd457eb9c42c03f5d8628baa.squirrel@danielas3rtn54uwmofdo3x2bsdifr47huasnmbgqzfrec5ubupvtpid.onion
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


I think I need to take a step backwards and ask something else before
moving forward.

>
> Isn't that going to mail you the same WAL over and over again if you set
> it up as a cronjob..? Is that really what you want?
>

I took a full backup when I started. Then I used type=diff. This creates
two archives every x hours (depending on the time period set in cron).

For example:

-rw-r----- 1 postgres postgres 27145 Mar 11 00:00
0000000100000001000000B9-6f3902fe5c3bdebc3c1c124ec6821c7206e350da.gz

-rw-r----- 1 postgres postgres 27126 Mar 11 00:00
0000000100000001000000BA-214e7142c6eda0a350577f6bd624c3db203e184f.gz

Only one of these relates to the database I setup in PostgreSQL. I don't
know what the other one is but it might be related to the "default"
database 'postgres'. (This is just a guess).

Irrespective, I would only want a new archive file if something has
changed in the database. Yet I seem to always receive two new files every
x hours even if nothing has changed.

So I tried type-incr but that seems to produce the same results as type=diff.

I wonder what I am doing wrong?

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Frost 2020-03-11 00:37:27 Re: pgbackrest creating new directories (messing up cron jobs).
Previous Message Stephen Frost 2020-03-10 22:37:53 Re: pgbackrest creating new directories (messing up cron jobs).