::Planet PostgreSQL::::Planet PostgreSQL:: - http://www.planetpostgresql.org/Robert Treat: Bacula, Sqlite, Postgres... when good tools go horribly horribly wrong- September 17, 2008 I'm in the midst of moving a Bacula system from Sqlite to Postgres, and I've got to say it's such a mess it's actually hard to believe things are this bad; almost to the degree that you have to wonder if things were planned to be this bad. Here is the scenario: Problem 1: The Bacula sql file for Sqlite uses unquoted StudlyCaps for table names This is bad because it produces different behavior in different databases. In Sqlite, you end up with MiXeD cAsE identifiers. If you try to load it...http://people.planetpostgresql.org/xzilla/index.php?/archives/360-Bacula,-Sqlite,-Postgres... Devrim Gndz: Moving towards multiple version installation with RPMs- September 17, 2008 $SUBJECT is a long-term todo even before I started building PGDG RPMs about 4 years ago.I will keep it short: Command Prompt decided to sponsor this project now, which means I will be able to spend valuable hours on this. I will start working on this as of November, where 8.4 will hopefully enter feature freeze. Don't expect much complexity and tons of scripts like some other distros do -- I will tryto keep whole process as simple as I can.Probably development wil take about a month, but who...http://people.planetpostgresql.org/devrim/index.php?/archives/122-Moving-towards-multiple-... Kenny Gorman: Unique identifier for a database without connecting to the database- September 16, 2008 In PostgreSQL, the working directory is a unique identifier for a database, and sometimes you want to use that working dir in your script(s). But what if you don&8217;t want to actually connect and query the database Is there a way to find out the unique identifier for the db In a high transaction environment, making the archive process fast and efficient is very important, so keeping an eye on efficiency when coding up these little bits is paramount. The key lies in the proc filesystem in...http://www.kennygorman.com/wordpress/?p=256 Bruce Momjian: Back to Work- September 16, 2008 My father-in-law died on Sunday. I should be back to full-time work next week, and I will consider resuming my travel schedule in early October. Though my father-in-law never attended an open source conference, he did meet the many Postgres community members who visited my home.http://momjian.us/main/blogs/pgblog.html#September_16_2008 Frank Wiles: Why isn't PostgreSQL using my index- September 16, 2008 This is a common question I see from PostgreSQL users. In fact, someone was just in IRC asking it and it prompted this post. The exchange usually goes: Steve: I have this column foo and I have an index on it, but when I do SELECT FROM table WHERE foo = X, EXPLAIN doesn't use the index. What am I doing wrong 90% of the time the answer is unfortunately "Because the query optimizer is smarter than you are". Or maybe it's fortunately depending on how you think about.http://blog.revsys.com/2008/09/why-isnt-postgr.html Gavin M. Roy: Golconde 0.1 Released- September 16, 2008 I have just created the initial alpha release of Golconde, a loosely coupled data distribution system for PostgreSQL. It requires the use of plpythonu and ActiveMQ, is a trigger based system and is not transaction safe. It is currently a very alpha product, but in my test environment, it does what it is expected to do. For more information, please visit the project page at http:code.google.compgolcondehttp://www.gavinroy.com/2008/9/16/golconde-0-1-released Robert Hodges: Bringing Open Source Replication to the Oracle World- September 15, 2008 Replication is one of the most useful but also also one of the most arcane database technologies. Every real database has it in some form. Despite ubiquity, replication is complex to use and in the case of commercial databases quite expensive to boot.We aim to change that. On Tuesday we will be announcing replication support for Oracle. Oracle replication will be based on our open source Tungsten Replicator, which is currently available in an alpha version for MySQL. Our goal is to...http://scale-out-blog.blogspot.com/2008/09/bringing-open-source-replication-to.html Joshua Drake: WEST Conference shaping up nicely- September 15, 2008 Once again West this year is running on a truncated calendar. Registration is now open!. We had originally planned on announcing and organizing from June till end of conference. Unfortunately that didn't work out as planned and we are back on the 6-8 week time line. Nothing like Just in Time delivery!http://www.commandprompt.com/blogs/joshua_drake/2008/09/west_conference_shaping_up_nicely/ David Fetter: PostgreSQL Weekly News - September 14 2008- September 15, 2008 PostgreSQL Weekly News - September 14 2008 CommitFest Update: thanks to more than half a dozen new reviewers volunteering, almost all patches have been assigned reviewers. This commitfest might actually finish in a week. Patches committed this week include, to_date format validaton, GUC setting source display, Boyer-Moore string searching, Command-line function definition retrieval, Code coverage of regression tests, New permission: Truncate, and Improvements in pg_bench, pg_dumpall,..http://people.planetpostgresql.org/dfetter/index.php?/archives/191-PostgreSQL-Weekly-News-... Leo Hsu and Regina Obe: OpenJump for PostGIS Spatial Ad-Hoc Queries- September 14, 2008 OpenJump is a Java Based, Cross-Platform open source GIS analysis and query tool. We've been using it a lot lately, and I would say out of all the open source tools (and even compared to many commercial tools) for geospatial analysis, it is one of the best out there. While it is fairly rich in functionality in terms of doing statistical analysis on ESRI shapefile as well as PostGIS and other formats and also has numerous geometry manipulation features and plugins in its tool belt, we like..http://www.postgresonline.com/journal/index.php?/archives/72-OpenJump-for-PostGIS-Spatial-... |