Re: PgbackRest and EDB Query

[azeem subhani <azeemsd07@xxxxxxxxx>]

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

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@xxxxxxxxx> 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@xxxxxxxxx> wrote:

Hi 

On Wed, Jul 17, 2024 at 5:21 PM KK CHN <kkchn.in@xxxxxxxxx> 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/data
pg1-user=enterprisedb
pg1-port=5444
pg-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