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

On Mon, 20 Dec 2021 at 08:12, Julien Rouhaud <rjuju123(at)gmail(dot)com> wrote:

> On Mon, Dec 20, 2021 at 8:19 PM Dave Cramer <davecramer(at)postgres(dot)rocks>
> wrote:
> >
> > On Mon, 20 Dec 2021 at 07:03, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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