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 1sUfos-004oLW-3B for pgsql-general@arkaria.postgresql.org; Fri, 19 Jul 2024 05:06:14 +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 1sUfoq-009M9R-9A for pgsql-general@arkaria.postgresql.org; Fri, 19 Jul 2024 05:06:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUfop-009M7V-LQ for pgsql-general@lists.postgresql.org; Fri, 19 Jul 2024 05:06:12 +0000 Received: from mail-ua1-x92d.google.com ([2607:f8b0:4864:20::92d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sUfoe-000JZy-Vy for pgsql-general@postgresql.org; Fri, 19 Jul 2024 05:06:10 +0000 Received: by mail-ua1-x92d.google.com with SMTP id a1e0cc1a2514c-810177d1760so471995241.2 for ; Thu, 18 Jul 2024 22:06:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721365560; x=1721970360; 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=Hp1uv6Rkz5sKBZ6qHiBMEDcaZ2u5HXdJbTfaP1SAtg8=; b=cqRyK/vM4E4NigKSaAl1ZvXRsZMVK6wGCF0+N9+acmUAPcFjyN4WzAsUVVO5FV0GRE OCXYQ/H80D/uJj1bIl9a+zcXg4VpfiwOnSNSr5YuXQg8XSgxDPd+G90pAKd/rOxhXm8T vajzRV6WhpkqlSrooM1z6a4vr2WisoY6CqvMiG3KXUCsa+x68CNNPMXVDE2MpTTf6c/U kizgIZzuNJ522+7oB75N8E5BLb1OD8NvP8z/xWbon75UwtWwFyYIIqaZsry99O+5WAk5 OkGzSf3YHDIurg1KliqTaimfwixj+40TebnNygjURzrTkQG3NMd7y7gkb1cMzimh+NwZ AS8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721365560; x=1721970360; 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=Hp1uv6Rkz5sKBZ6qHiBMEDcaZ2u5HXdJbTfaP1SAtg8=; b=o6rmQpQWxp59Dklyx9qWXEBbUgBtZR6zLf/PPVvtOdTTH1Lq+u8MzyKBZzBBoadiyz CSwQNqxDvXNf3D0gvMg4HSO+WLyX86MLRJrWS6nsJYA0bouHASqw9mFZUgi/i1K2G/KO u/AqqOhC7ZC0MrOD+0XWSKUWoOnP40mByeGWMIyhQ/OyZKpAyXDpmivWILmCs4qCfIST VouCmRmd+ZSrBakzmCzlg9A5mdZYz6bChs4Oe9bDicJQrw7Vh0VCjCliEEy5U6KabVTE DxcyEaDVn+H5iaKUGmhj9eiMKWJUp1mATHnrWepw8eTBW78wA+z4KT0spqIhiYl63dRS a0Rw== X-Gm-Message-State: AOJu0Yy9R8i06Ysx2O6MhIsz9ZevvjsYybWiDuJu7xv6/LcKmglhICLX O/eeExCZPtyfmSL9y2+RbnuKwO9DjKLTXOzl/ktc2zH77mzWlnsiTQ7vy31H9vEGr4NN9FsVuMx b1z9Vc0dUIQU+t+Cwm+Odkt7fWuk= X-Google-Smtp-Source: AGHT+IG/Ypx0xBxIheVXLxCnUzrd465BUPQxUj4rJIXdjzwdRNd/mdsT5c5lFjcf8YPFEPPCo7kglfYpJgAiXvyTlSw= X-Received: by 2002:a05:6102:330a:b0:48f:df1d:696f with SMTP id ada2fe7eead31-4915998d575mr7693832137.30.1721365559746; Thu, 18 Jul 2024 22:05:59 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Kashif Zeeshan Date: Fri, 19 Jul 2024 10:05:51 +0500 Message-ID: Subject: Re: PgbackRest and EDB Query To: KK CHN Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000b7ab2c061d92a60b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b7ab2c061d92a60b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi On Thu, Jul 18, 2024 at 6:10=E2=80=AFPM KK CHN wrote: > > > Hi list, > > Thank you all for your inputs, I am trying pgbacrest with > Enterprised DB. Locally pgbackrest works for EDB but when I am trying f= or > 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 user 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 achieve > 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 wrot= e: >> >>> 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 th= e >>> backup and recovery process? Or pgback works only with the community >>> 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 E= DB >>> Supports pgbackrest tool ? >>> >> You can enter this connection information in the PbBackRest Conf file fo= r >> 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-port= =3D5444pg-version-force=3D15 >> >> Refer to following edb documentation >> >> >> https://www.enterprisedb.com/docs/supported-open-source/pgbackrest/03-qu= ick_start/ >> >> >>> OR Am I doing a waste exercise [if pgbackrest won't go ahead with ED= B >>> ] ? >>> >>> >>> Any hints much appreciated. >>> >>> Thank you, >>> Krishane >>> >>> >>> ERROR: >>> root@uaterssdrservice01 ~]# sudo -u postgres pgbackrest --stanza=3DOD_D= M2 >>> --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-fil= e=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 ~]# >>> >>> >>> >>> >>> --000000000000b7ab2c061d92a60b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0

On Thu, Jul 18, 2024 at 6:10=E2= =80=AFPM KK CHN <kkchn.in@gmail.co= m> wrote:


H= i list,=C2=A0

Thank you all for your=C2=A0 inputs,= I am trying pgbacrest=C2=A0with Enterprised=C2=A0DB.=C2=A0 Locally pgbackr= est works for=C2=A0 EDB but when I am trying for remote repository I am fac= ing an issue ( from the remote host to=C2=A0 EDB server=C2=A0 password less= authentication part )

Trying to=C2=A0 use a remot= e 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 a= nd generated ssh-keys and copied the id_rsa.pub=C2=A0 =C2=A0to=C2=A0 the Re= po server (pgbackrest user's .ssh dir with necessary permissions) every= thing(passwordless auth) working 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>



--000000000000b7ab2c061d92a60b--