I'm trying to get PostgreSQL 7.4 setup to use PITR mode (as described here). It appears that the "archive_mode" option isn't recognised. Can anyone shed light on when this first appeared in PostgreSQL? I don't want to upgrade to a newer version unless I absolutely have to.
(For what it's worth, I was planning on using this to replicate PostgreSQL database updates across the wire to a warm standby database.)
The Solaris machine we do most of our development on has an annoying habit of timing out SSH sessions. Doesn't matter whether the client is my Ubuntu desktop, my Solaris desktop or my Windows desktop (putty); the common factor is the big Solaris machine.
Is there anything I can do to stop this happening? It's annoying when you take a lunch break and the terminal sessions you've got open and delicately configured are all frozen so you need to kill them all and reestablish all of your context.