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 1tpn9o-00CBRb-AZ for pgsql-docs@arkaria.postgresql.org; Wed, 05 Mar 2025 11:43:24 +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 1tpn9m-008o4P-2c for pgsql-docs@arkaria.postgresql.org; Wed, 05 Mar 2025 11:43:22 +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 1tpn9l-008o4H-NR for pgsql-docs@lists.postgresql.org; Wed, 05 Mar 2025 11:43:21 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tpn9j-00166b-1v for pgsql-docs@lists.postgresql.org; Wed, 05 Mar 2025 11:43:20 +0000 Received: by mail-ed1-x536.google.com with SMTP id 4fb4d7f45d1cf-5e52c1c3599so5738720a12.2 for ; Wed, 05 Mar 2025 03:43:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1741174998; x=1741779798; 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=gn9Axsy/0XNpSqHVWjWzFSkkmzvSE6+Z/0yIT2KC5KU=; b=RSQ7gZgvKG/GlpBqiUeOI9h6Pe3JOww92975sydxx0P7oBWZx52TwV214yad40cu+7 GbYv1rSEXEBKWBEjdcoCgQ+XLElAQ19pFW+ccugSvHVvWA2foTyMM0CJk2L/8hCgYSfR Sczu7OFMQxNHy2BV3ltY8NaXfHDfI7itqYFutfOtLoI5RXF6QlEhKH6Qw4/ID86nj2WW 1nUKAUwKC2ynle7ovwcR/uifBJSUKTdCLg03dGafq5qPsDhsSa40R9JYYvOjPZZL61Mx Z57lwIcEEEYBde+cP38biLnhg6HebQvyiVIYOHUUpR9ORvw48L2cDwaUNhmwsN12EpV6 KTJQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741174998; x=1741779798; 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=gn9Axsy/0XNpSqHVWjWzFSkkmzvSE6+Z/0yIT2KC5KU=; b=hUfJdyQfHRyYAh6tLBrWh6l4O5RXMABA+FC1DlbAbbhHgIe/EAVNhOT7Yd31L+Ml1j u87GCN4arpQ2Zf4NFu0h7GLck4ighdocWrEiyVPS6UbiCP/0K1niE3VFN4Eqk8o7ObhS uIgpBstBICod3Hss9K3Oz/UhepdF07Xua1bS/LK7umsbEOENzMvopTqojOadSw1C85r1 fY579wSJTI+Wy8cwph+/tgERBcA1eSfxayKPA+BjEHDaTobrxvZx1yV4PbPF4n0jworX iPP13vrnGocGp13l9QNQm6fGEeALp9heADne7e7/8hsmq6jzwSS1A+rJBElsZXxS3qBw X1lQ== X-Gm-Message-State: AOJu0Yz3KibNgrBSh/tdf7Nx0d9RoaQqDrlQw9TPzWpahpZNbLWSrw+O 3ul7lH0uFDsf1BU5q1ASmI5ZbaB2UL9lLRwLDZCRWwg27ErzXN8hxgMm+GjHd5dvohUj8Yu9DHr VK2w= X-Gm-Gg: ASbGnctItVrfsdHMqiKZor7iZjyeaBXLG2ZiwnSyJHS9iHv7NbUqrrE0MZs3eGcwzIl ueN569pyzxwFJZKKwqJAlWv+2+G0DG80xjmkph/sazc5q6LMBOu9Fc2zoSZ10gRPJbsknx82s86 A7RPX4/wYtPPpHddhS7sUvSKkCqFJyfMMW2D73OFxnL9aFOO83hpI8wUpGxnXtVNzj0Pa/+JSlD 3iRU+o55l4KEGvio8TDMAC6+0QVH806ifhXnLwZDdP+DXY1FSNRbRtqd9PkcgsapDRT78dBjuPW eUtfzggEaRR9SruIzDZulrcR6ngIFIbjbP+HKyTugFEC6k0VymkqdKDDN+7M9ccw X-Google-Smtp-Source: AGHT+IE7FHcjY7xjsZ8F9IsGYXGk9dORgaNge2V9PbqrVnGlXiQmOvd642NwxsgeQ9ZZ26HR6N0deg== X-Received: by 2002:a17:907:970b:b0:ab7:8d23:1fef with SMTP id a640c23a62f3a-ac20d990c3fmr255797566b.9.1741174998064; Wed, 05 Mar 2025 03:43:18 -0800 (PST) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ac1e0dd63b5sm385955766b.164.2025.03.05.03.43.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 05 Mar 2025 03:43:17 -0800 (PST) Message-ID: <6403690228aced89510ee95bad2665310bdd014a.camel@cybertec.at> Subject: Re: pg_basebackup restore From: Laurenz Albe To: Anatoly Pugachev Cc: pgsql-docs@lists.postgresql.org Date: Wed, 05 Mar 2025 12:43:17 +0100 In-Reply-To: References: <174090763300.680.15070040454451989837@wrigleys.postgresql.org> <38716d35b26e023a20d2d987e9a7a5c0967c3556.camel@cybertec.at> 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 Wed, 2025-03-05 at 14:48 +0400, Anatoly Pugachev wrote: > > > > > Is there any way to restore pg_basebackup ? Reading current docum= entation on > > > > > pg_basebackup I could not find any "restore" word in it. > > > >=20 > > > > Try looking for "recovery": > > > > https://www.postgresql.org/docs/current/continuous-archiving.html#B= ACKUP-PITR-RECOVERY > > >=20 > > > I mean it's a completely different page, but the pg_basebackup page > > > has an examples section. Or please put a link to pg_basebackup page t= o > > > restore/recovery page (continuous-archiving.html), explaining how to > > > restore a backup. > > >=20 > > > But actually, would be nice to put to the examples section of the > > > pg_basebackup page. > >=20 > > A hyperlink might be a good idea. >=20 > thank you. If you can do anything about it, thanks again. Looking again, there is such a link in the very first paragraph of the "Description" section: The backup is taken without affecting other clients of the database, and can be used both for point-in-time recovery (see Section 25.3) ^ the link that I mean and as the starting point for a log-shipping or streaming-replication standby server (see Section 26.2). So I don't really see how that could be any better. Yours, Laurenz Albe