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
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. |