Re: pg_basebackup - Mailing list pgsql-general

From Jeff Janes
Subject Re: pg_basebackup
Date
Msg-id CAMkU=1zH=Q7EfZYOo9gS++P4PJEJsRQicWT-sbFHMOCR+P_MmA@mail.gmail.com
Whole thread Raw
In response to Re: pg_basebackup  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
List pgsql-general


On Mon, Dec 23, 2019 at 4:13 AM Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote:
Hello.

At Mon, 23 Dec 2019 03:38:12 +0000, Daulat Ram <Daulat.Ram@exponential.com> wrote in
> thanks Adrian, what about the
> postmaster.opts file, this file was also skipped in backup.

The file is overwritten at startup so there's no point in having it in
a backup. Thus, it is deliberately excluded from a backup.

That is true and sensible, but it does seem to be contradicted by the documentation for 9.5.  In later versions, they added "except certain temporary files managed by PostgreSQL".   That addition seems to just be a correction of the docs, not something to reflect a change in actual behavior, at least in regards to postmaster.opts.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: testing in ESQL/C if a CUSROR "foo" is open?
Next
From: Jeff Janes
Date:
Subject: Re: Are my autovacuum settings too aggressive for this table?