public inbox for [email protected]
help / color / mirror / Atom feedFrom: Kashif Zeeshan <[email protected]>
To: KK CHN <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: PgbackRest and EDB Query
Date: Fri, 19 Jul 2024 10:05:51 +0500
Message-ID: <CAAPsdhc+_jHWrr0Sr7S4e5pLRA+OZc3LwfP7B0tPQiREjt-wig@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>
Hi
On Thu, Jul 18, 2024 at 6:10 PM 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 )
>
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 <[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]
Subject: Re: PgbackRest and EDB Query
In-Reply-To: <CAAPsdhc+_jHWrr0Sr7S4e5pLRA+OZc3LwfP7B0tPQiREjt-wig@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