MIME-Version: 1.0
References: <CAKgGyB9bmzopEmnC9t1k_nrxq7NXpsFazTYdzUuQh_rY49HTfg@mail.gmail.com>
In-Reply-To: <CAKgGyB9bmzopEmnC9t1k_nrxq7NXpsFazTYdzUuQh_rY49HTfg@mail.gmail.com>
From: azeem subhani <azeemsd07@gmail.com>
Date: Wed, 17 Jul 2024 18:17:44 +0500
Message-ID: <CALp3DH1MhfhWxNjAhtbB=CwzBoCJPP2TEBhkui0-2XkPQ6ubwA@mail.gmail.com>
Subject: Re: PgbackRest and EDB Query
To: KK CHN <kkchn.in@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006e6e33061d714abd"
Archived-At: <https://www.postgresql.org/message-id/CALp3DH1MhfhWxNjAhtbB%3DCwzBoCJPP2TEBhkui0-2XkPQ6ubwA%40mail.gmail.com>
Precedence: bulk

--0000000000006e6e33061d714abd
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

Your query:
1. Is it possible to use  PgBackrest with  EnterpriseDB(EDB -16) for the
backup and recovery process? Or pgback works only with the community
PostgreSQL database ?

Answer: Yes, you can use pgBackRest with EPAS-16 (EDB Postgres Advanced
Server); it is fully supported. You can find two use cases provided on the
EDB official documentation website, detailing both scenarios: pgBackRest
running locally or on a dedicated remote server. The following links are
given for more information:


https://www.enterprisedb.com/docs/supported-open-source/pgbackrest/
https://www.enterprisedb.com/docs/supported-open-source/pgbackrest/06-use_c=
ase_1/

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

> 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 th=
e
> documentation.
>
> note:  here I am running postgres server and pgbackrest everything as
> 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 community
> PostgreSQL database ?
>
>
> [ when I ran  initdb script of EDB while installing EDB it creates the
> enterpisedb  as user and edb as initial  database by the script. ]
>
>
> when I try to create the stanza on the EDB server it throws error  (paste=
d
> at bottom ).
>
>
>
> NOTE:
> I know that  my EDB  running on  port 5444 instead of  5432 and the dbnam=
e
> =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 ?
>
> 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_DM2
> 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 ~]#
>
>
>
>
>

--=20
Thanks
Azeem Subhani

--0000000000006e6e33061d714abd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div><br></div><div>Your query:</div><div>
1. Is it possible 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=20
PostgreSQL database ? <br></div><div><br></div><div>Answer: Yes, you can us=
e pgBackRest with EPAS-16 (EDB Postgres Advanced Server); it is fully suppo=
rted. You can find two use cases provided on the EDB official documentation=
 website, detailing both scenarios: pgBackRest running locally or on a dedi=
cated remote server. The following links are given for more information:</d=
iv><div><br></div><div><br></div><div><a href=3D"https://www.enterprisedb.c=
om/docs/supported-open-source/pgbackrest/">https://www.enterprisedb.com/doc=
s/supported-open-source/pgbackrest/</a></div><div>
<div><a href=3D"https://www.enterprisedb.com/docs/supported-open-source/pgb=
ackrest/06-use_case_1/">https://www.enterprisedb.com/docs/supported-open-so=
urce/pgbackrest/06-use_case_1/</a></div>

</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_=
attr">On Wed, Jul 17, 2024 at 5:21=E2=80=AFPM KK CHN &lt;<a href=3D"mailto:=
kkchn.in@gmail.com">kkchn.in@gmail.com</a>&gt; wrote:<br></div><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi ,=C2=A0<div><br><=
/div><div>I am trying pgbackrest(2.52.1)=C2=A0 with postgresql( version 16)=
=C2=A0 on=C2=A0 a lab setup on=C2=A0RHEL-9. Both=C2=A0 PostgreSQL server an=
d a remote Repository host configured with pgbackrest and everything=C2=A0w=
orking fine as specified in the documentation.=C2=A0=C2=A0</div><div><br></=
div><div>note:=C2=A0 here I am running postgres server and pgbackrest every=
thing as postgres user and no issues in=C2=A0 backup and recovery.=C2=A0</d=
iv><div><br></div><div><br></div><div><br></div><div>Query</div><div>1. Is =
it possible to use=C2=A0 PgBackrest with=C2=A0 EnterpriseDB(EDB -16) for th=
e backup and recovery process?=C2=A0Or pgback works only with the community=
=C2=A0 PostgreSQL database ?</div><div><br></div><div><br></div><div>[ when=
 I ran=C2=A0 initdb script of EDB while installing EDB it creates the enter=
pisedb=C2=A0 as user and edb as initial=C2=A0 database by the script. ]<br>=
</div><div><br></div><div><br></div><div>when I try to create the stanza on=
 the EDB server it throws error=C2=A0 (pasted at bottom ).</div><div><br></=
div><div><br></div><div><br></div><div>NOTE:=C2=A0</div><div>I know that=C2=
=A0 my EDB=C2=A0 running on=C2=A0 port 5444 instead of=C2=A0 5432 and the d=
bname =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</div><div><br></div><div>OR=C2=
=A0 =C2=A0Am I doing a waste exercise=C2=A0 [if pgbackrest won&#39;t go ahe=
ad with EDB ] ?</div><div><br></div><div><br></div><div>Any hints much appr=
eciated.=C2=A0</div><div><br></div><div>Thank you,</div><div>Krishane</div>=
<div><br></div><div><br></div><div>ERROR:</div><div>root@uaterssdrservice01=
 ~]# sudo -u postgres pgbackrest --stanza=3DOD_DM2 --log-level-console=3Din=
fo =C2=A0stanza-create<br>2024-07-17 17:42:13.935 P00 =C2=A0 INFO: stanza-c=
reate command begin 2.52.1: --exec-id=3D1301876-7e055256 --log-level-consol=
e=3Dinfo --log-level-file=3Ddebug --pg1-path=3D/var/lib/pgsql/16/data --rep=
o1-host=3D10.x.y.7 --repo1-host-user=3Dpostgres --stanza=3DOD_DM2<br>WARN: =
unable to check pg1: [DbConnectError] unable to connect to &#39;dbname=3D&#=
39;postgres&#39; port=3D5432&#39;: connection to server on socket &quot;/tm=
p/.s.PGSQL.5432&quot; failed: No such file or directory<br>=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 Is the server running locally and accepting connections on th=
at socket?<br>ERROR: [056]: unable to find primary cluster - cannot proceed=
<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0HINT: are all available clusters in recovery=
?<br>2024-07-17 17:42:13.936 P00 =C2=A0 INFO: stanza-create command end: ab=
orted with exception [056]<br>[root@uaterssdrservice01 ~]#<br></div><div><b=
r></div><div><br></div><div><br></div><div><br></div></div>
</blockquote></div><br clear=3D"all"><br><span class=3D"gmail_signature_pre=
fix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"l=
tr">Thanks<div>Azeem Subhani</div></div></div>

--0000000000006e6e33061d714abd--