Archiwizowane February, 2015

One of my clients is upgrading some servers. The procedure we have took some time to get to current state, and we found some potential problems, so decided to write more about it.

On 23rd of February, Heikki Linnakangas committed patch: Replace checkpoint_segments with min_wal_size and max_wal_size. Instead of having a single knob (checkpoint_segments) that both triggers checkpoints, and determines how many checkpoints to recycle, they are now separate concerns. There is still an internal variable called CheckpointSegments, ...

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

February 4th, 2015 by depesz | Tags: , , , | 5 comments »

I was working today on some updates to client database. While doing it, I figured it would be simpler if I saw all "codenames" and ids of rows from dictionary table - not so big. But it was bigger than ...

February 3rd, 2015 by depesz | Tags: , , , , , , | No comments »

Just thought I'll share a "fun" story. Friend reported weird bug - OmniPITR reported that xlogs are sent to archive, but they actually weren't. After some checking we found out that he was giving custom rsync-path (--rsync-path - path to rsync ...