pgwatch – Cybertec Enterprise PostgreSQL Monitor
Latest Release: Pgwatch 1.0 DOWNLOAD
PLEASE NOTE: Version 1 of pgwatch is no longer being developed and is not recommended for current PostgreSQL versions!
We are currently working on pgwatch 2.0 with many new features, new look and feel and top performance.
PostgreSQL Database Links: ODBC-Link 1.0.4
ODBC-Link is a dblink-style implementation of database links for PostgreSQL. It allows people to connect from PostgreSQL to any ODBC compliant data source and fetch data from any ODBC compliant remote data source. Using ODBC Link you can easily integrate PostgreSQL with other databases and easily send data across a network. In contrast to other implementations ODBC-Link is entirely written in C and offers superior performance and little overhead.
You can either [intlink id=”926″ type=”page”]read its documentation online[/intlink] or download as pdf.
Enhanced Linux OOM-killer functionality
This patch allows administrators to flexibly configure the Linux kernel OOM-killer to kill processes defined by the administrator rather and processes selected internally.
To use this feature, edit /proc/sys/vm/oom_preferred_tasks.
Here are some examples:
The string accepted is up to 4096 bytes. Processes can be listed using a comma separated list.
3 types of config are allowed:
- full path of the executable, checked using the /proc/PID/exe link
- file name of the executable without the path, also checked as above
- file name of the executable without the path, checked using the “comm” property of struct task_struct, which is approximately the process name as visible in top/ps.
A small test program and the patch itself for 3 different kernel versions:
- Patch for linux kernel version 2.6.27-3:
- Patch for linux kernel version 2.6.32:
- Patch for linux kernel version 2.6.33rc8:
CONNECT BY for PostgreSQL 8.3
Many people from around the globe have been asking for a method to perform recursive queries with PostgreSQL.
Here is an example:
SELECT METIER_ID||'|'||ORGANISATION_ID AS JOBORG FROM INTRA_METIER,INTRA_ORGANISATION WHERE METIER_ID IN( SELECT METIER_ID FROM INTRA_METIER START WITH METIER_ID= '99533220-e8b2-4121-998c-808ea8ca2da7' CONNECT BY METIER_ID= PRIOR PARENT_METIER_ID ) AND ORGANISATION_ID IN ( SELECT ORGANISATION_ID FROM INTRA_ORGANISATION START WITH ORGANISATION_ID='025ee58f-35a3-4183-8679-01472838f753' CONNECT BY ORGANISATION_ID= PRIOR PARENT_ORGANISATION_ID );
CONNECT BY will help you to query trees fast and efficiently.
A PostgreSQL 8.3 RC2 based tarball can be downloaded here: postgresql-8.3RC2_recursive_edition.tar.gz
pg_matlab: Matlab / PostgreSQL integration
Cybertec offers an easy to use module to allow efficient PostgreSQL – Matlab integration. We offer PostgreSQL users who want to connect Matlab and PostgreSQL a daemon which can be accessed from PostgreSQL.