Re: PgbackRest and EDB Query

[azeem subhani <azeemsd07@xxxxxxxxx>]

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

Hi 

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  ) 

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@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