Thread: PGbackrest capacity related question
Hi All,
I am using pgbackrest on my production workloads and it is working as expected.
However our DB is growing more and more .
We have currently two disks and each one is 4 TB size. However 3.8TB size data got loaded into DB currently and our /pgback mount point size is 4TB.
So if the DB size grows more then 4TB, how to add another file system to store backup under "repo-path"?.
Is there any suggestion?
pgbackrest file : /etc/pgbackrest.conf
[online_backups]
db-path=/u02/pgdata01/11/data
backup-user=postgres
db-socket-path=/tmp
[global]
retention-full=3
repo-path=/pgback
start-fast=y
[online_backups]
db-path=/u02/pgdata01/11/data
backup-user=postgres
db-socket-path=/tmp
[global]
retention-full=3
repo-path=/pgback
start-fast=y
process-max=5
log-level-console=info
log-level-file=debug
log-level-console=info
log-level-file=debug
Thanks,
Chiru
On 7/22/19 5:08 PM, chiru r wrote: > Hi All, > > I am using pgbackrest on my production workloads and it is working as > expected. > However our DB is growing more and more . > We have currently two disks and each one is 4 TB size. However 3.8TB > size data got loaded into DB currently and our /pgback mount point size > is 4TB. > So if the DB size grows more then 4TB, how to add another file system to > store backup under "repo-path"?. pgBackRest does not have multi-volume support because there are a number of ways to accomplish this using ZFS, Linux volumes, etc. You'll need the expand the storage for the repo using one of these methods or reduce your retention settings. Regards, -- -David david@pgmasters.net
Thank you David.
On Mon, Jul 22, 2019 at 6:44 PM David Steele <david@pgmasters.net> wrote:
On 7/22/19 5:08 PM, chiru r wrote:
> Hi All,
>
> I am using pgbackrest on my production workloads and it is working as
> expected.
> However our DB is growing more and more .
> We have currently two disks and each one is 4 TB size. However 3.8TB
> size data got loaded into DB currently and our /pgback mount point size
> is 4TB.
> So if the DB size grows more then 4TB, how to add another file system to
> store backup under "repo-path"?.
pgBackRest does not have multi-volume support because there are a number
of ways to accomplish this using ZFS, Linux volumes, etc. You'll need
the expand the storage for the repo using one of these methods or reduce
your retention settings.
Regards,
--
-David
david@pgmasters.net