senor <frio_cervesa@xxxxxxxxxxx> writes: > I'm afraid it is 9.2.4. That's pretty old :-( > I noticed on 2 installations with similar table numbers (~200,000), > schema and hardware that one was done in hours and the other didn't > finish over the weekend. Keeping tabs on pg_stat_activity indicated > pg_dump was still processing and nothing else running. Hmm ... but without knowing what's different between the two, that's not much help. > Would you say that updating to 9.2.24 would be beneficial before > upgrading to 9.6? An update is pretty quick and could be worth the time > if there aren't additional requirements prior to starting the upgrade. That was my reasoning. It might not help, but it's a simple thing to do and it might help. regards, tom lane
