PgbackRest and EDB Query

From: KK CHN <kkchn(dot)in(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: PgbackRest and EDB Query
Date: 2024-07-17 12:30:01
Message-ID: CAKgGyB9bmzopEmnC9t1k_nrxq7NXpsFazTYdzUuQh_rY49HTfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

[ when I ran initdb script of EDB while installing EDB it creates the
enterpisedb as user and edb as initial database by the script. ]

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 ?

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 ~]#

Responses

Browse pgsql-general by date

  From Date Subject
Next Message azeem subhani 2024-07-17 13:17:44 Re: PgbackRest and EDB Query
Previous Message Akram Hussain 2024-07-17 10:37:17 Support of Postgresql 15 for Sles15Sp6