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 1sUnDJ-005hB1-Pe for pgsql-general@arkaria.postgresql.org; Fri, 19 Jul 2024 12:59:57 +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 1sUnDH-00GBxG-GB for pgsql-general@arkaria.postgresql.org; Fri, 19 Jul 2024 12:59:55 +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 1sUnDH-00GBwJ-16 for pgsql-general@lists.postgresql.org; Fri, 19 Jul 2024 12:59:55 +0000 Received: from mail-yb1-xb31.google.com ([2607:f8b0:4864:20::b31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sUnDD-000Noa-T3 for pgsql-general@postgresql.org; Fri, 19 Jul 2024 12:59:54 +0000 Received: by mail-yb1-xb31.google.com with SMTP id 3f1490d57ef6-e05f25fb96eso1806238276.1 for ; Fri, 19 Jul 2024 05:59:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721393990; x=1721998790; 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=lIwUqT1Nqju9NL1vWDK952PAnc1eGXlrjYWgpS61saA=; b=gAJNrLt7vu9CkO2tI7qNakizZqV5rEv6O16s2BZUi3IwI8qI/JTA/Y3Jz1SDcUrbWD YsK1xdMMWAFUD28M07S5PoKoWB7R5KM39/AvCMpLwC7/vcVzncLD+Ht1uujgQvIwdFE+ HbEfMYbdFYB26XqNT8ryWZLJZOCZuG9+gJKC3ibgH+BEdFruWBjl+iHYiZNAj2QI3eW7 dnfJmcL/3o1YLQDFeVLiEomtZWcxeuQdR5rgdC/fkHNyqaIupiZVzNK1N3y3CkqmXY2G 2LgbW78ljpMTeWVEOwBy/lKPxiIO1HPRP1Ic/fHGO8w9fkuJWzX6yep/z7c3r74o8Wvp P+kA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721393990; x=1721998790; 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=lIwUqT1Nqju9NL1vWDK952PAnc1eGXlrjYWgpS61saA=; b=AJBWs/Klo5sB1ALeYAWkP6cWVAfjRl9sGqh+EA24oq2+RiVjt59KzOYP1C/0ZLdo1/ FBeWQLGN/zWdZkko4CxXX3hUgyzqzoTxEyFFaL3wVyC6vC7gIrO04ZE1Ig9Lmf5BEsiC oCOtdQ8IHZH7wbkeNIMyPXCJ/PM25JX4ZDkPN6d8nO4cvm9EDjMLOhmjQq+a7dwhIwpl CJotPOWuJ4vUl7zEQG0nrrhQhuBZth2DFVy/Raj46hNEv6OJB38BP7r64qr5kx2VTIRq +wT0bFsiUBRFW/OlOaVXXD3tAbj309IqvJFkwNGN3ljnytmNAXLA14lPr7FPzIoLnEtT OEDw== X-Forwarded-Encrypted: i=1; AJvYcCXUJBP1b69SSC31ZY8ysgRR8DIWIYGhPkHB8gQSksi/g96cDqOqFnJb/WlPl6redr2SHG1152g8AYpfPDmSJo1NXWYRkPlhUiJJWlyL X-Gm-Message-State: AOJu0YxCYuiacNNj8kMpuyR1HmdrnlOyziOnFDzlsAaKTibPh90cOQK/ 7LYIuTCrO9c9kRD4q1DdLWiXWcd3pJNFJQOHFOgPrlcu8jfuCWzJucXVIQ/jeAI04VbZxoAd1mA pvekgFcTeGQB1+tOdiQrzb6u72tVB9OWpkc8= X-Google-Smtp-Source: AGHT+IEhYVv7RstSbQxaW2mORUyxIZ07poxbxWphvTpaEviQkOKiHMreoZtF021V9Mi5DVyAUQb5d3yDk1corEcHV28= X-Received: by 2002:a05:6902:230c:b0:e03:9d00:5812 with SMTP id 3f1490d57ef6-e05fea985c8mr6820968276.8.1721393989757; Fri, 19 Jul 2024 05:59:49 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: KK CHN Date: Fri, 19 Jul 2024 18:38:51 +0530 Message-ID: Subject: Re: PgbackRest and EDB Query To: azeem subhani Cc: Kashif Zeeshan , pgsql-general Content-Type: multipart/alternative; boundary="000000000000474d7b061d9945a3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000474d7b061d9945a3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 ? 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=3D0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUHo9R2VQKCw6Sm99= FnOfHBY 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 and globals for each EPAS server in single ( /etc/pgbackrest/pgbackrest.conf ) 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 specifying > 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 wrot= e: >> >>> >>> >>> 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= 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 aut= h >>> 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 us= er >>> 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 wr= ote: >>>> >>>>> 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 i= n 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 commun= ity >>>>> PostgreSQL database ? >>>>> >>>> It support both community PG and EDB PG. >>>> >>>>> >>>>> >>>>> [ when I ran initdb script of EDB while installing EDB it creates th= e >>>>> 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-port= =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_DM= 2 >>>>> 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: aborte= d >>>>> with exception [056] >>>>> [root@uaterssdrservice01 ~]# >>>>> >>>>> >>>>> >>>>> >>>>> > > -- > Thanks > Azeem Subhani > --000000000000474d7b061d9945a3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0 list,=C2=A0

Thank you all for = the great 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 Passwor= d less 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=A0Reposerver=C2=A0 =C2=A0to host more than=C2=A0one EPAS-16 server ins= tance's running on multiple nodes ?=C2=A0=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 <azeemsd07@gmail.com<= /a>> wrote:
<= div dir=3D"ltr">
Hi,

passwordless connection c= an 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 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
--000000000000474d7b061d9945a3--