News on PostgreSQL 10

In PostgreSQL 10.0, we have some news:

  • Functions pg_ls_logdir() and pg_ls_waldir() can be executed by non-superusers with the proper permissions
  • The new function pg_current_logfile() reads the logging collector's current stderr and CSV log output file names:
pgbench=# select pg_current_logfile() ; 
   pg_current_logfile    
------------------------ 
 log/postgresql-Sun.log 
(1 row)  

Get PostgreSQL 10 High Performance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.