Linuxkommando.com::linux,ubuntu,software,news,reviews,articles

The new version of the DBMS PostgreSQL – 9.2.

The main changes in this version:

• «Index Only Scans» – the ability to choose the data directly from the index if the index they are. Prior to that database to use the index for searching the data itself is always chosen from the data pages. This feature only works if the page with the desired data has not changed since the last VACUUM.
• Cascading replication – standby server now also can send a transaction log to other sites
• JSON data type support for unstructured documents
• Added data types for a range of values

(more…)

The popular open source database PostgreSQL improves the clustering features – at least in the paid Enterprise version.

Effective immediately, the manufacturer of the commercial version of PostgreSQL multi-master replication for the database server. That the company EnterpriseDB reports on its website , where the software for the x86-64-bit platform is available for download. 32-bit Linux, Windows, Solaris and HP-UX are to follow.
(more…)

2ndQuadrant company announced the first version Barman - a set of python-script to backup database PostgreSQL.

The utility allows you to:

• producing a “hot» backup database on the file system, archive logs changes in the process of using a remote access ssh;
• backup’om manage multiple servers;

(more…)

PostGIS, an additional module for geographic objects in PostgreSQL, released in version 2.0. PostGIS can be used with the PostgreSQL object-relational database as a database for geographic information systems.

The developers of PostGIS Refractions Research have provided their GIS expansion with several new features. Users can now analyze, for example, in PostgreSQL stored raster and vector data within the database system and create 3D and 4D indices. Closest point search index can be based and PostGIS extension was integrated into the system of PostgreSQL 9.1.
(more…)

EnterpriseDB, PostgreSQL-based provider of database systems, has introduced its services to complement an enhanced version of PostgreSQL for the cloud.

EnterpriseDB has been providing products and services in March 2004 based on the free database PostgreSQL for business use. Includes not only the basic version of PostgreSQL binaries and an installation program, the company offers an expanded version as “Postgres Plus Standard Server” and “Postgres Plus Advanced Server.” The latter is particularly suited to large customers with a correspondingly large databases and high performance requirements.
The trend toward cloud now also joins EnterpriseDB and Postgres Plus database published as a cloud database for the Amazon cloud and HP Cloud Compute. For the database to service, will use the customer directly, without need to first set up laboriously.
(more…)

PostgreSQL Global Development Group has introduced a new version of the popular database server PostgreSQL – 9.1.0. According to the developers, the new version adds a unique functionality that goes beyond the capabilities of ordinary relational databases.

Major changes in new version:

• Synchronous replication in a distributed database.
• Support for external tables (ie, reading files outside the database as tables). While it is possible only reading, writing is not supported.
• Support the COLLATE clause to select the character sorting (collation).
• Support for extensions to the server.
• Complete isolation serializable (serializable) transactions. Older versions may be some anomalies, which are now eliminated. Old isolation algorithm now corresponds to the «Repeatable read».

(more…)

A new stable version of a free ERP system ADempiere 370 LTS.

This system develops enterprise management community since 2006. Written in Java and supports the PostgreSQL database and Oracle Database. The system includes modules to manage customer relationships, sales, purchasing, production, personnel, etc. The system also offers advanced rendering engine workflow (Workflow).
(more…)

with the author of PHP developers and PHP6)

WEB-invite developers to participate in the 10 th International Conference DEVCONF:: PHPCONF 21-22 May 2011!

The conference program includes the following interesting statements:

Day One (21 th):

• Marcus Bourgerus (Google) to report “Introduction to pure functional PHP”
• Perl & Silverlight: A new alternative for creating Rich Internet Applications
• Collaboration Microsoft & Zend – PHP: DOTNET
• Perl, and Web 2.0

(more…)

The MC Richter GbR has published its accounting software Lin-Habu and the Windows and Mac versions in version 11 with new features.

Thus, the version number now corresponds to the calendar year, further releases of one year are counted for a point. The biggest change in version 11: The diamond-edition of the software can use in addition to the real SQL Server PostgreSQL as the database now.

The Magpie interface was adjusted in Habu options for 2011. As in the journal can also be used in the cash book trailer. The software also now import transactions from court fees program Lin / Win / Mac-Neko. (more…)