Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wHGcH-0070pg-1o for pgsql-novice@arkaria.postgresql.org; Mon, 27 Apr 2026 07:42:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wHGcG-00Cl3k-2U for pgsql-novice@arkaria.postgresql.org; Mon, 27 Apr 2026 07:42:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wHGcG-00Cl3b-1Q for pgsql-novice@lists.postgresql.org; Mon, 27 Apr 2026 07:42:52 +0000 Received: from mx1.alte-leipziger.de ([91.217.145.231]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wHGcB-00000003Idm-22dj for pgsql-novice@lists.postgresql.org; Mon, 27 Apr 2026 07:42:52 +0000 X-CSE-ConnectionGUID: xl7Ss3T8RZWVtSsmzWM+4w== X-CSE-MsgGUID: fP76DiM1QLSxIb4dQKEVKg== From: "Subramanian,Ramachandran" To: "Subramanian,Ramachandran" , "pgsql-novice@lists.postgresql.org" Subject: AW: pg_basebackup HBA.CONF error Thread-Topic: pg_basebackup HBA.CONF error Thread-Index: AdzWF6Tq/K+ryl7KRdKiTiu8Y1YQyQAAZREQ Date: Mon, 27 Apr 2026 07:42:44 +0000 Message-ID: <9800cdef81d343d794d7b44adb13f251@alte-leipziger.de> References: <024beccb2af44ff0ad019f378ea04e4e@alte-leipziger.de> In-Reply-To: <024beccb2af44ff0ad019f378ea04e4e@alte-leipziger.de> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: IkPUd/ZMGdMJhdextp3MeX1NU/u1U0Wvtwej0H2jLXEQav9JUCP6SxW8 rBVGItvZEoS7arKaDHfXujxXdzYx/DJWB4q4HzNyi+ZjWETZUNQ/s9Etj1keyAZGMaJBYHEexWA 6JSY5aGTmjK/5SagFuFY9XYa1m8xA6tksItBQxdxFW2G63ADnUaZKqVmjiAH5MzsnkoDekbVixG 1BKJfHB9S83QyquCDpXNPUnntGF//VTpze4vlqBpmuUM+sOckX5cij0kZQAYrJ76UInHcPwKymB jMR0zVb9OC+HOasPO8W2nY041QkNr7xK/0qQTEeaXJZV/QhOzWmg4IStvD9YWA6XjnEWaQD003k Ye0CaBh/ITKlSol6zqFtbMwFGg09GMAGA2DXRtOHAUenrZIdvV56QNqwISlTmBvRcIYhn/nXaz6 h9iDMXysqaVuBT3ZY4qRGt1A7GUS4qAaN6svaSJdigZi17dHqI+P2f8Mp9Ag+mYPObNZOB/4Gcp rRafMF62ua3KRg2KHGmHhLl1U428HJWVhUm3mRnuO63IYX8NyB7K/i5N6f4L/YSCgLSuB+CA5vV nJuf13eKwXabSI7J+NMUqzOOTOBd+8vi/+JUb9kNFLMmpI6+cngwPHnmieituEgipZycWpV3fhx vv8p2E4QOu6cBJoy7mw982IOhcXnoew4YFoGqgt7TDa1L5t5r54JIx46I6S0G5r+60cOefnpVyL 0JZBYX1NCkLuRNrWY95PCPjE8F3wo3yryOQ5hthRFAcCnfMqomsnrbRJ7JjY/O18mD38qtDoqUo 8h+pgZ6QFeJPmnRaYS/85IRkBH x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--32.100200-8.000000 x-tm-snts-smtp: D3B925E2CB8D792E94A48274B4451F930409E73F6C9736ADCCFE47125CC242372000:8 x-alsentwithgood: false Content-Type: multipart/alternative; boundary="_000_9800cdef81d343d794d7b44adb13f251alteleipzigerde_" MIME-Version: 1.0 X-GBS-PROC: 4CJLfqUnsgHWfeqPKbZTdUy3cj9LndDgEahRCCEST2ocwgdontOJ4WkyCwmYjtHv X-GBS-PROCJOB: =?utf-8?Q?FqkzQu5MKrOWFXjqMQtg4U99uw+3vA2KlMAZUx1g7rC0Fj47bDdBCvtW9WRZ?= =?utf-8?Q?tam5112TgAUUjiBSiVtiF9Twi3RRXsJt3XkJ4pZN+9Ikp0oK/IFJZfMj7zn7?= =?utf-8?Q?dEVm4jguqwfEW+lksiMDSygCGMDsa8YCZVKchcmFb6WVz5yvP3E=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_9800cdef81d343d794d7b44adb13f251alteleipzigerde_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable FALSE ALARM I corrected the problem by adding this line to my HBA.conf #Privilege to run Backups local replication all ldap= ldapserver=3Dldap-LDAP=85blah blah blah blah Sorry for the trouble. Regards Ram Freundliche Gr=FC=DFe i. A. Ramachandran Subramanian Zentralbereich Informationstechnologie Alte Leipziger Lebensversicherung a.G. Hallesche Krankenversicherung a.G. ______________________ ALH Gruppe Alte Leipziger-Platz 1, 61440 Oberursel Tel.: +49 (6171) 66-4882 Fax: +49 (6171) 66-800-4882 E-Mail: ramachandran.subramanian@alte-leipziger.de www.alte-leipziger.de www.hallesche.de Von: Subramanian,Ramachandran Gesendet: Montag, 27. April 2026 09:34 An: pgsql-novice@lists.postgresql.org Betreff: pg_basebackup HBA.CONF error Hello, I have a userid for Backups . I have setup LDAP as authentication metho= d. I am able to connect to postgres with this user, but when I try to run a = base backup I get an error. I would be grateful for any guidance . LG Ram [postgres@lx cronscripts]$ psql -p 5432 -U D-Postgres-Backup -d avw1q -c = =22select current_user=22 current_user ------------------- D-Postgres-Backup (1 row) postgres=3D# =5Cdu =22D-Postgres-Backup=22 List of roles Role name | Attributes -------------------+------------- D-Postgres-Backup | Replication postgres=3D# [postgres@lx cronscripts]$ pg_basebackup -p 5432 -U D-Postgres-Backup -D = testing pg_basebackup: error: connection to server on socket =22/var/run/postgres= ql/.s.PGSQL.5432=22 failed: FATAL: no pg_hba.conf entry for replication = connection from host =22[local]=22, user =22D-Postgres-Backup=22, no encr= yption Freundliche Gr=FC=DFe i. A. Ramachandran Subramanian Zentralbereich Informationstechnologie Alte Leipziger Lebensversicherung a. G. Hallesche Krankenversicherung a. G. ______________________ ALH Gruppe Alte Leipziger-Platz 1, 61440 Oberursel Tel: +49 (6171) 66-4882 Fax: +49 (6171) 66-800-4882 E-Mail: ramachandran.subramanian@alte-leipziger.de www.alte-leipziger.de www.hallesche.de Alte Leipziger Lebensversicherung a. G., Alte Leipziger-Platz 1, 61440 Ob= erursel Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcs= ek Sitz Oberursel (Taunus) =B7 Rechtsform VVaG =B7 Amtsgericht Bad Homburg v= . d. H. HRB 1583 =B7 USt.-IdNr. DE 114106814 Hallesche Krankenversicherung a. G., L=F6ffelstra=DFe 34-38, 70597 Stuttg= art Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcs= ek Sitz Stuttgart =B7 Rechtsform VVaG =B7 Amtsgericht Stuttgart HRB 2686 = =B7 USt.-IdNr. DE 147802285 Beitr=E4ge zu privaten Kranken- und Pflegekrankenversicherungen unterlieg= en nicht der Versicherungsteuer (=A7 4 (1) Nr. 5 b VersStG) =B7 Versicher= ungsleistungen sowie Ums=E4tze aus Versicherungsvertreter-/Maklert=E4tigk= eiten sind umsatzsteuerfrei Pflichtangaben der ALH Gruppe ge= m=E4=DF =A7 35a GmbHG bzw. =A7 80 AktG --_000_9800cdef81d343d794d7b44adb13f251alteleipzigerde_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

FALSE ALARM

 

I corrected the problem by adding this line to my HBA.conf=

 

 

 

#Privilege to run Backups

local   replication     all =             &= nbsp;           &n= bsp;           &nb= sp;    ldap ldapserver=3Dldap-LDAP=85blah blah blah blah

 

 

 

 

Sorry for the trouble.

 

 

Regards

 

Ram


Freundliche Gr=FC=DFe


i. A. Ramachandran Subrama= nian =20

Zentralbereich Informationst= echnologie

=20

Alte Leipziger Lebensversicherung a. G.<= /SPAN>

Hallesche Krankenversicherung a. G.

=20

______________________

ALH Gruppe
Alte Leipziger-Platz 1, 614= 40 Oberursel
Tel: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de
www.hallesche.de

Von: = Subramanian,Ramachandran <ramachandran.subramanian@alte-leipziger.de>
Gesendet: Montag, 27. April 2026 09:34
An: pgsql-novice@lists.postgresql.org
Betreff: pg_basebackup HBA.CONF error

 

Hello,

 

  I have a userid for Backups . I have se= tup LDAP as authentication method.

 

 

I am able to connect to postgres with this use= r, but when I try to run a base backup I get an error.

 

 

I would be grateful for any guidance .

 

 

LG


Ram

 

 

[postgres@lx cronscripts]$ psql -p 5432 -U D-P= ostgres-Backup -d avw1q -c "select current_user"

   current_user

-------------------

D-Postgres-Backup

(1 row)

 

 

postgres=3D# =5Cdu "D-Postgres-Backup&quo= t;

       &nbs= p;  List of roles

     Role name  =    | Attributes

-------------------+-------------

D-Postgres-Backup | Replication

 

postgres=3D#

 

 

[postgres@lx cronscripts]$ pg_basebackup -p 54= 32 -U D-Postgres-Backup -D testing

pg_basebackup: error: connection to server on = socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: = no pg_hba.conf entry for replication connection from host "[local]&= quot;, user "D-Postgres-Backup", no encryption

 

 

 

 

 

Freundliche Gr=FC=DFe

 

i. A. Ramachandran S= ubramanian

Zentralbereich Informationst= echnologie

Alte Leipziger Lebensversich= erung a. G.

Hallesche Krankenversicherun= g a. G.

______________________

ALH Gruppe
Alte Leipziger-Platz 1, 61440 Oberursel
Tel: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882
E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de www.hallesche.de<= /span>

Alte Leipziger Lebensversiche= rung a. G., Alte Leipziger-Platz 1, 61440 Oberursel

Vors. des Aufsichtsrats: Dr. = Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrgen Bierb= aum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Oberursel (Taunus) =B7 R= echtsform VVaG =B7 Amtsgericht Bad Homburg v. d. H. HRB 1583 =B7 USt.-IdN= r. DE 114106814

 

Hallesche Krankenversicherung= a. G., L=F6ffelstra=DFe 34-38, 70597 Stuttgart

Vors. des Aufsichtsrats: Dr. = Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrgen Bierb= aum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Stuttgart =B7 Rechtsform= VVaG =B7 Amtsgericht Stuttgart HRB 2686 =B7 USt.-IdNr. DE 147802285=

Beitr=E4ge zu privaten Kranke= n- und Pflegekrankenversicherungen unterliegen nicht der Versicherungsteu= er (=A7 4 (1) Nr. 5 b VersStG) =B7 Versicherungsleistungen sowie Ums=E4tz= e aus Versicherungsvertreter-/Maklert=E4tigkeiten sind umsatzsteuerfrei

 

Pflichtangaben der ALH Gruppe gem=E4=DF = =A7 35a GmbHG bzw. =A7 80 AktG

--_000_9800cdef81d343d794d7b44adb13f251alteleipzigerde_--