senor <frio_cervesa@hotmail.com> 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