public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ruben Morais <[email protected]>
To: KK CHN <[email protected]>
Cc: Kashif Zeeshan <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: PgbackRest and EDB Query
Date: Thu, 18 Jul 2024 15:03:18 +0100
Message-ID: <CAG8sLztMKkduqWF-AAuZsOZEnbFjuYmN0z+_bYpp0+1mHtHtiA@mail.gmail.com> (raw)
In-Reply-To: <CAKgGyB-dNe89d-0e1_9sJG3m=-x=29hE99f7mkZPnBS3y+V5=A@mail.gmail.com>
References: <CAKgGyB9bmzopEmnC9t1k_nrxq7NXpsFazTYdzUuQh_rY49HTfg@mail.gmail.com>
<CAAPsdheQr-i+wc6aW=zqBdWz70phqt05bY-7gfG2g_1cKBjafw@mail.gmail.com>
<CAKgGyB-dNe89d-0e1_9sJG3m=-x=29hE99f7mkZPnBS3y+V5=A@mail.gmail.com>
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 <[email protected]> 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 <[email protected]>
> wrote:
>
>> Hi
>>
>> On Wed, Jul 17, 2024 at 5:21 PM KK CHN <[email protected]> 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 ~]#
>>>
>>>
>>>
>>>
>>>
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: PgbackRest and EDB Query
In-Reply-To: <CAG8sLztMKkduqWF-AAuZsOZEnbFjuYmN0z+_bYpp0+1mHtHtiA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox