Up until fairly recently, upgrades for PostgreSQL databases have been looked upon with a sort of dread. Especially for those of us maintaining very large databases. The thought pattern usually went that it was easier to deal with running an older system than trying to schedule extended periods of downtime to allow for the full dump and restore of the entire database. Or trying to use third party tools like Bucardo to replicate the database to another system with a newer version to keep things up and running as long as possible for the upgrade.
So most DBAs would tell you the best way to handle Daylight Saving Time in the database is to run your server in UTC time and just avoid the complications all together. That is definitely ideal! But not everyone follows that advice and if a system has been running in a timezone with DST for a long time, changing to UTC can be a huge hassle.
As promised in my previous post on the PostgreSQL Oracle FDW, I've done some performance testing verses our old method of using DBI-Link to replicate tables from an Oracle 8i instance to PG 9.1.2. I've got good news on several fronts!
First being that there is a definite improvement on the replication speed. Here's some stats on our old process that copied an entire table of about 1.5million rows
I've finally gotten Git support added into pg_extractor. This works pretty much the same as the SVN option did already. One important difference is that there are two options for committing
So one of our clients is still stuck running an old Oracle 8i database. Please, no comments on how there's no more support and they should have moved off this long ago. We know. They know. Moving on...
No, I'm not a Minecraft player. I got into it for a little while during the Alpha, paid for the full client to support Mojang just because I thought the idea was fantastic and loved seeing what other people do. But I just couldn't stick with it. I do, however, have several friends that are fanatical fans of the game and some cycles on the home server to spare. So I offered to host a server for them so they could all play together instead of their own single player clients at home.
For my debut blog post, I'll be explaining a tool, pg_extractor, that I began working on at my current job. I'd like to first give a big thank you to depesz and the DBA team at OmniTI for their help in making this tool.
{...}
Working on this tool has shown many shortcomings with the built in pg_dump/restore. One of my hopes with this project is to show what improvements can be made and possibly built in sometime in the future.
{...}
Probably best to move on to some examples instead of continuing this wall of text...
Recent comments