pg_basebackup in tar format with -Xs

2020-06-05 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/app-pgbasebackup.html
Description:

Only since Postgres 10, one can take backup of wals along with full backup
(in tar format) using pg_basebackup

ERROR:
pg_basebackup: WAL streaming can only be used in plain mode
Try "pg_basebackup --help" for more information

You dont see that error since Postgres 10 instead you see a separate tar
file for wals.


Documentation 9.8. Data Type Formatting Functions: missing behaviour on invalid input at to_date()

2020-06-05 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/functions-formatting.html
Description:

For the formatting functions, which convert between a string and a type like
date, timestamp or number, there should be a description about the behaviour
of i.e. to_date(input, mask) in case of invalid, not convertable input.

I expected a return value of NULL and got a execution error.


create database with template doesn't copy ACL

2020-06-05 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/sql-createdatabase.html
Description:

My understanding is that not copying the ACL is the (currently) expected
behavior when issuing CREATE DATABASE newdb WITH TEMPLATE my_tmpl;
It would be useful for the documentation to note this caveat.