PostgreSQL: pgCluu 3.4 and external_file extension v1.1
-
PostgreSQL: pgCluu version 3.4 released
pgCluu is a Perl program used to perform a full audit of a PostgreSQL Cluster performances. It is divided in two parts, a collector used to grab statistics on the PostgreSQL server using psql and sar, a reports builder that will generate all HTML and charts output.
-
PostgreSQL: external_file extension v1.1 released
Allow access to "external files" from PostgreSQL server file systems.
This extension adds the same functionalities given by the Oracle's BFILE data type that stores unstructured binary data in flat files outside the database. A BFILE column stores a file locator that points to an external file containing the data: (DIRECTORY, FILENAME). Here the data type is called EFILE.
The extension access to external files using secure call to the server side lo_* functions and not by directly reading/writing to files.