PostgreSQL 9.0 Beta Now Available The first beta version of the DBMS PostgreSQL 9.0Marked the transition from the functional capacity to detect and correct errors. PostgreSQL 9.0 is the first release with built-in binary data replication in real time, which enables hot backups and streaming replication. In version 9.0, a large number of new features will allow developers and DBAs to broaden their use of PostgreSQL, including: New binary replication 64-bit support on Windows Support for Python...Read Full Story
PostGIS for PostGres
For many years there has been a limited choice of geodatabases when looking for a single solution for all geodata models. Only Oracle Spatial and ESRI offered comprehensive coverage of spatial models. Oracle Spatial provided database models and algs for vector, network, raster and topology in addition to the usual database refinements and in database geocoding. ESRI offered ArcGIS Server with comprehensive support for Vector, Network and Raster models but left topology...Read Full Story
When it comes to data issues (too many rows, no data found, etc), in Oracle stored procedures, I am used to having exceptions raised that I then handle. PL/pgSQL does not raise exceptions for the same conditions in the same way. The Postgres docs are pretty complete though and through some reading this weekend, I discovered a new keyword. For example, assuming that I have this table (which is empty) in both Oracle and Postgres: CREATE TABLE empty_table ( empty_col integer ); In Oracle this...Read Full Story
dotConnect Express for PostgreSQL is a free of charge database connectivity solution built over ADO.NET architecture. It offers basic functionality for developing database-related applications, web sites. dotConnect for PostgreSQL Express is a free of charge database connectivity solution built over ADO.NET architecture and a development framework with number of innovative technologies. It offers basic functionality for developing database-related applications and web sites. It introduces new...Read Full Story
Yesterday, Postgres made it to Mashable , today it got a mention in E-Commerce Times, Open Source for Business: Now More Than Ever, Part 1 . The article isn't about Postgres specifically. It's about business targeted OSS uptake in the enterprise. There's an "open source roundup" "based on the recommendations of business leaders". The Postgres entry: Postgresql: PostgreSQL is an open source relational database system. It runs on all major operating systems, including Linux, Unix (AIX, BSD, HP...Read Full Story
EnterpriseDB, the leading worldwide provider of PostgreSQL and Oracle compatibility products and services, today announced general availability of Postgres Plus Advanced Server 9.1. The release features significant performance enhancements, including the ...
As mentioned in an earlier post, we're announcing the start of a PUG for Arizona. The first meeting will be Thursday, March 29, from 5 to 7 at Bull's facility in Northwest Phoenix. Refreshments will be provided.
You can join and get onto the mailing list and RSVP for the first meeting at https://www.bigtent.com/groups/azpug
We look forward to meeting other PostgreSQL lovers and to help grow the PostgreSQL community in our part of the world...
Postgres Plus Advanced Server 9.0, which debuted last July, was the first release to support HP-UX – the HP-UX 11i v3 release, to be precise. You could roll your own PostgreSQL database from the source for HP-UX 10.X and 11.X versions for many years ...
While setting up munin to monitor postgresql, I was getting "[DBD::Pg not found, and cannot do psql yet]" when running `munin-node-configure --suggest | grep postgres`.
I confirmed that the rpm package "perl-DBI-1.52-2.el5" was indeed installed.
However, when I ran a test against the module, it failed with:
# perl -MDBD::Pg -e 1Can't load '/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Pg/Pg.so' for module DBD::Pg...
Postgres is an ideal database to run in a virtual environment or public/private cloud — one reason is that Postgres relies
heavily on the operating system, rather than using features like raw devices. Second, its license is obviously very flexible for virtual
deployments.
I am often asked about running Postgres in virtual environments, and I usually answer that it runs just fine --- and it does. However, I
am starting to realize that I am...
Not so long ago I used Common Table Expressions for Fibonacci Numbers calculation.
Today I had a conversation with one client about SQL in general and about PosgreSQL dialect in particular. We talked about SQL’s Turing completeness also. Well my opponent is sure that SQL (Postgres dialect either) is not Turing Complete. But I know for sure that if SQL supports CTE it is Turing Complete. Well, I’m sure about it because some time ago at Oscon...
An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online or hot backups, a sophisticated ...