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 1sURjN-0035mG-RL for pgsql-general@arkaria.postgresql.org; Thu, 18 Jul 2024 14:03:37 +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 1sURjL-00Gv6Y-V0 for pgsql-general@arkaria.postgresql.org; Thu, 18 Jul 2024 14:03:36 +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 1sURjL-00Gv6F-As for pgsql-general@lists.postgresql.org; Thu, 18 Jul 2024 14:03:36 +0000 Received: from mail-oa1-x2f.google.com ([2001:4860:4864:20::2f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sURjI-000CY4-JC for pgsql-general@postgresql.org; Thu, 18 Jul 2024 14:03:34 +0000 Received: by mail-oa1-x2f.google.com with SMTP id 586e51a60fabf-260e99b6661so343789fac.1 for ; Thu, 18 Jul 2024 07:03:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721311412; x=1721916212; 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=6Q7+i9y31OgMsns/PMEquqUUC++vQX+4I2Bj0oDhrGs=; b=XppfT4M+DwPij4Ki4Lbk1K97ouf2RW1RX3Hzv8ZuE9/Ed2HWWiWxylkMQFJ3Up6wXn SPYDcrT4K0vFnFRay+lQFVBP6WXl5DyJYw9bfQl01XYkypuL3gxSk29U8NOhb78JGHvL X7P9u+NagfwC1g4uoMwklaS4yBZcL6XobV3biJi1JRbj6cluJDMLnsUg3BjyQiASohIz FlcX1c7nN0nznG0KqJFZ/xKlF5B10REdj1c/A4ZPMXwc3OTJCNCNuRO7viZC0X6rRubj AnNtsf1y5Ij/EF2b5NIMMt5SM3HwhFWYNtXJRWgmFGgT7RAmYh+J7qV7iZrjxLakMomp zrfw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721311412; x=1721916212; 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=6Q7+i9y31OgMsns/PMEquqUUC++vQX+4I2Bj0oDhrGs=; b=QMedIIWiWWzpRgIoEGJZ4X2S4zCGEiilB1EHBLZbKalt51I/vwUbMpzARgPi/lu604 +yUrWS7AUtFf7HtXrSO/WjacLBMPDs8qtN+ZjDE67J/RUukCggjp++ZezSzlq2M1nbAC P8mkM1YfMpFTodXX10NCABIVkivlUmGSkxeBr/cl/ETDI9vl9Y4g+1m53l6nd+rp/PzJ e0lt4f8JidiyZ4j+7kCF+1bU81PETTUavx8wc5mvtnEcke6mQdt2sU7NUoLunnoLc79F rNjCKfbvJWbg1aCetejh/HHXF+1mpny7ATg7CKXzfySNOD8id5dZFZX5d16aHbEg5Emg u2MQ== X-Forwarded-Encrypted: i=1; AJvYcCVUJrwNHjmNWmJxEfDc+llQsYmEG3iM/JadTPg0YY2pgTKFXW1pnqBbU3+sYCIICCIs1pm2OFmJvOD4pAnNqWDV/qFJjOGUkmprTdcn X-Gm-Message-State: AOJu0Yz/mkQ13iAMWSzkIU493T0Nfiqeb59amHUv/8eb+0rgFdwr2+FJ 51ebEsu/mMFfuIjnPuT2Nnn0uym9aKkkbDwLWo55B48q8wrFSBWg/9mVjqcS4roNuoYFlj15Hey Xyn8oSKr0wx6FpCYcWvaYdC0iR6tOy8r7 X-Google-Smtp-Source: AGHT+IEGjKivH2omrQ8ScwsrnmB7m4E4e1taY2wccDjYcqj1duhG15RlwpGYojz6w5FawP6UXgOTw9sBeZxqsKewJKs= X-Received: by 2002:a05:6871:4f02:b0:22a:57da:6fec with SMTP id 586e51a60fabf-260ef3046cbmr1114961fac.16.1721311411816; Thu, 18 Jul 2024 07:03:31 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ruben Morais Date: Thu, 18 Jul 2024 15:03:18 +0100 Message-ID: Subject: Re: PgbackRest and EDB Query To: KK CHN Cc: Kashif Zeeshan , pgsql-general Content-Type: multipart/alternative; boundary="0000000000003fd3eb061d860b50" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003fd3eb061d860b50 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable In the documentatio you have how to do it: https://pgbackrest.org/user-guide.html#repo-host/setup-ssh On Thu, Jul 18, 2024, 14:10 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 ) > > 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 ~]# >>> >>> >>> >>> >>> --0000000000003fd3eb061d860b50 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

In the documentatio you have how to do it:

https://pgbackrest.org/user-guide.html#repo-host/setup-ssh

On Thu= , Jul 18, 2024, 14:10 KK CHN <kkch= n.in@gmail.com> wrote:


Hi list= ,=C2=A0

Thank you all for your=C2=A0 inputs, I am = trying pgbacrest=C2=A0with Enterprised=C2=A0DB.=C2=A0 Locally pgbackrest wo= rks for=C2=A0 EDB but when I am trying for remote repository I am facing an= issue ( from the remote host to=C2=A0 EDB server=C2=A0 password less authe= ntication part )

Trying to=C2=A0 use a remote host= =C2=A0 as Repo Server I am facing the issue of=C2=A0 passwordless=C2=A0 aut= hentication(Public key private key).

1.=C2=A0 From= the EDB server=C2=A0 I=C2=A0 added the user pgbackrest directory and gener= ated ssh-keys and copied the id_rsa.pub=C2=A0 =C2=A0to=C2=A0 the Repo serve= r (pgbackrest user's .ssh dir with necessary permissions) everything(pa= sswordless 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

Any one who has already tackled this kindly gu= ide=C2=A0 me on how to achieve this .


Thank you,=C2=A0
Krishane


<= div>




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 K= K CHN <kkchn.in@gmail.com> wrote:
Hi ,=C2=A0

= 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 and a remot= e Repository host configured with pgbackrest and everything=C2=A0working fi= ne 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
<= br>


Query
1. Is it possib= le 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 Po= stgreSQL database ?
It support both community = PG and EDB PG.=C2=A0


[ when I ran=C2=A0 ini= tdb 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


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

<= /div>


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 with EDB ] ?


Any hi= nts much appreciated.=C2=A0

Thank you,
K= rishane


ERROR:
root@uater= ssdrservice01 ~]# sudo -u postgres pgbackrest --stanza=3DOD_DM2 --log-level= -console=3Dinfo =C2=A0stanza-create
2024-07-17 17:42:13.935 P00 =C2=A0 I= NFO: 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 = 9;dbname=3D'postgres' port=3D5432': connection to server on soc= ket "/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 connec= tions on that socket?
ERROR: [056]: unable to find primary cluster - can= not 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 comm= and end: aborted with exception [056]
[root@uaterssdrservice01 ~]#




--0000000000003fd3eb061d860b50--