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.94.2) (envelope-from ) id 1teX12-00E7WL-UR for pgsql-admin@arkaria.postgresql.org; Sun, 02 Feb 2025 10:15:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1teX12-006wmB-01 for pgsql-admin@arkaria.postgresql.org; Sun, 02 Feb 2025 10:15:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1teV7S-006g97-3V for pgsql-admin@lists.postgresql.org; Sun, 02 Feb 2025 08:14:18 +0000 Received: from mail-wr1-x42b.google.com ([2a00:1450:4864:20::42b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1teV7O-002kjC-2h for pgsql-admin@lists.postgresql.org; Sun, 02 Feb 2025 08:14:16 +0000 Received: by mail-wr1-x42b.google.com with SMTP id ffacd0b85a97d-38a34e8410bso1678075f8f.2 for ; Sun, 02 Feb 2025 00:14:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1738484053; x=1739088853; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=BvrX3rBcf/QoUABVfkhnmxXD9Q0FJRB/m4KVezsJ9v4=; b=gOQYA/t5AKnqNBDPhhJmqyWw39ZtiGBWCn5VtZ0VOHeWl+TYfRzNaeH+4xEonn60RF Ok0sEwHX2B//VlyNYwXztbcD3LEWg1n2Xlk77GrbbPNrjOatUTTqa1EVJKYKzKQ/I5+X DPAXr+qcUxbN0ItlOPCjXLB4/g9C9QhL4pjf6puImKxxW6bKFDIQuBKpEg/tVU+2vdJG HYrEeGwE852bX0dH/yz0PiBcUUjvWt+T4CHkaHopjL9/r7vQuCOI62GjFUe3ZwTpkNAp khNR4nBcQDprX0yaepcilkoe6Df3Fg2UaMBEjM/tjbeteS/0+oDLyWIL9sTOzP5AMZx1 C7FA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738484053; x=1739088853; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=BvrX3rBcf/QoUABVfkhnmxXD9Q0FJRB/m4KVezsJ9v4=; b=HF7+b8Tr2QBlFmPE5/uarLYwR7z14Q0sLFd52N0hiT8FIYYBp7M5nV4QfPSNe5w4C7 Y3NNq7tbfCMg+XAnPwlbMIaan2vlazNaPXjv/JUcrqH/hsrBluMbTUD0hBVzomTYzkKI ErwiLy5hGd9+kYqKlZnjtoYJLHqcZGaD11H+fmlaND0sQ4qytcXz2ioeR1Fs1vUnPuYs jT28jR6csCudL98KGdt0SxWsRhDWGerv4VDaFYdzJgoN74xAR9BL31b9ZXibK8GeuHkD BkZ7hIb5W5RtnKqP/zIxgCzVzudhIAkRIDSbQ/62c2wv36avbHTQ3MgsbebHyGO4jbPJ c1Uw== X-Forwarded-Encrypted: i=1; AJvYcCV1IkPco+Ns+0nWBybdFd5jLofmz/JStaP5ERg5zBCCfpDWb8Ik9vEHswKPr+V8uXD0TEITvVtCaG/mjw==@lists.postgresql.org X-Gm-Message-State: AOJu0YzlYO7fbi8OipKNzRM9vmxZTq6T7LK+9+EmOoW3Y7ebHJ6GtbEl YDngtDImD91EX/HMgzaDxJ8ZMhcsBnr7fD9e3C74HSvcgtnyWGuhEpTHvmPI8f8= X-Gm-Gg: ASbGncsRZRo2N7lqJo5716rsElEer4DypFaBPhA+06CjBs0jmuQpT+8ZnLEt0bF6neF rVZ+H/KT2zwCUOhrEbyEf0rJ7VpPNRECIUXaigPdQrD2PWvzZrTgmKf0JgW1O/qRA/dqUBwF50d FUM2ZvWL0gBTw9o53OEN/s6saoMIyN4EBMq/7QfNjALCGKzW9BHmR693qCMe29EmW9IvjQzAytt PxOAha2ew1LSsBU4bZCCl1VonBZ/uC95YLSktMW3Ba90QFBBTiXYggsubGWm98u4hbbsxc285Ee 5qPf9SsE4JmPRY+givCiupgIrFG3R6wYq3w= X-Google-Smtp-Source: AGHT+IF3JAL+e6XUpcLriFoEhmTCCasm7dm+q/BRdLnZaaIJNirX3wztghocVYxc9N4QXq5DLv97tw== X-Received: by 2002:adf:f303:0:b0:385:f13c:570f with SMTP id ffacd0b85a97d-38c51b8838cmr12066855f8f.33.1738484053282; Sun, 02 Feb 2025 00:14:13 -0800 (PST) Received: from localhost.localdomain ([2001:871:5e:69d4:e9ee:ede4:3685:556d]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-38c5c1cfa2fsm9531337f8f.91.2025.02.02.00.14.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 02 Feb 2025 00:14:12 -0800 (PST) Message-ID: Subject: Re: Backup Issue for pg_basebackup From: Laurenz Albe To: Somnath Som , pgadmin-support@lists.postgresql.org, Pgsql-admin Date: Sun, 02 Feb 2025 09:14:11 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2025-01-31 at 10:42 +0530, Somnath Som wrote: > We are getting below error when running pg_basebackup for a database. >=20 > pg_basebackup: error: FATAL:=C2=A0 no pg_hba.conf entry for replication c= onnection from host "127.0.0.1", user "postgres", SSL on > FATAL:=C2=A0 no pg_hba.conf entry for replication connection from host "1= 27.0.0.1", user "postgres", SSL off -e Add an entry like host replication postgres 127.0.0.1/32 trust Reload PostgreSQL, and you should be fine. Yours, Laurenz Albe