Pgbackrest specifying the default DB necessary/correct way ?

From: KK CHN <kkchn(dot)in(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Pgbackrest specifying the default DB necessary/correct way ?
Date: 2024-08-28 05:39:51
Message-ID: CAKgGyB9jNiGJZHjQRhCico=6zGoxz8zWPrsv2xv5vm2c5tJvow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

List,

I have configured the pgbackrest on a live DB server and a Repo Server. (
EPAS 16, RHEL 9.4 and Pgbackrest 2.52.1 )

On DB Server I have
##############################
[root(at)db1 ~]# cd
[root(at)db1 ~]# cat /etc/pgbackrest/pgbackrest.conf
[Demo_Repo]
pg1-path=/data/edb/as16/data
pg1-port=5444
pg1-user=enterprisedb
pg-version-force=16
pg1-database=edb *## Query 1. *

[global]
repo1-host=10.255.0.40
repo1-host-user=postgres
archive-async=y
spool-path=/var/spool/pgbackrest
log-level-console=info
log-level-file=debug
delta=y

[global:archive-get]
process-max=2

[global:archive-push]
process-max=4
##############################################

*## Query 1: *

In this DB server I have other databases than the default "edb"
database. Specifying the above line as pg1-database=edb // I am
not sure this line is necessary or not ?

( I am just learning and exploring PgbackRest) found online some reference
configurations so using like this )

pg1-database=edb // specifying like this, will it block other databases
on this server to get backed up ? IF yes how can I overcome this ?

I want all databases on this server to be backed up to the remote
repository.

It is a production server and I can't perform a trial and error method here
to understand how it works.

Please shed some light on this .

Thanks ,
Krishane

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2024-08-28 06:58:56 Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
Previous Message Richard Guo 2024-08-28 03:52:46 Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.