Server instrumentation

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

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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