Thread

1. PgbackRest and EDB Query

   KK CHN <kkchn.in@gmail.com> — 2024-07-17T12:30:01Z

   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 ~]#
   

2. Re: PgbackRest and EDB Query

   azeem subhani <azeemsd07@gmail.com> — 2024-07-17T13:17:44Z

   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_case_1/
   
   On Wed, Jul 17, 2024 at 5:21 PM 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 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 ~]#
   >
   >
   >
   >
   >
   
   -- 
   Thanks
   Azeem Subhani
   

3. Re: PgbackRest and EDB Query

   Kashif Zeeshan <kashi.zeeshan@gmail.com> — 2024-07-17T15:37:43Z

   Hi
   
   On Wed, Jul 17, 2024 at 5:21 PM 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 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 ?
   >
   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
   > = 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=/var/lib/edb/as15/backups
   [demo]pg1-path=/var/lib/edb/as15/datapg1-user=enterprisedbpg1-port=5444pg-version-force=15
   
   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=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 ~]#
   >
   >
   >
   >
   >
   

4. Re: PgbackRest and EDB Query

   KK CHN <kkchn.in@gmail.com> — 2024-07-18T13:19:07Z

   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 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 PM Kashif Zeeshan <kashi.zeeshan@gmail.com>
   wrote:
   
   > Hi
   >
   > On Wed, Jul 17, 2024 at 5:21 PM 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 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 ?
   >>
   > 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 = 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=/var/lib/edb/as15/backups
   > [demo]pg1-path=/var/lib/edb/as15/datapg1-user=enterprisedbpg1-port=5444pg-version-force=15
   >
   > 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=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 ~]#
   >>
   >>
   >>
   >>
   >>
   

5. Re: PgbackRest and EDB Query

   Ruben Morais <ruben.gmorais@gmail.com> — 2024-07-18T14:03:18Z

   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 <kkchn.in@gmail.com> 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 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 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 PM Kashif Zeeshan <kashi.zeeshan@gmail.com>
   > wrote:
   >
   >> Hi
   >>
   >> On Wed, Jul 17, 2024 at 5:21 PM 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 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 ?
   >>>
   >> 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 = 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=/var/lib/edb/as15/backups
   >> [demo]pg1-path=/var/lib/edb/as15/datapg1-user=enterprisedbpg1-port=5444pg-version-force=15
   >>
   >> 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=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 ~]#
   >>>
   >>>
   >>>
   >>>
   >>>
   

6. Re: PgbackRest and EDB Query

   azeem subhani <azeemsd07@gmail.com> — 2024-07-18T17:29:46Z

   Hi,
   
   By following these steps, you should be able to connect to the EDB server
   from the Repo server using passwordless authentication:
   
   1. First, generate an SSH key pair on the client machine(Repo Server
   machine):
   *       ssh-keygen -t rsa -b 2048 -f ~/.ssh/id_rsa_enteprisedb -N ""*
   2. Copy the Public Key to the EDB Server:
   *        ssh-copy-id -i ~/.ssh/id_rsa_enteprisedb.pub
   enterprisedb@192.168.87.112 <enterprisedb@192.168.87.112>*
   3. Configure the SSH client on Repo Server to automatically use the SSH key
   for passwordless login without requiring the -i option:
   
   *       vi ~/.ssh/config # add following contents*
   
   
   
   *Host 192.168.87.112             User enterprisedb             IdentityFile
   ~/.ssh/id_rsa_enteprisedb*
   4. Make sure config file has correct permissions:
        *chmod 600 ~/.ssh/config*
   
   Now, you should be able to connect to EBD server from Repo server without a
   password prompt. It works for me.
   
   
   
   On Thu, Jul 18, 2024 at 6:10 PM KK CHN <kkchn.in@gmail.com> 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 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 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 PM Kashif Zeeshan <kashi.zeeshan@gmail.com>
   > wrote:
   >
   >> Hi
   >>
   >> On Wed, Jul 17, 2024 at 5:21 PM 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 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 ?
   >>>
   >> 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 = 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=/var/lib/edb/as15/backups
   >> [demo]pg1-path=/var/lib/edb/as15/datapg1-user=enterprisedbpg1-port=5444pg-version-force=15
   >>
   >> 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=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 ~]#
   >>>
   >>>
   >>>
   >>>
   >>>
   
   -- 
   Thanks
   Azeem Subhani
   

7. Re: PgbackRest and EDB Query

   Kashif Zeeshan <kashi.zeeshan@gmail.com> — 2024-07-19T05:05:51Z

   Hi
   
   On Thu, Jul 18, 2024 at 6:10 PM KK CHN <kkchn.in@gmail.com> 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 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 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 PM Kashif Zeeshan <kashi.zeeshan@gmail.com>
   > wrote:
   >
   >> Hi
   >>
   >> On Wed, Jul 17, 2024 at 5:21 PM 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 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 ?
   >>>
   >> 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 = 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=/var/lib/edb/as15/backups
   >> [demo]pg1-path=/var/lib/edb/as15/datapg1-user=enterprisedbpg1-port=5444pg-version-force=15
   >>
   >> 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=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 ~]#
   >>>
   >>>
   >>>
   >>>
   >>>
   

8. Re: PgbackRest and EDB Query

   azeem subhani <azeemsd07@gmail.com> — 2024-07-19T05:53:53Z

   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 AM Kashif Zeeshan <kashi.zeeshan@gmail.com>
   wrote:
   
   > Hi
   >
   > On Thu, Jul 18, 2024 at 6:10 PM KK CHN <kkchn.in@gmail.com> 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 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 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 PM Kashif Zeeshan <kashi.zeeshan@gmail.com>
   >> wrote:
   >>
   >>> Hi
   >>>
   >>> On Wed, Jul 17, 2024 at 5:21 PM 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 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 ?
   >>>>
   >>> 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 = 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=/var/lib/edb/as15/backups
   >>> [demo]pg1-path=/var/lib/edb/as15/datapg1-user=enterprisedbpg1-port=5444pg-version-force=15
   >>>
   >>> 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=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 ~]#
   >>>>
   >>>>
   >>>>
   >>>>
   >>>>
   
   -- 
   Thanks
   Azeem Subhani
   

9. Re: PgbackRest and EDB Query

   KK CHN <kkchn.in@gmail.com> — 2024-07-19T13:08:51Z

   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=10.20.20.6
   pg1-host-user=enterprisedb
   pg1-path=/var/lib/edb/as16/data
   pg-version-force=16
   
   [global]
   #### about the repository
   
   repo1-path=/var/lib/edb_BackupRepo
   
   repo1-retention-full=2
   repo1-cipher-type=aes-256-cbc
   repo1-cipher-pass=0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUHo9R2VQKCw6Sm99FnOfHBY
   process-max=5
   log-level-console=info
   log-level-file=debug
   start-fast=y
   delta=y
   repo1-block=y
   repo1-bundle=y
   [global:archive-push]
   compress-level=3
   ######################################################################
   
   
   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=full    --stanza=Demo2   backup
   //  only on sundays
   
   04  16  *  * 1-6 pgbackrest   --type=diff  --stanza=Demo2    backup
    // on everyday diff
   [root@uaterssdrservice02 ~]#
   
   Thanks again
   Krishane
   
   
   On Fri, Jul 19, 2024 at 11:24 AM azeem subhani <azeemsd07@gmail.com> 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 AM Kashif Zeeshan <kashi.zeeshan@gmail.com>
   > wrote:
   >
   >> Hi
   >>
   >> On Thu, Jul 18, 2024 at 6:10 PM KK CHN <kkchn.in@gmail.com> 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 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 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 PM Kashif Zeeshan <kashi.zeeshan@gmail.com>
   >>> wrote:
   >>>
   >>>> Hi
   >>>>
   >>>> On Wed, Jul 17, 2024 at 5:21 PM 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 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 ?
   >>>>>
   >>>> 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 = 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=/var/lib/edb/as15/backups
   >>>> [demo]pg1-path=/var/lib/edb/as15/datapg1-user=enterprisedbpg1-port=5444pg-version-force=15
   >>>>
   >>>> 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=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 ~]#
   >>>>>
   >>>>>
   >>>>>
   >>>>>
   >>>>>
   >
   > --
   > Thanks
   > Azeem Subhani
   >
   

10. Re: PgbackRest and EDB Query

    Kashif Zeeshan <kashi.zeeshan@gmail.com> — 2024-07-26T05:47:27Z

    On Fri, Jul 19, 2024 at 5:59 PM KK CHN <kkchn.in@gmail.com> wrote:
    
    > 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 ?
    >
    Yes,
    You have to add different stanzas for different servers.
    
    Regards
    Kashif Zeeshan
    
    >
    > 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=10.20.20.6
    > pg1-host-user=enterprisedb
    > pg1-path=/var/lib/edb/as16/data
    > pg-version-force=16
    >
    > [global]
    > #### about the repository
    >
    > repo1-path=/var/lib/edb_BackupRepo
    >
    > repo1-retention-full=2
    > repo1-cipher-type=aes-256-cbc
    >
    > repo1-cipher-pass=0oahu5f5dvH7eD4TI1eBEl8Vpn14hWEmgLGuXgpUHo9R2VQKCw6Sm99FnOfHBY
    > process-max=5
    > log-level-console=info
    > log-level-file=debug
    > start-fast=y
    > delta=y
    > repo1-block=y
    > repo1-bundle=y
    > [global:archive-push]
    > compress-level=3
    > ######################################################################
    >
    >
    > 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=full    --stanza=Demo2   backup
    > //  only on sundays
    >
    > 04  16  *  * 1-6 pgbackrest   --type=diff  --stanza=Demo2    backup
    >  // on everyday diff
    > [root@uaterssdrservice02 ~]#
    >
    > Thanks again
    > Krishane
    >
    >
    > On Fri, Jul 19, 2024 at 11:24 AM azeem subhani <azeemsd07@gmail.com>
    > 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 AM Kashif Zeeshan <kashi.zeeshan@gmail.com>
    >> wrote:
    >>
    >>> Hi
    >>>
    >>> On Thu, Jul 18, 2024 at 6:10 PM KK CHN <kkchn.in@gmail.com> 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 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
    >>>> 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 PM Kashif Zeeshan <kashi.zeeshan@gmail.com>
    >>>> wrote:
    >>>>
    >>>>> Hi
    >>>>>
    >>>>> On Wed, Jul 17, 2024 at 5:21 PM 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 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 ?
    >>>>>>
    >>>>> 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 = 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=/var/lib/edb/as15/backups
    >>>>> [demo]pg1-path=/var/lib/edb/as15/datapg1-user=enterprisedbpg1-port=5444pg-version-force=15
    >>>>>
    >>>>> 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=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 ~]#
    >>>>>>
    >>>>>>
    >>>>>>
    >>>>>>
    >>>>>>
    >>
    >> --
    >> Thanks
    >> Azeem Subhani
    >>
    >