How to setup SSL connections and authentication?
I had to setup it relatively recently, and hit some roadblocks, so figured I’ll write about my experiences – for myself in the future, or for anyone else that might want to set it up.
I had to setup it relatively recently, and hit some roadblocks, so figured I’ll write about my experiences – for myself in the future, or for anyone else that might want to set it up.
I had to deal with this question, or some version of it, quite a few times. So, decided to write a summary on what one could (or should) do, after data is in database, and application is running. Namely – setup some kind of replication and backups. What to use, how, and why? This is … Continue reading “I have PostgreSQL, loaded some data, and have app using it. Now what?”
I am enthusiast of Bitcoins. This can be seen in my blog (above each post, in post view page, there is help plea), or on explain.depesz.com – my most known creation. Aside from these, I try to talk with various people about it, explain what I can (and learn what I don’t know), and generally … Continue reading “I did my part :)”
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 to add it to “postgresql” tag. So, due to some work I had to do, … Continue reading “A tale of automating tests of Pg with Bash”
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 problem – to get consistent dump you need to stop all concurrent access … Continue reading “Parallel dumping of databases”
So, you just installed your PostgreSQL, and you have no idea how to use it – there is no icon in the menu of your OS, so how can you use it? Well, with the dreadful command line. Of course – some people will never get used to textual programs. They need a GUI. That’s … Continue reading “Command line tools? In XXI century? No way! Yes way!”
Similar question has been asked many times on mailing lists and on IRC. Sometimes it’s not mail sending, but file/directory creation, or something else that generally requires some interaction with “world outside of database”. Can it be done? Sure. How, then?
(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 various places – PostgreSQL is using too much memory, why is that, and how … Continue reading “How much RAM is PostgreSQL using?”
First of all – just today I committed patch for Pg::Explain – which is the workhorse behind explain.depesz.com. This patch fixes calculation of exclusive time for explain nodes, and the best thing about it is – I didn’t write it. It’s full patch provided by someone else – Filip Rembiałkowski – my former colleague, friend, … Continue reading “Two years of explain.depesz.com”