adminpack provides a number of support functions which
pgAdmin and other administration and management tools can
use to provide additional functionality, such as remote management
of server log files.
Use of all these functions is only allowed to the superuser by default but may be
allowed to other users by using the GRANT command.
The functions shown in Table F.1 provide
write access to files on the machine hosting the server. (See also the
functions in Table 9.99, which
provide read-only access.)
Only files within the database cluster directory can be accessed, unless the
user is a superuser or given privileges of one of the
pg_read_server_files or
pg_write_server_files roles, as appropriate for the
function, but either a relative or absolute path is allowable.
Table F.1. adminpack Functions
Function Description |
|---|
Writes, or appends to, a text file. |
Flushes a file or directory to disk. |
Renames a file. |
Removes a file. |
Lists the log files in the |
pg_file_write writes the specified data into
the file named by filename. If append is
false, the file must not already exist. If append<