On Mon, Dec 06, 2004 at 08:48:04AM -0000, Julian Scarfe wrote:
b) Only a dump-restore major version upgrade (which we'll do next time we
can take the system out for long enough) will avoid the issue.
On 6 Dec 2004, at 16:18, Alvaro Herrera wrote:
"Long enough" could be a minutes or seconds issue if you use Slony-I, I've heard ... (Of course you'd still need to fix your apps, which may take somewhat longer than that.)
A good point Alvaro, but I don't think Slony-I is compatible with 7.2, which is the version I'm starting from. For upgrades from 7.3 onwards, it's certainly a route worth considering.
Julian
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend