I usually write about PostgreSQL, but lately someone asked for help, and one of the problems was similar to sudo command from title. This was not the first time I saw it, so figured, I'll write a blogpost about it, just ...

Word of warning: this blogpost is about thing related to Bash (well, maybe other shells too, didn't really test), but since I found it while doing Pg work, and it might bite someone else doing Pg related work, I decided ...

Some time ago I wrote a piece on speeding up dump/restore process using custom solution that was parallelizing process. Later on I wrote some tools ("fast dump and restore") to do it in more general way. But all of them had a ...

Today, I released new version of OmniPITR - 0.5.0. This new version has one important new feature - which is so called "direct destination" for backups. What it means? What it does? How it helps? Let's see...

Some time ago Joshua Tolley described how to reduce bloat from tables without locking (well, some locks are there, but very short, and not really intrusive). Side note: Joshua: big thanks, great idea. Based on his idea and some our research, i ...

I'm quite often doing stuff on remote machines, and quite frequently I start some long-running job, when I remember that I didn't ran it via screen - so it will break, if my network connection will die. Is there any sane ...

March 12th, 2009 by depesz | Tags: , , , , , , | 6 comments »

I had this interesting case at work. We have imports of objects. Each object in import file has its "ID" (which can be any string). Same "ID" is in database. So the idea is pretty simple - we can/should check how ...

This post will probably be boring for you, but this is mostly just a reminder to myself, written in form of a blog post. So, I have a directory structure: /some/path/imported/DATE/TIME/file, where DATE is date of importing, in format YYYY-MM-DD, and ...

there is this situation: multiple people have to have access to single system account on unix/linux. you are one of them, but you really want to have your own environment. aliases, path, and so on. problem? others dont want your changes. is ...