Re: The pg_stop_backup will return one row with three values. - Mailing list pgsql-docs

From Dave Cramer
Subject Re: The pg_stop_backup will return one row with three values.
Date
Msg-id CADK3HHK249TsNAKQ2V7O3Zb5M0XFuL8MCnj4C_W87F2ps+xPsg@mail.gmail.com
Whole thread Raw
In response to Re: The pg_stop_backup will return one row with three values.  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-docs

On Mon, 20 Dec 2021 at 08:12, Julien Rouhaud <rjuju123@gmail.com> wrote:
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)

Thanks Julien, that makes more sense, although I have to say this part of the manual is pretty tough reading.

Dave 

pgsql-docs by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: The pg_stop_backup will return one row with three values.
Next
From: PG Doc comments form
Date:
Subject: ^@ operator for text