Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzHNs-0004ng-4u for pgsql-docs@arkaria.postgresql.org; Mon, 20 Dec 2021 12:03:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mzHNp-0007Uq-GN for pgsql-docs@arkaria.postgresql.org; Mon, 20 Dec 2021 12:03:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mzHNp-0007TI-4b for pgsql-docs@lists.postgresql.org; Mon, 20 Dec 2021 12:03:13 +0000 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mzHNi-000394-5W for pgsql-docs@lists.postgresql.org; Mon, 20 Dec 2021 12:03:12 +0000 Received: by mail-wm1-x329.google.com with SMTP id j140-20020a1c2392000000b003399ae48f58so9385209wmj.5 for ; Mon, 20 Dec 2021 04:03:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=U0+6xyOWN74r7a3qsnN6AxiMptSqqq/j42dVSR75RwU=; b=YaN6BL9ONBBjKnNTG7zXHQNcXbwEIYKgW55SQUwCKR2slL1N7tlMB2SaS6FCVXY1mQ wwJgJC3qv603QyOGAJHzHKUSa6lKewUGgqOoTmkkgdWCkfatgucltfZ5n83hGjtdVH26 HXd5pfb4Hm2dKBRUJoIWTz2RRxTvWbY5p8XpoKaKHJUuTD31t7VE2govv7/Nwf8vvXoh X6r10oiY0oSMIE9AqKRABHFZ7IU6l/RUN0uV69Djv6OF38s3q+lP+igXxBpljO9tq3KC Z2oA+VVKqIx/Twx3JxmqCvHKLTPUkaxsRtT7CKFfpAtAFYQwul1DgUMY6yJ9K0bVtBWP Desg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=U0+6xyOWN74r7a3qsnN6AxiMptSqqq/j42dVSR75RwU=; b=0n7oOWYZXk/BdfPZDcLw6G+/0aMd4yPO49mRc0qekY0WTm/LEjSCUwPM0BT7PrPbLq BBE9rYe90a32DdOkiWBna31XOX1Q7FRGF0Gq8x6waQlZSjnbqKXGt7J1ZRS86koVAO62 F6x2HmhHZcdCINojolweOVN4t0aS8tbc8b7dkcXTn2kcqLpAzrt2VwoeZeOy83HL/rp0 O9HOND8Zz/+YFfugHvwdJ4Te4gYsTShBoQ+kWaoecebyHzNeRPinhmAjLqZBOY4H+9GN dwTIk8AUlaf7o6NCq17T5Vl3FuY4X9Aa0ETx/v0z49usgnRsBP5sGXZYHnDL7Gj2UeRQ ILmQ== X-Gm-Message-State: AOAM533QX9VWtVfDEaqINEcWuZKCyXF0xJEqZlPRvxKOTkqIye8JjUWO Ynq3mHEBnwWtvehHz0v1yaqB6qH0uni4pg== X-Google-Smtp-Source: ABdhPJxRYG6OHcheMxtvCLXy45TMvbIQDgUxrFeGpbfQgX9ymbBrZRbwyi1Uc+uOlDecTkNWFBQoJw== X-Received: by 2002:a05:600c:c8:: with SMTP id u8mr4068170wmm.171.1640001784817; Mon, 20 Dec 2021 04:03:04 -0800 (PST) Received: from localhost.localdomain (dynamic-ea56v0yq1af369vy6-pd01.res.v6.highway.a1.net. [2001:871:5e:542:bca5:5e99:725a:2bfe]) by smtp.gmail.com with ESMTPSA id q14sm12419546wro.58.2021.12.20.04.03.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 20 Dec 2021 04:03:04 -0800 (PST) Message-ID: Subject: Re: The pg_stop_backup will return one row with three values. From: Laurenz Albe To: davecramer@postgres.rocks, pgsql-docs@lists.postgresql.org Date: Mon, 20 Dec 2021 13:03:03 +0100 In-Reply-To: <163994808959.26053.3206807775509915477@wrigleys.postgresql.org> References: <163994808959.26053.3206807775509915477@wrigleys.postgresql.org> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) MIME-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2021-12-19 at 21:08 +0000, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/14/continuous-archiving.html > Description: > > It appears that this may be out of date. > > pg_stop_backup > --------------------------------------------------------------------------- >  (0/2000138,"START WAL LOCATION: 0/2000028 (file 000000010000000000000002)+ >  CHECKPOINT LOCATION: 0/2000060                                          + >  BACKUP METHOD: streamed                                                 + >  BACKUP FROM: primary                                                    + >  START TIME: 2021-12-19 13:39:19 EST                                     + >  LABEL: label                                                            + >  START TIMELINE: 1                                                       + >  ","") > > > Seems to be returning 7 values ? No, that is one value with 7 newlines in it. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com