Re: PgbackRest and EDB Query

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(at)backup-server

On Fri, Jul 19, 2024 at 10:06 AM Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
wrote:

> Hi
>
> 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 )
>>
> 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(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