Re: The pg_stop_backup will return one row with three values.

On Mon, Dec 20, 2021 at 8:19 PM Dave Cramer <davecramer@postgres.rocks> wrote:
>
> On Mon, 20 Dec 2021 at 07:03, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>>
>> 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.
>>
>
> The docs say it returns 3 values ?

It's 3 values, one of them containing a lot of newlines.  To make it clearer:

=# select (pg_stop_backup(false, false)).*;
    lsn    |                           labelfile
    | spcmapfile
-----------+---------------------------------------------------------------+------------
 0/9000138 | START WAL LOCATION: 0/9000028 (file 000000010000000000000009)+|
           | CHECKPOINT LOCATION: 0/9000060                               +|
           | BACKUP METHOD: streamed                                      +|
           | BACKUP FROM: primary                                         +|
           | START TIME: 2021-12-20 21:11:10 CST                          +|
           | LABEL: meh                                                   +|
           | START TIMELINE: 1                                            +|
           |                                                               |
(1 row)