PostgreSQL
Back from PgCon2010
This year’s edition has been the best pgcon ever for me. Granted, it’s only my third time, but still :) As Josh said the “Hall Track” in …
category
PostgreSQL
133 posts
PostgreSQL
Finding orphaned sequences
This time we’re having a database where sequences were used, but not systematically as a default value of a given column. It’s mainly an historic bad idea, …
PostgreSQL
Getting out of SQL_ASCII, part 2
So, if you followed the previous blog entry, now you have a new database containing all the static tables encoded in UTF-8 rather than SQL_ASCII. Because if it was not …
PostgreSQL
Getting out of SQL_ASCII, part 1
It happens that you have to manage databases designed by your predecessor, and it even happens that the team used to not have a DBA. Those histerical raisins can lead to …
PostgreSQL
Resetting sequences. All of them, please!
So, after restoring a production dump with intermediate filtering, none of our sequences were set to the right value. I could have tried to review the process of …
PostgreSQL
PgCon 2009
I can’t really compare PgCon 2009 with previous years versions, last time I enjoyed the event it was in 2006, in Toronto. But still I found the experience to be a …
PostgreSQL
Skytools 3.0 reaches alpha1
It’s time for Skytools news again! First, we did improve documentation of current stable branch with hosting high level presentations and tutorials on the …
PostgreSQL
Importing XML content from file
The problem was raised this week on IRC and this time again I felt it would be a good occasion for a blog entry: how to load an XML file content into a single field? The …
PostgreSQL
Skytools ticker daemon and londiste
One of the difficulties in getting to understand and configure londiste reside in the relation between the ticker and the replication. This question was raised once more …
PostgreSQL
Comparing Londiste and Slony
In the page about Skytools I’ve encouraged people to ask some more questions in order for me to be able to try and answer them. That just happened, as usual on the …
PostgreSQL
Controling HOT usage in 8.3
As it happens, I’ve got some environments where I want to make sure HOT ( aka Heap Only Tuples) is in use. Because we’re doing so much updates a second that I …
PostgreSQL
Londiste Trick
So, you’re using londiste and the ticker has not been running all night long, due to some restart glitch in your procedures, and the on call admin didn’t …