Blog Archive 2021 Where To Get Postgres Help Online? Jun 09 2021 2020 Do This 10 Times And Stop… In Postgres Nov 14 2020 phpPgAdmin 7.13.0 released Nov 06 2020 New Life Experiment: One Car Family Feb 10 2020 The Golden Globes meets Safety Science Jan 07 2020 2019 phpPgAdmin 7.12.1 released Dec 10 2019 5 Quick Thoughts on the State of Postgres Survey Dec 07 2019 Introducing phpPgAdmin 7.12.0 Sep 27 2019 Charm City Postgres Aug 15 2019 The Lost Art of plpgsql Jun 06 2019 2018 The Ghost of phpPgAdmin Nov 12 2018 Now With More SSL Oct 05 2018 2017 Return Of Pagila Sep 28 2017 2014 Postgres 9.4 - A First Look May 22 2014 Natural Consequence Mar 03 2014 2013 Less Alarming Alerts Nov 24 2013 New GPG Key Nov 20 2013 Past, Present, and Pachyderm Nov 08 2013 MariaDB and the quest for Oracle Freedom Oct 25 2013 And Away We Go Oct 16 2013 What’s to see in Postgres 9.3 slide deck May 28 2013 What Defines A Guru? May 10 2013 new blog rising May 05 2013 New Postgres Backup and Restore Book Apr 20 2013 phpPgAdmin 5.1 released! Apr 17 2013 2012 Join The 5% Nov 04 2012 Shoot The Automated Failure In The Head Sep 17 2012 Contents of an Office Aug 29 2012 What Todd Akin Can Teach Us About DevOps Aug 27 2012 Root Cause of Success Jun 21 2012 Slides for Big Bad Upgraded Postgres Talk May 28 2012 I built a node site Feb 21 2012 Intrest free (technical) debt is risky Feb 06 2012 2011 Monitoring for “E-Tailers” Dec 14 2011 Cloudy With A Chance Of Scale Nov 23 2011 Checkpoints, Buffers, and Graphs Nov 16 2011 Understanding Postgres Durability Options Nov 08 2011 PGDay Denver 2011 Wrap-Up Oct 24 2011 Reminder: BWPUG Meeting Tomorrow, Sept 20th Sep 19 2011 The Opportunity of Crises Sep 13 2011 On Clouds And Data Aug 26 2011 A funny thing happened on the way to September Aug 17 2011 Paying Attention Pays Off Aug 15 2011 Maybe they just like it better? Aug 08 2011 Actually, I am not going to PGWest (and you might not want to either) Jul 05 2011 BWPUG Meeting Tomorrow (May 11th) at 6:30PM May 10 2011 Reminder BWPUG Meeting Tonight (April 13th) at 6:30PM Apr 13 2011 PGEast Slides Available On Slideshare Apr 03 2011 Upserting via Writeable CTE Mar 16 2011 Monitoring Read vs. Write Activity In Postgres Mar 01 2011 Why the F&#% Doesn’t Postgres Have Hints?!?! Feb 07 2011 A present from my filesystem Jan 18 2011 2010 BWPUG Meeting November 10th Nov 08 2010 Scalability, I has it Oct 26 2010 BWPUG September Meeting 2010-09-08: PostgreSQL Security and SE-Postgres Sep 07 2010 Now What? (wrt OpenSolaris and your database) Aug 16 2010 Database Scalability Patterns - OSCon 2010 Jul 23 2010 I hardly gnu, you? Jul 17 2010 BWPUG July Meeting 2010-07-14: PostgreSQL Performance Farm Jul 13 2010 PGCon 2010 slides are up Jun 07 2010 BWPUG June Meeting 2010-06-09: PostgreSQL on FreeBSD Jun 03 2010 phpPgAdmin 4.2.3 Released Apr 13 2010 watch for momentary monitoring Apr 10 2010 Postgres returning for Google Summer of Code 2010 Mar 19 2010 Postgres at MySQL Conference? Mar 14 2010 Actually, the Relational Model doesn’t scale Mar 08 2010 OmniTI is heading to PGEast 2010 Mar 02 2010 BWPUG March 10th, Falls Church take two. Feb 22 2010 2009 MySQL, open source’s version of “Too Big To Fail” ? Dec 24 2009 LISA 2009 Wrap-up Nov 09 2009 Amazon Offers New RDS (aka MySQL) Service and New Database Related Virtual Machines Oct 27 2009 Denish looks at RubyRep Aug 20 2009 First Issue of Open Source Database Magazine Is Out Jul 22 2009 Three Cheers for the search_path!!! Jul 09 2009 Got Team? Jun 16 2009 The Asynchronous Services Analogy Jun 11 2009 BWPUG Meeting scheduled for June 17th Jun 09 2009 The First Rule of Postgres Club Jun 05 2009 Guide to Postgres 8.4 video now available Jun 03 2009 Reflections on PGCon 2009 May 25 2009 IUCN Wildlife group needs development help May 09 2009 Taking a stab at “50” things to know before migrating MySQL to Oracle Apr 30 2009 Why should Oracle kill MySQL, when they will do it themselves? Apr 23 2009 Up next, Percona and MySQL conferences Apr 19 2009 Intro to 8.4 Slides Now Available Apr 03 2009 PostgreSQL East Conference 2009 Mar 26 2009 IBM and SUN, corporate Open Source shows its ugly side again Mar 19 2009 re: axonflux on building and scaling a startup Feb 25 2009 Community One 2009, now with less of that pesky community Feb 18 2009 Hat tip to MindGrub Feb 10 2009 So, who owns Maria now? Feb 09 2009 Controlled failover for PITR Warm Standby Feb 05 2009 getddl 0.5.1 released Jan 30 2009 Feb 2009 BWPUG Meeting: Stephen Frost, Column Level Permissions Jan 27 2009 Last Call for PGCon papers. Jan 19 2009 Blog searching should be fixed now Jan 07 2009 select * from things limit 7 Jan 04 2009 Most blog postings now recovered Jan 02 2009 2008 hail the conquering (fantasy) hero Dec 26 2008 MacBook as a desktop replacement, 4 days out Dec 16 2008 Log Buffer #127: a Carnival of the Vanities for DBAs Dec 12 2008 pgsoltools updates Dec 09 2008 re: dbms_identifiers_and_case_sensitivity Dec 05 2008 php|tek vs. PGCon, again Dec 04 2008 MySQL 5.1 is out, now what? Dec 01 2008 Beijing Perl Workshop 2008 Summary Nov 08 2008 Column re-ording status Nov 01 2008 Final week for Pg.US elections Oct 25 2008 And we’re back… Oct 18 2008 The future of tech writing is comical Oct 09 2008 Bacula, Sqlite, Postgres… when good tools go horribly horribly wrong Sep 17 2008 PostgreSQL Partitioning slides now on Slideshare Sep 14 2008 playing with chrome on linux Sep 05 2008 ZFS, databases, and common threads Sep 02 2008 A webcomic for DBA’s Aug 08 2008 OSCon Quick Notes Review Jul 27 2008 Certified Schizophrenic Jul 23 2008 My OSCon 2008 Slides Jul 22 2008 Git-r-done Jul 17 2008 Index pruning techniques Jul 04 2008 reconnoiter goes… alpha Jun 29 2008 Could OSDB replace the SQL Standard Committe? Jun 26 2008 Dealing with out of disk issues for the abusive dba Jun 22 2008 implementing no transaction mode in postgresql Jun 11 2008 recaptcha enabled for planetpostgres Jun 09 2008 ossdb-snapshot, lvm database snapshot tool Jun 03 2008 PGCon 2008 Wrap-up May 29 2008 DB Anti-Patterns slides on slideshare May 22 2008 getddl now available Apr 24 2008 Plane tickets booked for PGCon Apr 22 2008 Where there’s smoke, there’s Kickfire Apr 15 2008 Disaster recovery at 1000 GB’s Apr 09 2008 Compiere now running on PostgreSQL Plus Advanced Server (aka EnterpriseDB) Apr 09 2008 Speaking at OSCon 2008 Apr 05 2008 The enemy of my enemy is my friend Mar 25 2008 5 Good Minutes Mar 18 2008 PostgreSQL Blog’s 8.3 Feature Round-Up Feb 08 2008 $27 Million down, $973 Million to go Jan 22 2008 Getting to Ottawa by way of Dopplr Jan 17 2008 Sun<<mysql Jan 17 2008 pagila-0.10.0 Released Jan 06 2008 2007 phpPgAdmin 4.2-Beta-1 Released Dec 17 2007 tracking stable release development Dec 02 2007 tracking plperl shared variables Nov 20 2007 Solving the big science checklist Nov 10 2007 The Big Guys Oct 16 2007 PostgreSQL 8.3 beta has dropped Oct 08 2007 tablespace management variables Oct 02 2007 Ohio LinuxFest Wrap-up Oct 01 2007 PostgreSQL 8.3 Features: Enum Datatype Sep 14 2007 Rob @ Ohio Linuxfest 2007 Sep 10 2007 Out parameters in plperl Sep 06 2007 PostgreSQL is Not a Democracy Aug 30 2007 Group By Quarter Hour Aug 29 2007 Everyone else is doing it, why can’t we? Aug 05 2007 oscon 2007 thursday wrapup Jul 27 2007 oscon 2007 wednesday wrap-up Jul 26 2007 pdxpgday (oscon day 0) Jul 23 2007 typically I recommend you disable SELinux… Jul 18 2007 OSCon 2007 Jul 12 2007 phpPgAdmin 4.1.3-rc-1 now available Jun 27 2007 Partition Permissions Jun 20 2007 phpPgAdmin 4.1.2 released Jun 02 2007 pgcon 2007 talks up May 24 2007 pgcon 2007 day 3 mid day report May 23 2007 pgcon 2007 day 2 mid day report May 22 2007 3 Weeks till PGCon 2007 May 03 2007 Superstition suspicion Apr 13 2007 Monthly log rotations with PostgreSQL’s built in logging Apr 03 2007 pagila-0.9.0 Released Mar 31 2007 8.2.3 stats bug and Solaris Mar 27 2007 phpPgAdmin 4.1.1 Released Mar 24 2007 The pain that is tsearch2 8.1 -> 8.2 upgrading Mar 05 2007 The web IN your database Feb 17 2007 Web team updates Feb 08 2007 getting killed by dbx Jan 31 2007 killing invincible processes with dbx Jan 30 2007 phpPgAdmin 4.1 Released Jan 21 2007 planetpostgresql blogger feed urls fixed Jan 13 2007 Log Buffer #27, A Carnival of the Vanities for DBAs Jan 12 2007 Go Gators! Jan 09 2007 2006 Year In Review Jan 05 2007 2006 sizing up your partitions Dec 29 2006 sql servers charindex function in postgresql Dec 26 2006 PostgreSQL full text search testing PART II Dec 22 2006 PostgreSQL full text search testing Dec 18 2006 PostgreSQL bios page updated Dec 14 2006 PostgreSQL 8.2 RC1 Released, are you testing? Nov 28 2006 Why usability matters Nov 21 2006 Pagila ok on 8.2 Nov 13 2006 Practical example of using Notify Nov 06 2006 Theo shows off dtrace Nov 01 2006 PostgreSQL Minor Versions Released Oct 17 2006 Heading to Google SoC mentor Summit Today Oct 13 2006 Checking status of EXECUTE statements in plpgsql Sep 28 2006 Laying low for awhile Sep 23 2006 Slides from my pl/php talk Sep 14 2006 Hack to go Sep 11 2006 Re-inventing Greg’s method to prevent re-inventing Sep 05 2006 Google SoC coming to a close Aug 29 2006 Fix for s9y 1.0 / PostgreSQL users re: last_modified time Aug 29 2006 PostgreSQL Website update Aug 24 2006 Fake fixing tsearch’s "could not find config by locale" Aug 22 2006 What to do with 20 million users Aug 19 2006 Etsy.com added to PostgreSQL users page Aug 18 2006 Tinkering with s9y Aug 17 2006 Grant privileges to all tables in a database Aug 15 2006 Ebay going anti-linux? Aug 14 2006 What to do with 20 million dollars Aug 10 2006 PostgreSQL, the worlds most *popular* open source database Aug 10 2006 So what have I been up to? Aug 08 2006 Pervasive, EnterpriseDB, and making money on Open Source Aug 02 2006 Feature Freeze Aug 01 2006 OSCon2k6 Day 5 midday report Jul 30 2006 OSCon 2k6 Day 4 and 5 : lots of talks, the bof, poker, and the morning after Jul 28 2006 OSCON2k6 Day 4 My Talk Jul 27 2006 OSCON2k6 Day 3 Wrap Up - hanging out, free as in beer, and command prompt gives back Jul 27 2006 OSCON2k6 Day 3 Morning Wrap Up Jul 27 2006 OSCON Day 2 Wrapup from the morning after Jul 26 2006 OSCon2k6 Day 2 Report. Jul 26 2006 OSCon2k6 Day 1 - Business, PG Gang, and VIM Jul 25 2006 OSCon 2k6 Day 0.5 / Day 1 Jul 24 2006 OSCon2k6 Day 0 Jul 24 2006 OSCON 2006 Session Picks Jul 21 2006 Apress Open Source Blog Jul 21 2006 re: Security? Show Me The Money. Jul 20 2006 PostgreSQL BOF @ OSCON Jul 19 2006 Windows tutorial using PostgreSQL / Pagilla Jul 18 2006 RATIO_TO_REPORT in PostgreSQL Jul 14 2006 Upgraded to Ubuntu LTS Jul 13 2006 It seemed almost fitting in a way Jul 11 2006 PostgreSQL Summit Day 2 Jul 10 2006 PostgreSQL Summit Day 1 Jul 08 2006 zZzZz Jul 08 2006 Layover Jul 07 2006 Measuring database restore times Jul 06 2006 PostgreSQL Summit Schuedule Conflicts Jun 28 2006 PostgreSQL Aimbot Now Available Jun 27 2006 Building Rails to Legacy Applications :: Take Control of Active Record Jun 23 2006 Make plans for PHP/DB|Works Jun 22 2006 5 star rating, sample chapter, and everyone wants mysql Jun 18 2006 OnLamp Article Published Jun 15 2006 delayed returns with plperl Jun 14 2006 Building Rails to Legacy Applications :: Masking the Database Jun 08 2006 Toronto Flight Plans Jun 07 2006 Canes go up 1-0 against Oilers Jun 06 2006 How I wasted 10 minutes this morning Jun 02 2006 Cool web advertisment Jun 01 2006 GUI Tools Page Reborn Jun 01 2006 Pagila sample database released May 30 2006 Convert CSV text fields into text[] arrays May 28 2006 Greenplum / Frontier Airlines Press Coverage May 27 2006 PostgreSQL/Google Summer of Code May 26 2006 Step 12: Create a slon.conf file May 26 2006 PostgreSQL SourceForge Page Updated May 24 2006 Alpha testing Slony on win32 Crib Notes May 24 2006 Choosing your customer’s database market May 23 2006 PostgreSQL 8.1.4, 8.0.8, 7.4.13 and 7.3.15 security fixes released! May 23 2006 5 days left to sign up for free PHP & PostgreSQL web hosting May 22 2006 Google SoC and PostgreSQL May 21 2006 "Pagila" hits CVS May 19 2006 Tom Copland on Ruby On Rails Podcast May 19 2006 More news from the front; Gilmore pushes PostgreSQL on Windows May 16 2006 Trending PostgreSQL May 13 2006 Techdocs Updates May 11 2006 Zend Framework goes BSD Apr 27 2006 Planet Argon on the Ruby on Rails Poscast Apr 27 2006 Saving your bacon with a PostgreSQL Restore File Apr 25 2006 PHP/PG e-book now available Apr 23 2006 Convention over configuration in the db world Apr 21 2006 Debian PostgreSQL Versioning Apr 20 2006 Good old times Apr 19 2006 Category Updates Apr 19 2006 PostgreSQL 8.1 on Ubuntu Apr 18 2006 Sakila swings BSD Apr 14 2006 Wikipgedia-0.0.4 Released (More Security Fixes) Apr 13 2006 This is kind of depressing Apr 12 2006 First book review in the wild Apr 09 2006 That Oracle vs. PostgreSQL Article Apr 08 2006 PostgreSQL Job Merry-Go-Round Apr 05 2006 The future of Data Warehousing is all PostgreSQL Mar 30 2006 Is lastval() evil? Mar 30 2006 EnterpiseDB on Novell Open Audio Podcast Mar 29 2006 Cymer is hiring Mar 29 2006 SearchOpenSource.com Interview Part II Mar 28 2006 5 days left for PostgreSQL Anniversary Proposal Deadline Mar 27 2006 Jason and I interviewed by SearchOpenSource.com Mar 21 2006 EnterpriseDB signs deal with Sony Mar 20 2006 Jason starts a flame war :-) Mar 15 2006 What is podcasting? Mar 14 2006 8.1 update from example Mar 08 2006 Open Source "Business" Models Mar 06 2006 ERROR: could not find relation 596922701 among query result relations Mar 02 2006 PHP & PostgreSQL Book Released Today Feb 28 2006 Updates on the PGGraphics and WildDB projects Feb 26 2006 One reason my company has a hard time finding great programmers… Feb 24 2006 Sean Chittenden on RubyOnRails Podcast Feb 23 2006 OSDB market soap opera update (mysql and firebird) Feb 20 2006 out parameter sql & plpgsql examples Feb 16 2006 Oracle really did buy Sleepycat Feb 15 2006 Techdocs Update Feb 14 2006 PostgreSQL Naming Names Feb 10 2006 Technical Prejudices Feb 10 2006 Bruce Momjian on BSDTalk Podcast Feb 08 2006 ajaxMyTop for PostgreSQL (link fixed) Feb 04 2006 What the free non-free databases signal Feb 01 2006 Letting non-superusers control logging Jan 31 2006 techdocs update Jan 26 2006 Viewing your current session’s settings Jan 25 2006 More reasons to switch to postgresql Jan 20 2006 Installing Additional Plugins for S9Y on safe mode Jan 19 2006 Mea culpa on those surrogate keys Jan 18 2006 Struck out at php|tek Jan 11 2006 Getting faster database restores on postgresql 8.1 Jan 11 2006 mod_auth_pgsql vulnerability getting too much hype Jan 10 2006 zillablog design updates Jan 04 2006 4 Days On Rails (On PG of Course!) Jan 03 2006 2005 Fix for Serendiptity (s9y) quicksearch Dec 30 2005 Or you could use a domain Dec 28 2005 Self publishing for PostgreSQL? Dec 27 2005 2005 Web Usability "duh-wards" Dec 27 2005 Happy Festivus Dec 24 2005 Upgrading to wikipgedia-0.3 Dec 21 2005 Working the OSS conferance track Dec 19 2005 John Spencer has passed away Dec 17 2005 Shout out to ChrisKL Dec 16 2005 Time for a reboot? Dec 14 2005 Wikipgedia-0.0.3 Released (Security Fixes) Dec 12 2005 OSS DB rodeo roundup Dec 09 2005 Wikipgedia Project Update Dec 08 2005 Miata is in the shop Dec 06 2005 IUCN Wildlife Monitoring Database Project Dec 05 2005 PostgreSQL Website Updates Dec 03 2005 Thoughts on FeedLounge Switching to PostgreSQL Dec 02 2005 7.2 is no longer supported (really) Dec 01 2005 Back from the Hinterlands Nov 28 2005 Sun joins the PostgreSQL Community Nov 18 2005 Dylan 2.0 ? Nov 16 2005 Robert blows his first bubble Nov 16 2005 wikipgedia 0.0.2 released Nov 14 2005 Grab your torches and Pitchforks! Nov 09 2005 PostgreSQL fails a Red Hat user? Nov 07 2005 Winds of change Nov 02 2005 PostgreSQL behind the next internet buzz product Oct 31 2005 McDonalds hipper than Starbucks? Oct 29 2005 Speechless is back!! Oct 28 2005 The secret php-pg connection Oct 24 2005 Trio! Oct 21 2005 wikipgedia-0.0.1 tarball available Oct 14 2005 Congratulations to Brian Hendrickson Oct 11 2005 Mediawiki on PostgreSQL? We’re pretty much there. Oct 08 2005 Time to update the wiktionary Oct 06 2005 Is Sun getting ready to join the PostgreSQL community? Oct 05 2005 Oracle is catching up with PostgreSQL Sep 30 2005 RE: Ellison pans open source databases Sep 22 2005 Testing and Administration Sep 20 2005 Pitfall: The Lost Expedition Sep 14 2005 Cheat Sheet for PostgreSQL Sep 07 2005 Still growing… (thump thump thump) Sep 03 2005 Techdocs Update Aug 31 2005 HelpSpot Gets PostgreSQL Support Aug 29 2005 Random quotes for PostgreSQL Website Aug 22 2005 PhpPgAdmin 3.5.5 Released Aug 20 2005 Drupal needs a PG maintainer, plus a rant. Aug 18 2005 Joel On Software Aug 17 2005 Maptastic Aug 15 2005 Annie are you OK? Aug 13 2005 Muelle Baby! Aug 08 2005 OSCon.2k5.4.Back-Home Aug 06 2005 OSCon.2k5.5.Mid-Day-Report Aug 05 2005 OSCon.2k5.4.Recap Aug 05 2005 OSCon.2k5.3.OR-Mapping Aug 03 2005 OSCon.2k5.3.Afternoon Aug 03 2005 OSCON.2k5.3.Addendum Aug 03 2005 OSCON.2k5.2.PM - OSCON.2k5.3.AM Aug 03 2005 OSCon2k5.2.AM Aug 02 2005 OSCon2k5.2.Lunch Aug 02 2005 OSCon 2005 Day 1 Bedtime Aug 02 2005 OSCon 2005 Day 1 Morning Aug 01 2005 OSCon Day 1 Evening (or Ruby on "Rails") Aug 01 2005 OSCon 2005 Day 0 Jul 31 2005 Intro to 8.1 Developer Series Jul 28 2005 PostgreSQL Weekly News Addendum Jul 25 2005 Damn thats some good lookin code you got there Jul 19 2005 By the way, the Philidelphia airport sucks Jul 18 2005 Open Source Database RoundUp Jul 10 2005 London bombings Jul 07 2005 Europe says no to software patents law Jul 06 2005 OSCon Rough Draft (Now PDF Approved) Jun 30 2005 OSCon Rough Draft Jun 29 2005 A PHP Podcast Jun 28 2005 Posting comments on Robby’s blog is nifty Jun 27 2005 8.1 Pending Items Jun 22 2005 Fishing the “Deep Web” for PostgreSQL Jun 20 2005 Just button it! Jun 15 2005 Igniteration Jun 03 2005 PG8+Solaris10+JDBC May 27 2005 Can you pass me a fork? May 23 2005 elesphere May 16 2005 FYI 5-10/05 May 10 2005 One Good Port May 06 2005 Whoami? May 05 2005 And the winner is… May 05 2005 Triggers Baby Apr 29 2005 LAMP Project Round 3 Apr 28 2005 LAMP Project Round 2 Apr 27 2005 Email Up? Apr 26 2005 Cool project at work Apr 25 2005 Off the list Apr 22 2005 Weekend update 4-17/05 Apr 17 2005 Just code it already Apr 15 2005 Who cares how fast you can query, how fast can you insert? Apr 11 2005 Is this thing on ? Apr 11 2005