October 8th, 2015 by depesz | Tags: , , , , , | 3 comments »

In case you're not familiar - there is a thing called LVM - it's a layer between physical disks, and filesystems, and allow certain interesting things, like extending, migrating, snapshotting and others. At one of systems I've been dealing with, we ...

December 18th, 2013 by depesz | Tags: , , , , , , | No comments »

Right after releasing 1.3.0 I realized that I forgot about one thing. If you're using ext3 (and possibly other, not sure) file system, removal of large file can cause problems due to heavy IO traffic. We did hit this problem earlier at ...

Recently someone was looking for help with script from Pg wiki. I never really checked it, but when talking with the guy needing help, I looked at it. And didn't really like it.

September 17th, 2012 by depesz | Tags: , , , , , , | 1 comment »

For those of you that don't know - Tmux is program similar to screen, but written from scratch, with different functionality, approach, and capabilities. I would like to show one particular case where I found that Tmux does something that screen ...

(disclaimer: all the data and examples in here are on Linux - the same data can be probably obtained on other systems too, it's just that I work on Linux and don't know other systems well). This question pops occasionally in ...

December 13th, 2010 by depesz | Tags: , , , , , | 6 comments »

At home I have couple of machines, but one of them takes relatively long time to login to. It looks like this: =$ time ssh blob id -u 1000   real 0m0.401s user 0m0.010s sys 0m0.000s While 0.4s ...

I use quite a lot of vpns. On any given moment I have between 3 and 10 active vpn connections from the machine I'm working on. I generally tend to use OpenVPN, but I also do use vpnc (Cisco VPN client). One ...

As you perhaps know I'm fan of pgbouncer - connection pooling solution for PostgreSQL. It can do many really cool things, but has one slight issue. Since it can reuse connections - it has to provide a way to check if user ...

I have an unusual mail setup. My company mails are handled by gmail, and on my account there, I setup forwarding to my own mail account on my own server. Where I read the mails, and respond. So, when someone (let's say ...

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 ...