public inbox for [email protected]
help / color / mirror / Atom feedFrom: KK CHN <[email protected]>
To: Kashif Zeeshan <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: PgbackRest and EDB Query
Date: Thu, 18 Jul 2024 18:49:07 +0530
Message-ID: <CAKgGyB-dNe89d-0e1_9sJG3m=-x=29hE99f7mkZPnBS3y+V5=A@mail.gmail.com> (raw)
In-Reply-To: <CAAPsdheQr-i+wc6aW=zqBdWz70phqt05bY-7gfG2g_1cKBjafw@mail.gmail.com>
References: <CAKgGyB9bmzopEmnC9t1k_nrxq7NXpsFazTYdzUuQh_rY49HTfg@mail.gmail.com>
<CAAPsdheQr-i+wc6aW=zqBdWz70phqt05bY-7gfG2g_1cKBjafw@mail.gmail.com>
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]
Subject: Re: PgbackRest and EDB Query
In-Reply-To: <CAKgGyB-dNe89d-0e1_9sJG3m=-x=29hE99f7mkZPnBS3y+V5=A@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