incoorect restore_command
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/continuous-archiving.html
Description:
Hi everyone,
I've been trying out saving and restoring compressed archive logs. The
restore_command stated in the docs at "25.3.6.2. Compressed Archive Logs"
('gunzip < /mnt/server/archivedir/%f > %p') did not work for me, because the
archive_command ('gzip < %p > /var/lib/pgsql/archive/%f') alters the
filename to %f.gz
I had to change the restore_command to 'gunzip <
/mnt/server/archivedir/%f.gz > %p'.
Phil
pgbench: supports PGDATABASE / warning about -d
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/legalnotice.html Description: 1) pgbench has always supported the PGDATABASE env variable, but it is not listed along PGHOST/PGPORT & PGUSER in https://www.postgresql.org/docs/13/pgbench.html#id-1.9.4.10.8. PGDATABASE is listed in the pages of the psql/pg_dump/createdb... utilities 2) In "Common options", it would be useful to add a warning that "-d means --debug and does NOT define the database, contrary to most other PostgreSQL utilities". (It seems to work and the consequence is a flood of SQL orders on the screen.)
