"Steve Oualline" <soualline@xxxxxxxxxxxxx> writes: > What's the longest time you'd expect between the execution of the=20 > postmaster command and being able to connec? Normal startup is a second or two on any modern hardware. If you have to recover from WAL, though, it could be very long. A rule of thumb is that it shouldn't take longer than your inter-checkpoint time (checkpoint_timeout) ... but that's only assuming that the most recent checkpoint attempt before the crash succeeded. We've seen cases where checkpoints were failing repeatedly (eg, because of out-of-space condition on the main data partition) but the system kept merrily spooling transactions into WAL. In a scenario like that, there could be a whole lot of WAL to replay :-( regards, tom lane
