Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sXDnq-002VcG-EO for pgsql-general@arkaria.postgresql.org; Fri, 26 Jul 2024 05:47:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sXDno-005vn6-Bm for pgsql-general@arkaria.postgresql.org; Fri, 26 Jul 2024 05:47:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sXDnn-005vmQ-Tf for pgsql-general@lists.postgresql.org; Fri, 26 Jul 2024 05:47:40 +0000 Received: from mail-vk1-xa2a.google.com ([2607:f8b0:4864:20::a2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sXDnk-001WDF-OX for pgsql-general@postgresql.org; Fri, 26 Jul 2024 05:47:39 +0000 Received: by mail-vk1-xa2a.google.com with SMTP id 71dfb90a1353d-4f52c326501so163459e0c.1 for ; Thu, 25 Jul 2024 22:47:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721972855; x=1722577655; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Q8IiDdtUtW2KNeSwlGwx912MJDH9ok0s2JVr+Nmh/Ao=; b=HlUI+/64MO+hzZ1Y2kv5rWZ2VT45JOYaABlff34AVnVdEGGuXtdDDusrTIluT1XU38 sdC12OfMv/0amipsncY2LzwYJxmDTPoa/XI9xTygWuvqtl7u/TkzKi+e5NSbaDIert7s By2Ympz+3ly1o9qfjJaWqwLM78quCkkG5zo/5RoNYyaR8n7ZKLHuWlrwtTcn5eH43LWR Xg87KY1nEIkFlfAEdJdb5wjfbvZqP8k+H+O91sPbfU8hcbQNcNrOsRyzLfruPUN/q5zV OWQpqkzHsmfD/9sPDtaDICmj4z5zoc5e1fCnsR1DDbiGPdxyzX3K3q3B1jRZlIgAVgwp s3Lg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721972855; x=1722577655; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Q8IiDdtUtW2KNeSwlGwx912MJDH9ok0s2JVr+Nmh/Ao=; b=a8uPmqg9C59ftShcc+WwQl+2IDbx1rR+LA7pe5/RlhtMiegs/m0xBrdJ61VpXIWjQ2 SclY/qy9H9aS7iNu04vW/3UVF0pO89UO4Zmwgni0A9t1ZX1h12Lf7nvHwcuCRm2Jix9r 0wN6ugjV1Q1Q/i1wYO9Tg+218ovKYcbPTucm74Adp6qyYhnZ+Kqzykl/nap4Z4KwgtnA dXdpcYMlKdLkHsqGxdw0JHgTWx9QVgNht0avI+NrVVThRIJ8B5SKeOSMhudf0ih/70dE r5tE4yS2Ew2GJPL7pt/+8uJxjvPNRtQ8FyEBHu0fqWi0m2OSdyyi7LCQU5IeXfyDAR5e P1YA== X-Forwarded-Encrypted: i=1; AJvYcCXJmwCsKZ+aZykuzkbXhhxJnI/FmIyXhtl7v/e54LCtLHj0VQBTiNqj/zUi+/MNXK5UpTMVnw/bKnHHP7Rmip+bMDbmr4FR1B9L1N4O X-Gm-Message-State: AOJu0YxkN5je31MCP6G1VVxROFhJCHH9Am6b14HHgDidqh65snCxuT7y Y0UVfZ8yA6mtIZuxKdhUwsNbhBvTHcwLE+hkmfREWVFcei+Xjq2rbMnavImmrpfPwAVQeK3znOr E5aPg8geERFb//RR3sTvBFvnOkkCrR0gI X-Google-Smtp-Source: AGHT+IHYyCuTAoOrVVBQYt1yBoJ52ylAbBTHoREKm80DBIvp1v9qOwLZlcDn6KQzOI6nYyb57mC5xMRPesgXxUDX/YM= X-Received: by 2002:a05:6102:330d:b0:493:d360:6f58 with SMTP id ada2fe7eead31-493d9b23a4fmr4623674137.20.1721972854666; Thu, 25 Jul 2024 22:47:34 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Kashif Zeeshan Date: Fri, 26 Jul 2024 10:47:27 +0500 Message-ID: Subject: Re: PgbackRest and EDB Query To: KK CHN Cc: azeem subhani , pgsql-general Content-Type: multipart/alternative; boundary="00000000000050bc83061e200c36" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000050bc83061e200c36 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Jul 19, 2024 at 5:59=E2=80=AFPM KK CHN wrote: > Hi list, > > Thank you all for the great help and guidance, I am able to configure > pgbackrest with EPAS-16 and a Repo server both separate machines.. > Password less auth also worked well. Backup and restore all fine. > > Query > How can I make the Reposerver to host more than one EPAS-16 server > instance's running on multiple nodes ? > Yes, You have to add different stanzas for different servers. Regards Kashif Zeeshan > > Having only one /etg/pgbakrest/pgbackrest.conf file on the Repo Server > how to specify stanza name and global for multiple EPAS servers? > My Repo Server: cat /etc/pgbackrest/pgbackrest.conf > #################################################################### > [Demo_Repo] > pg1-host=3D10.20.20.6 > pg1-host-user=3Denterprisedb > pg1-path=3D/var/lib/edb/as16/data > pg-version-force=3D16 > > [global] > #### about the repository > > repo1-path=3D/var/lib/edb_BackupRepo > > repo1-retention-full=3D2 > repo1-cipher-type=3Daes-256-cbc > > repo1-cipher-pass=3D0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUHo9R2VQKCw6Sm= 99FnOfHBY > process-max=3D5 > log-level-console=3Dinfo > log-level-file=3Ddebug > start-fast=3Dy > delta=3Dy > repo1-block=3Dy > repo1-bundle=3Dy > [global:archive-push] > compress-level=3D3 > ###################################################################### > > > 1. So if there are multiple EPAS servers running on different > nodes 10.20.20.7, 10.20.20.8, etc. how to specify the stanzas a= nd > globals for each EPAS server in single ( /etc/pgbackrest/pgbackrest.con= f > ) on Repo server ? > > 2. Say there are X numbers (say 10 EPAS servers from different geo > locations) of EPAS servers each has a daily growth of aprox 1 GB/day > then what should be the connectivity capacity parameters need to > consider to cater the archiving and replication by pgbackrest in a > production environment to the repo server ? > > 3. Also what will be the best backup configuration in a crontab for > achieving maximum RPO ? I mean zero data loss ? ( incr or diff > repetition intervals ?) here my sample crontab, only for full and diff > (in lab setup) but for production env and for near zero data lost what > configs needed in cron ? > > my sample cron here. > [root@RepoServer ~]# crontab -u postgres -l > 30 06 * * 0 pgbackrest --type=3Dfull --stanza=3DDemo2 backup > // only on sundays > > 04 16 * * 1-6 pgbackrest --type=3Ddiff --stanza=3DDemo2 backup > // on everyday diff > [root@uaterssdrservice02 ~]# > > Thanks again > Krishane > > > On Fri, Jul 19, 2024 at 11:24=E2=80=AFAM azeem subhani > wrote: > >> Hi, >> >> passwordless connection can be established using ssh key, and when you >> don't specify the ssh key in command using -i switch:* -i >> /path/to/your/private/key* >> You simply need to set the SSH key as the default key which I have >> explained earlier, how to do that. >> >> As you are currently trying through following command, without specifyin= g >> an ssh key for passwordless connection. >> >> From the EDB Postgres Advanced Server nodes >> $ sudo -u enterprisedb ssh pgbackrest@backup-server >> >> >> >> >> On Fri, Jul 19, 2024 at 10:06=E2=80=AFAM Kashif Zeeshan >> wrote: >> >>> Hi >>> >>> On Thu, Jul 18, 2024 at 6:10=E2=80=AFPM KK CHN wro= te: >>> >>>> >>>> >>>> Hi list, >>>> >>>> Thank you all for your inputs, I am trying pgbacrest with >>>> Enterprised DB. Locally pgbackrest works for EDB but when I am tryin= g for >>>> remote repository I am facing an issue ( from the remote host to EDB >>>> server password less authentication part ) >>>> >>>> Trying to use a remote host as Repo Server I am facing the issue of >>>> passwordless authentication(Public key private key). >>>> >>>> 1. From the EDB server I added the user pgbackrest directory and >>>> generated ssh-keys and copied the id_rsa.pub to the Repo server >>>> (pgbackrest user's .ssh dir with necessary permissions) >>>> everything(passwordless auth) working to one side. >>>> >>>> From the EDB Postgres Advanced Server nodes >>>> $ sudo -u enterprisedb ssh pgbackrest@backup-server >>>> >>>> This works from EDB server machine without any issue(password less >>>> auth works) >>>> >>>> >>>> >>>> 2 But from the reposerver >>>> $sudo -u pgbackrest ssh enterprisedb@EDB_Server_IP unable to >>>> do password less auth( Its asking password for enterpridb@EDB_Server ) >>>> >>>> How to do the passwordless auth from the Repo server to the EDB >>>> server for the default "enterprisedb" user of EDB ? ( enterprisedb u= ser >>>> doesn't have any home dir I mean /home/enterprisedb, so I am not sure >>>> where to create .ssh dir and authorized_keys for passwordless auth ) >>>> >>> Please make sure that the passwordless connection is made between both >>> from EDB Server to Repo Server and from Repo Server to EDB Server. >>> For this you need to generate the ssh keys on both EDB server abd Repo >>> Servers and copy the id_rsa.pub from EDB Server to Repo Server and vise >>> versa. >>> I hope this helps. >>> >>> Regards >>> Kashif Zeeshan >>> >>>> >>>> Any one who has already tackled this kindly guide me on how to achiev= e >>>> this . >>>> >>>> >>>> Thank you, >>>> Krishane >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Wed, Jul 17, 2024 at 9:07=E2=80=AFPM Kashif Zeeshan >>>> wrote: >>>> >>>>> Hi >>>>> >>>>> On Wed, Jul 17, 2024 at 5:21=E2=80=AFPM KK CHN w= rote: >>>>> >>>>>> Hi , >>>>>> >>>>>> I am trying pgbackrest(2.52.1) with postgresql( version 16) on a >>>>>> lab setup on RHEL-9. Both PostgreSQL server and a remote Repository= host >>>>>> configured with pgbackrest and everything working fine as specified = in the >>>>>> documentation. >>>>>> >>>>>> note: here I am running postgres server and pgbackrest everything a= s >>>>>> postgres user and no issues in backup and recovery. >>>>>> >>>>>> >>>>>> >>>>>> Query >>>>>> 1. Is it possible to use PgBackrest with EnterpriseDB(EDB -16) for >>>>>> the backup and recovery process? Or pgback works only with the commu= nity >>>>>> PostgreSQL database ? >>>>>> >>>>> It support both community PG and EDB PG. >>>>> >>>>>> >>>>>> >>>>>> [ when I ran initdb script of EDB while installing EDB it creates >>>>>> the enterpisedb as user and edb as initial database by the script.= ] >>>>>> >>>>> Enterprisedb is the default user created by EDB. >>>>> >>>>>> >>>>>> >>>>>> when I try to create the stanza on the EDB server it throws error >>>>>> (pasted at bottom ). >>>>>> >>>>>> >>>>>> >>>>>> NOTE: >>>>>> I know that my EDB running on port 5444 instead of 5432 and the >>>>>> dbname =3D edb instead of postgres, and user as enterpisedb instead= of >>>>>> postgres how to specify these changes in the stanza creation step if= EDB >>>>>> Supports pgbackrest tool ? >>>>>> >>>>> You can enter this connection information in the PbBackRest Conf file >>>>> for the stanza you create for your EDB Instance. >>>>> >>>>> e.g >>>>> >>>>> [global]repo1-path=3D/var/lib/edb/as15/backups >>>>> [demo]pg1-path=3D/var/lib/edb/as15/datapg1-user=3Denterprisedbpg1-por= t=3D5444pg-version-force=3D15 >>>>> >>>>> Refer to following edb documentation >>>>> >>>>> >>>>> https://www.enterprisedb.com/docs/supported-open-source/pgbackrest/03= -quick_start/ >>>>> >>>>> >>>>>> OR Am I doing a waste exercise [if pgbackrest won't go ahead with >>>>>> EDB ] ? >>>>>> >>>>>> >>>>>> Any hints much appreciated. >>>>>> >>>>>> Thank you, >>>>>> Krishane >>>>>> >>>>>> >>>>>> ERROR: >>>>>> root@uaterssdrservice01 ~]# sudo -u postgres pgbackrest >>>>>> --stanza=3DOD_DM2 --log-level-console=3Dinfo stanza-create >>>>>> 2024-07-17 17:42:13.935 P00 INFO: stanza-create command begin >>>>>> 2.52.1: --exec-id=3D1301876-7e055256 --log-level-console=3Dinfo >>>>>> --log-level-file=3Ddebug --pg1-path=3D/var/lib/pgsql/16/data >>>>>> --repo1-host=3D10.x.y.7 --repo1-host-user=3Dpostgres --stanza=3DOD_D= M2 >>>>>> WARN: unable to check pg1: [DbConnectError] unable to connect to >>>>>> 'dbname=3D'postgres' port=3D5432': connection to server on socket >>>>>> "/tmp/.s.PGSQL.5432" failed: No such file or directory >>>>>> Is the server running locally and accepting connections on >>>>>> that socket? >>>>>> ERROR: [056]: unable to find primary cluster - cannot proceed >>>>>> HINT: are all available clusters in recovery? >>>>>> 2024-07-17 17:42:13.936 P00 INFO: stanza-create command end: >>>>>> aborted with exception [056] >>>>>> [root@uaterssdrservice01 ~]# >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >> >> -- >> Thanks >> Azeem Subhani >> > --00000000000050bc83061e200c36 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Fri, Jul 19, 2024 at 5:59=E2=80=AF= PM KK CHN <kkchn.in@gmail.com&= gt; wrote:
Hi=C2=A0 list,=C2=A0

Thank you all for the g= reat help and guidance, I am able to configure=C2=A0 =C2=A0pgbackrest with = EPAS-16=C2=A0 and a Repo server both separate machines..=C2=A0 Password les= s auth also worked well.=C2=A0 =C2=A0Backup and restore all fine.=C2=A0

Query=C2=A0
How can I make the=C2=A0 =C2=A0= Reposerver=C2=A0 =C2=A0to host more than=C2=A0one EPAS-16 server instance&#= 39;s running on multiple nodes ?=C2=A0=C2=A0
Y= es,
You have to add different stanzas for different servers.

Regards
Kashif Zeeshan=C2=A0

Having only one=C2=A0 /etg/pgbakrest/pgbackrest.conf file on the Repo Ser= ver how to specify stanza=C2=A0 name and=C2=A0 global=C2=A0 for multiple EP= AS servers?
My Repo Server:=C2=A0 cat /etc/pgbackrest/pgbackrest.= conf=C2=A0
######################################################= ##############
[Demo_Repo]
pg1-host=3D10.20.20.6
pg1-host-u= ser=3Denterprisedb
pg1-path=3D/var/lib/edb/as16/data
pg-version-force= =3D16

[global]
#### about the repository

repo1-path=3D/var= /lib/edb_BackupRepo

repo1-retention-full=3D2
repo1-cipher-type=3D= aes-256-cbc
repo1-cipher-pass=3D0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpU= Ho9R2VQKCw6Sm99FnOfHBY
process-max=3D5
log-level-console=3Dinfo
lo= g-level-file=3Ddebug
start-fast=3Dy
delta=3Dy
repo1-block=3Dy
r= epo1-bundle=3Dy
[global:archive-push]
compress-level=3D3
######################################################################


1. So if there are multiple=C2=A0 =C2= =A0EPAS servers=C2=A0 running=C2=A0 =C2=A0on=C2=A0 =C2=A0 different nodes 1= 0.20.20.7,=C2=A0 =C2=A0 =C2=A0 10.20.20.8,=C2=A0 =C2=A0etc.=C2=A0 how to sp= ecify the=C2=A0 =C2=A0stanzas and globals for each=C2=A0 EPAS server in sin= gle=C2=A0(=C2=A0 /etc/pgbackrest/pgbackrest.conf )=C2=A0 =C2=A0 on Repo ser= ver=C2=A0 ?

2.=C2=A0 Say there are=C2=A0 X numbers= (say 10 EPAS servers from different geo locations)=C2=A0 of=C2=A0 EPAS ser= vers=C2=A0 each has a daily growth of=C2=A0 =C2=A0aprox=C2=A01 GB/day=C2=A0= =C2=A0then=C2=A0 =C2=A0what should be the connectivity capacity parameters= need to consider to cater the=C2=A0 archiving and replication by pgbackres= t in a production environment to the repo server=C2=A0 ?

3. Also what will be the best backup=C2=A0 configuration=C2=A0 in a = crontab=C2=A0 for achieving maximum RPO ? I mean zero data loss ?=C2=A0 =C2= =A0 ( incr or diff=C2=A0 =C2=A0 repetition=C2=A0intervals ?)=C2=A0 here my = sample crontab, only for=C2=A0 full and diff (in lab setup)=C2=A0 but for= =C2=A0 production env and for near zero data lost what configs needed in cr= on ?

my sample cron here.=C2=A0
[root@Re= poServer ~]# crontab -u postgres -l
30 =C2=A006 =C2=A0* =C2=A0* =C2=A00 = pgbackrest =C2=A0 --type=3Dfull =C2=A0 =C2=A0--stanza=3DDemo2 =C2=A0 backup= =C2=A0 =C2=A0 =C2=A0 =C2=A0 //=C2=A0 only on sundays

04 =C2=A016 =C2= =A0* =C2=A0* 1-6 pgbackrest =C2=A0 --type=3Ddiff =C2=A0--stanza=3DDemo2 =C2= =A0 =C2=A0backup=C2=A0 =C2=A0 =C2=A0 =C2=A0// on everyday diff
[root@uat= erssdrservice02 ~]#

Thanks again=C2=A0
Krishane


On Fri, Jul 19, 2024 at 11:24=E2=80=AFAM az= eem subhani <az= eemsd07@gmail.com> wrote:
Hi,

passwor= dless connection can be established using ssh key, and when you don't s= pecify the ssh key in command using -i switch: -i /path/to/your/private/= key
You simply need to set the SSH key as the default key which I have explaine= d earlier, how to do that.

As you are c= urrently trying through following command, without specifying an ssh key fo= r passwordless connection.
From =
the EDB Postgres Advanced Server nodes
$ sudo =
-u enterprisedb ssh pgbackrest@backup=
-server



On Fri, Jul 19, 2024 at 10:06=E2=80=AFA= M Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote:
Hi=C2=A0
On = Thu, Jul 18, 2024 at 6:10=E2=80=AFPM KK CHN <kkchn.in@gmail.com> wrote:


Hi list,=C2=A0

<= /div>
Thank you all for your=C2=A0 inputs, I am trying pgbacrest=C2=A0w= ith Enterprised=C2=A0DB.=C2=A0 Locally pgbackrest works for=C2=A0 EDB but w= hen I am trying for remote repository I am facing an issue ( from the remot= e host to=C2=A0 EDB server=C2=A0 password less authentication part )
<= div>
Trying to=C2=A0 use a remote host=C2=A0 as Repo Server I= am facing the issue of=C2=A0 passwordless=C2=A0 authentication(Public key = private key).

1.=C2=A0 From the EDB server=C2=A0 I= =C2=A0 added the user pgbackrest directory and generated ssh-keys and copie= d the id_rsa.pub=C2=A0 =C2=A0to=C2=A0 the Repo server (pgbackrest user'= s .ssh dir with necessary permissions) everything(passwordless auth) workin= g to one side.
From the EDB Postgres Advanced Server nodes
$ sudo =
-u enterprisedb ssh pgbackrest@backup=
-server
This works from=C2=A0 EDB server machine without any issue(password l= ess auth works)



2 Bu= t=C2=A0 =C2=A0from the reposerver=C2=A0 =C2=A0 =C2=A0=C2=A0
$sudo= -u pgbackrest=C2=A0 =C2=A0ssh enterprisedb@EDB_Server_IP=C2=A0 =C2=A0 =C2= =A0 =C2=A0unable to do password less auth( Its asking password for enterpri= db@EDB_Server )

How to do the passwordless auth=C2= =A0 from the=C2=A0 Repo server to the EDB server=C2=A0 for the default &quo= t;enterprisedb" user of=C2=A0 EDB ? ( enterprisedb user doesn't ha= ve any home dir=C2=A0 I mean /home/enterprisedb, so I am not sure where to = create .ssh dir and authorized_keys for=C2=A0 passwordless auth=C2=A0 )=C2= =A0
Please make sure that the passwordless con= nection is made between both from EDB Server to Repo Server and from Repo S= erver to EDB Server.
For this you need to generate the=C2=A0 ssh = keys on both EDB server abd Repo Servers and copy the id_rsa.pub from EDB S= erver to Repo Server and vise versa.
I hope this helps.

Regards
Kashif Zeeshan

Any one w= ho has already tackled this kindly guide=C2=A0 me on how to achieve this .<= /div>


Thank you,=C2=A0
Krishane=





=


On Wed, Jul 17, 2024 at 9:07=E2=80=AFPM Kashif Zeeshan <= kashi.zeeshan@= gmail.com> wrote:
Hi=C2=A0

On Wed, Jul 17, 2024= at 5:21=E2=80=AFPM KK CHN <kkchn.in@gmail.com> wrote:
Hi ,=C2=A0

I am trying pgbackrest(2.52.1)=C2=A0 with postgresql( version 16)=C2=A0 o= n=C2=A0 a lab setup on=C2=A0RHEL-9. Both=C2=A0 PostgreSQL server and a remo= te Repository host configured with pgbackrest and everything=C2=A0working f= ine as specified in the documentation.=C2=A0=C2=A0

note:=C2=A0 here I am running postgres server and pgbackrest everything as= postgres user and no issues in=C2=A0 backup and recovery.=C2=A0
=


Query
1. Is it possi= ble to use=C2=A0 PgBackrest with=C2=A0 EnterpriseDB(EDB -16) for the backup= and recovery process?=C2=A0Or pgback works only with the community=C2=A0 P= ostgreSQL database ?
It support both community= PG and EDB PG.=C2=A0


[ when I ran=C2=A0 in= itdb script of EDB while installing EDB it creates the enterpisedb=C2=A0 as= user and edb as initial=C2=A0 database by the script. ]
Enterprisedb=C2=A0is the default user created by EDB.=C2=A0<= /div>


when I try to create the stanza = on the EDB server it throws error=C2=A0 (pasted at bottom ).

=


NOTE:=C2=A0
I know that= =C2=A0 my EDB=C2=A0 running on=C2=A0 port 5444 instead of=C2=A0 5432 and th= e dbname =3D edb instead of postgres, and user as=C2=A0 enterpisedb instead= of postgres how to specify these changes in the stanza creation step if=C2= =A0 EDB Supports pgbackrest tool ?=C2=A0 =C2=A0
You can enter this connection information in the PbBackRest Conf file for= the stanza you create for your EDB Instance.
=C2=A0
e.= g
[global]
repo1-path=3D/var/lib/edb/as15/backups

[demo]
pg1-path=
=3D/var/lib/edb/as15/data
pg1-user=
=3Denterprisedb
pg1-port=
=3D5444
pg-version-forc=
e=3D15
Refer t= o following edb documentation

=C2=A0
OR=C2=A0 = =C2=A0Am I doing a waste exercise=C2=A0 [if pgbackrest won't go ahead w= ith EDB ] ?


Any hints much apprecia= ted.=C2=A0

Thank you,
Krishane


ERROR:
root@uaterssdrservice01 ~]#= sudo -u postgres pgbackrest --stanza=3DOD_DM2 --log-level-console=3Dinfo = =C2=A0stanza-create
2024-07-17 17:42:13.935 P00 =C2=A0 INFO: stanza-crea= te command begin 2.52.1: --exec-id=3D1301876-7e055256 --log-level-console= =3Dinfo --log-level-file=3Ddebug --pg1-path=3D/var/lib/pgsql/16/data --repo= 1-host=3D10.x.y.7 --repo1-host-user=3Dpostgres --stanza=3DOD_DM2
WARN: u= nable to check pg1: [DbConnectError] unable to connect to 'dbname=3D= 9;postgres' port=3D5432': connection to server on socket "/tmp= /.s.PGSQL.5432" failed: No such file or directory
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 Is the server running locally and accepting connections on that = socket?
ERROR: [056]: unable to find primary cluster - cannot proceed=C2=A0 =C2=A0 =C2=A0 =C2=A0HINT: are all available clusters in recovery?2024-07-17 17:42:13.936 P00 =C2=A0 INFO: stanza-create command end: abort= ed with exception [056]
[root@uaterssdrservice01 ~]#

<= /div>





--
Thanks
Azeem Subhani
--00000000000050bc83061e200c36--