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 1qxRP7-000u25-E7 for pgsql-admin@arkaria.postgresql.org; Mon, 30 Oct 2023 12:30:01 +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 1qxRP6-00DUdr-4t for pgsql-admin@arkaria.postgresql.org; Mon, 30 Oct 2023 12:30:00 +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 1qxRP5-00DUdj-KP for pgsql-admin@lists.postgresql.org; Mon, 30 Oct 2023 12:29:59 +0000 Received: from mail-ej1-x62b.google.com ([2a00:1450:4864:20::62b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qxRP1-0032va-E1 for pgsql-admin@lists.postgresql.org; Mon, 30 Oct 2023 12:29:58 +0000 Received: by mail-ej1-x62b.google.com with SMTP id a640c23a62f3a-9be3b66f254so653477066b.3 for ; Mon, 30 Oct 2023 05:29:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1698668993; x=1699273793; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=i/VvLfAqbGdTJ8PZfzf538D8UXjLmjxPn5kuN/oOr8E=; b=nGQanKAoHUDP1Y/p0Aurqemyr9euPLU7PNlNLoiavPUGW31KTm/Z0umn6qys1Sv0fc rxgy/PnoXLD1hGD7xozkhnW5+s48si5lt3LRxDcLdY8Bik5D3agQhzFMvO9M2DmdujAO kSm832GVMTDJN9kcJn9j7V0/2D6pnPksdu1ROjvqFOq/wLOYT4i+cv6d7627OAdARZoA CHqNc1YrztShzHkAUy5pd4SO/AnksaNCVqwtaGDSngoVXKcFgZsHa/ysFdS6zzrq/l3q v26wT1z3WUdepJU2FEMlKfCsY+3oXl1Qg845XFKO5vPU62L+1tzLRDkCvtQ8tpa79iVA LvCg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698668993; x=1699273793; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=i/VvLfAqbGdTJ8PZfzf538D8UXjLmjxPn5kuN/oOr8E=; b=lSaj8Z2UgKcxszgriLhUwzw4NA2W3Vd21chJsB5RMtCYInU4ltiZ2t1EzCvVvoTplN izU5L/8FzIPPpIA4u6W2S7jyJDpoQdQJnDOIxBMN8XSWHQFPJpMA7qdgUrWrpKRdp/82 MV/A5S+L42R81Z/qO3LrsQ0SGNlu9RoeOeM/c6jApey3WnCIJ++kuGDVM4/nv79StBbV QRBgsknZHBRnb2APdPq6+StRmOXbp2R45e1yEkMipn83li9ZLRtRiG3oeRHnjPCat74W 0fQZl4NOIvc7XkUuOqp/+f/RItkwh5NuKf/QMdTJNjr00XI9ompuVBJ8b0F2Y5aWBq2z nRgQ== X-Gm-Message-State: AOJu0Yw8GAH/pxxkjrkAhbSiCljNAFgiJniJcGTyQwiJw7fouV9oRKHi zGmW1n3ALLSNrd+QFx5wQ8NqVg== X-Google-Smtp-Source: AGHT+IGNLIwuSSKZkgKh0ZD4+P2+Rer/EIei7IKMRHuQRZeIfVe2KKRHHFA+TytY1TBELAYs/tnCng== X-Received: by 2002:a17:907:2684:b0:9bd:bbc1:1c5f with SMTP id bn4-20020a170907268400b009bdbbc11c5fmr8094543ejc.35.1698668993292; Mon, 30 Oct 2023 05:29:53 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:3a88:d8ad:2c90:101a:9246]) by smtp.gmail.com with ESMTPSA id y4-20020a170906470400b009ad778a68c5sm5929211ejq.60.2023.10.30.05.29.52 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 30 Oct 2023 05:29:53 -0700 (PDT) Message-ID: <164cc3ba568cc350de5a7367df94972533ca2935.camel@cybertec.at> Subject: Re: On Replica - History issue From: Laurenz Albe To: SOzcn Cc: pgsql-admin@lists.postgresql.org Date: Mon, 30 Oct 2023 13:29:52 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2023-10-30 at 13:48 +0300, SOzcn wrote: > > > Oct 27 13:33:26 se-prd-db02 postgresql@13-clustername[316944]: 2023-1= 0-27 13:33:26.808 +03 [316957] FATAL: could not restore file "00000003.his= tory" from archive: command not found > > > Oct 27 13:33:26 se-prd-db02 postgresql@13-clustername[316944]: sh: 1:= pgbackrest: not found > > > > You should use the absolute path to "pgbackrest" in the "restore_comman= d". >=20 > "restore_command" is default . > my archive command is ;=C2=A0 > archive_command =3D 'pgbackrest --stanza=3Dcluster_stanza archive-push %p= '=C2=A0 >=20 > with this way I setup my backup procedure without=C2=A0problem, is there = might be another problem I cannot see? You get a fatal error restoring a file from the archive, because the restor= e command is not found. What is unclear about the error message? Why don't you try the absolute pa= th? Yours, Laurenz Albe