pgsnake.blogspot.com
Dave's Postgres Blog: March 2011
http://pgsnake.blogspot.com/2011_03_01_archive.html
Postgres related musings and ramblings. Thursday, 24 March 2011. Debunking the FUD: PostgreSQL for Microsoft Windows Payload Execution. If you follow Twitter for keywords like "postgres" or "postgresql", you may well have seen a number of tweets over the last day or so regarding a so-called "Payload Execution" exploit in PostgreSQL. This supposed attack was apparently first described in this paper. And has hit Twitter after code. To demonstrate the issue was added to Metasploit. SELECT do bad stuff();.
pgsnake.blogspot.com
Dave's Postgres Blog: October 2011
http://pgsnake.blogspot.com/2011_10_01_archive.html
Postgres related musings and ramblings. Tuesday, 11 October 2011. To upgrade or not to upgrade? That is the question. Generally this happens with one of two types of users. There are those that just don't bother to upgrade (who we can do little about), and those that don't upgrade because they are concerned that changes to PostgreSQL will break their application. This latter class of user is sometimes also restricted by what they can do by corporate policies in their workplace. This is the major. Version...
pgsnake.blogspot.com
Dave's Postgres Blog: August 2011
http://pgsnake.blogspot.com/2011_08_01_archive.html
Postgres related musings and ramblings. Monday, 1 August 2011. PostgreSQL 9.1, meet MySQL. So having spent the last few months with my head buried deep in a project. At work, I finally managed to get back to my previous. Hacking on SQL/MED at the weekend after the kids went away for a week (good $DEITY it's quiet here)! Create the required functions for the FDW. CREATE FUNCTION mysql fdw handler(). LANGUAGE C STRICT;. CREATE FUNCTION mysql fdw validator(text[], oid). LANGUAGE C STRICT;. CREATE USER MAPPI...
pgsnake.blogspot.com
Dave's Postgres Blog: September 2012
http://pgsnake.blogspot.com/2012_09_01_archive.html
Postgres related musings and ramblings. Friday, 28 September 2012. PostgreSQL Conference Europe 2012 - 3 weeks to go! For more information on the event, visit the conference website. This years conference will start with a day of training sessions (available at extra cost), places on which must be pre-booked when you register. Joe Celko - A day of SQL with Celko. How often does an opportunity to learn SQL from the master come along? Not to be missed if you're new to SQL or want to polish up your skills.
pgsnake.blogspot.com
Dave's Postgres Blog: PostgreSQL Conference Europe 2012 - 3 weeks to go!
http://pgsnake.blogspot.com/2012/09/postgresql-conference-europe-2012-3.html
Postgres related musings and ramblings. Friday, 28 September 2012. PostgreSQL Conference Europe 2012 - 3 weeks to go! For more information on the event, visit the conference website. This years conference will start with a day of training sessions (available at extra cost), places on which must be pre-booked when you register. Joe Celko - A day of SQL with Celko. How often does an opportunity to learn SQL from the master come along? Not to be missed if you're new to SQL or want to polish up your skills.
pgsnake.blogspot.com
Dave's Postgres Blog: December 2011
http://pgsnake.blogspot.com/2011_12_01_archive.html
Postgres related musings and ramblings. Wednesday, 21 December 2011. Updated PostgreSQL Download Infrastructure. Back at the tail end of November, the PostgreSQL sysadmin/web team successfully migrated. The PostgreSQL website to a new platform. One other change that went largely unnoticed however was in the downloads section of the website, specifically the FTP area. We can push out files to the download servers in minutes, rather than days. We can automatically (and invisibly) disable download servers i...
pgsnake.blogspot.com
Dave's Postgres Blog: StackBuilder Package Updates
http://pgsnake.blogspot.com/2011/10/stackbuilder-package-updates.html
Postgres related musings and ramblings. Wednesday, 5 October 2011. So, with the refresher course out of the way, todays blog post is prompted by the latest round of updates that I've been adding to the catalog - we've got 42 updates to the Open Source packages, as well as 18 new packages, including for the first time, pgBouncer, pgMemcache and Drupal 7. Apache/PHP 2.2.20-5.3.8: Linux32, Linux64, Mac, Win32. MediaWiki 1.17.0: Linux32, Linux64, Mac, Win32. PgJDBC 9.0-801: Linux32, Linux64, Mac, Win32.
pgsnake.blogspot.com
Dave's Postgres Blog: October 2010
http://pgsnake.blogspot.com/2010_10_01_archive.html
Postgres related musings and ramblings. Monday, 25 October 2010. PGDay Europe 2010 schedule announced. I'm pleased to be able to say that the schedule for this year's PGDay Europe conference. In Stuttgart, Germany on the 6th - 8th December 2010 is now available. We have a bumper crop of talks this year, with 13 sessions in German, 26 in English, 2 keynotes and a key signing party! As always, we reserve the right to adjust the schedule in the event of unforeseen circumstances. See you in Stuttgart! A spec...
pgsnake.blogspot.com
Dave's Postgres Blog: March 2012
http://pgsnake.blogspot.com/2012_03_01_archive.html
Postgres related musings and ramblings. Monday, 26 March 2012. PostgreSQL Developer Meeting 2012. For the last few years I've organised a by-invitation meeting of the most active developers in the PostgreSQL community the day before PGCon. S sessions start in Ottawa. This is undoubtedly the best time of the year to do this as the vast majority of PostgreSQL hackers attend this event - many only attend local events for the rest of the year. 1) We need to spend more time fine-tuning the agenda. Hacker and ...
selectoid.wordpress.com
May | 2009 | Selectoid's Weblog
https://selectoid.wordpress.com/2009/05
PGCon 2009 is over… read submitted material online. 2009-05-25 — selectoid. From 19th to 21st May 2009 the PGCon 2009. Took place in the University of Ottawa. Although I could not participate personally, I can attend virtually. From the website http:/ www.pgcon.org/2009/. Slides of presentations or material of workshops can be obtained. Man, I love the WWW! Here is a small excerpt of what I found very interesting at first sight:. Harada and Fetter: Introducing Windowing Functions. And… and…. First things...
SOCIAL ENGAGEMENT