MIME-Version: 1.0
From: KK CHN <kkchn.in@gmail.com>
Date: Wed, 17 Jul 2024 18:00:01 +0530
Message-ID: <CAKgGyB9bmzopEmnC9t1k_nrxq7NXpsFazTYdzUuQh_rY49HTfg@mail.gmail.com>
Subject: PgbackRest and EDB Query
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a3ad9c061d707e2c"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB9bmzopEmnC9t1k_nrxq7NXpsFazTYdzUuQh_rY49HTfg%40mail.gmail.com>
Precedence: bulk

--000000000000a3ad9c061d707e2c
Content-Type: text/plain; charset="UTF-8"

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 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  (pasted
at bottom ).


NOTE:
I know that  my EDB  running on  port 5444 instead of  5432 and the dbname
= 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=OD_DM2
--log-level-console=info  stanza-create
2024-07-17 17:42:13.935 P00   INFO: stanza-create command begin 2.52.1:
--exec-id=1301876-7e055256 --log-level-console=info --log-level-file=debug
--pg1-path=/var/lib/pgsql/16/data --repo1-host=10.x.y.7
--repo1-host-user=postgres --stanza=OD_DM2
WARN: unable to check pg1: [DbConnectError] unable to connect to
'dbname='postgres' port=5432': 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 ~]#

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

<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=A0RH=
EL-9. Both=C2=A0 PostgreSQL server and a remote Repository host configured =
with pgbackrest and everything=C2=A0working fine as specified in the docume=
ntation.=C2=A0=C2=A0</div><div><br></div><div>note:=C2=A0 here I am running=
 postgres server and pgbackrest everything as postgres user and no issues i=
n=C2=A0 backup and recovery.=C2=A0</div><div><br></div><div><br></div><div>=
<br></div><div>Query</div><div>1. Is it possible to use=C2=A0 PgBackrest wi=
th=C2=A0 EnterpriseDB(EDB -16) for the 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 whil=
e installing EDB it creates the enterpisedb=C2=A0 as user and edb as initia=
l=C2=A0 database by the script. ]<br></div><div><br></div><div><br></div><d=
iv>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 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</div><div><br></div><div>OR=C2=A0 =C2=A0Am I doing a waste exercise=
=C2=A0 [if pgbackrest won&#39;t go ahead with EDB ] ?</div><div><br></div><=
div><br></div><div>Any hints much appreciated.=C2=A0</div><div><br></div><d=
iv>Thank you,</div><div>Krishane</div><div><br></div><div><br></div><div>ER=
ROR:</div><div>root@uaterssdrservice01 ~]# sudo -u postgres pgbackrest --st=
anza=3DOD_DM2 --log-level-console=3Dinfo =C2=A0stanza-create<br>2024-07-17 =
17:42:13.935 P00 =C2=A0 INFO: stanza-create command begin 2.52.1: --exec-id=
=3D1301876-7e055256 --log-level-console=3Dinfo --log-level-file=3Ddebug --p=
g1-path=3D/var/lib/pgsql/16/data --repo1-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;: c=
onnection to server on socket &quot;/tmp/.s.PGSQL.5432&quot; failed: No suc=
h file or directory<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 Is the server running lo=
cally and accepting connections on that socket?<br>ERROR: [056]: unable to =
find primary cluster - cannot proceed<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0HINT: a=
re all available clusters in recovery?<br>2024-07-17 17:42:13.936 P00 =C2=
=A0 INFO: stanza-create command end: aborted with exception [056]<br>[root@=
uaterssdrservice01 ~]#<br></div><div><br></div><div><br></div><div><br></di=
v><div><br></div></div>

--000000000000a3ad9c061d707e2c--