From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Server instrumentation |
Date: | 2005-06-10 09:32:29 |
Message-ID: | 42A95E2D.5010304@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
This post includes "dbsize backend integration" and "Server
instrumentation: pg_terminate_backend, pg_reload_conf"
Server instrumentation functions included:
pg_tablespace_size()
pg_database_size()
pg_relation_size()
pg_size_pretty()
well-known from contrib/dbsize, waiting in unapplied patches
http://candle.pha.pa.us/mhonarc/patches/msg00002.html
The rest is superuser only:
pg_terminate_backend()
exposing kill -SIGTERM <backendpid> to the client
pg_reload_conf()
SIGHUP to reload configuration files
pg_logfile_rotate()
Logfile rotation
pg_logdir_ls() and view pg_logdir_ls
lists all available log files in the log directory.
As posted in the initial version of the logger subprocess from July 2004.
pg_file_stat()
pg_file_length()
pg_file_read()
pg_file_write()
pg_file_unlink()
pg_file_rename()
pg_dir_ls()
generic file functions to access files in logdir and cluster dir.
These functions where implemented as initiated by Bruce, and discussed
intensively in
http://archives.postgresql.org/pgsql-patches/2004-07/msg00287.php
All functions are fully documented.
Additionally, documentation for pg_postmaster_start_time is included,
the code itself ist posted by Matthias Schmidt
http://candle.pha.pa.us/mhonarc/patches/msg00008.html
Regards,
Andreas
Attachment | Content-Type | Size |
---|---|---|
dbsize.c | text/x-csrc | 6.4 KB |
genfile.c | text/x-csrc | 9.2 KB |
instrumentation.patch | text/x-patch | 27.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Junji TERAMOTO | 2005-06-10 10:17:58 | Re: Daily DBT-3 (DSS) Results on CVS head |
Previous Message | Hannu Krosing | 2005-06-10 08:33:54 | proposed TODO: non-locking CREATE INDEX / REINDEX |
From | Date | Subject | |
---|---|---|---|
Next Message | Atsushi Ogawa | 2005-06-10 12:10:14 | Re: [PATCHES] regexp_replace |
Previous Message | Volkan YAZICI | 2005-06-10 07:34:29 | PQmakeEmptyPGresult() will return NULL if allocation fails |