Downloads

Cybertec-Software Downloads

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.

Please read the release notes, readme and the license agreement.

—————————————————————–

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.

ODBC-Link-1.0.4.tar.gz

—————————————————————–

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:

  • “mallocbomb”
  • “mytask,mallocbomb”
  • “mytask,mallocbomb,myprog”

The string accepted is up to 4096 bytes. Processes can be listed using a comma separated list.
3 types of config are allowed:

  1. full path of the executable, checked using the /proc/PID/exe link
  2. file name of the executable without the path, also checked as above
  3. 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:

mallocbomb.c

—————————————————————–

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.

Download pg_matlab-v2.tar.gz.