Re: PgbackRest and EDB Query

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(at)192(dot)168(dot)87(dot)112 <enterprisedb(at)192(dot)168(dot)87(dot)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(dot)in(at)gmail(dot)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(at)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(at)EDB_Server_IP unable to do
> password less auth( Its asking password for enterpridb(at)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(dot)zeeshan(at)gmail(dot)com>
> wrote:
>
>> Hi
>>
>> On Wed, Jul 17, 2024 at 5:21 PM KK CHN <kkchn(dot)in(at)gmail(dot)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(at)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(at)uaterssdrservice01 ~]#
>>>
>>>
>>>
>>>
>>>

--
Thanks
Azeem Subhani