Hello!
I update the databases to version 9.1.
Today, faced with a new challenge.
The database itself is not very big 60G, but has ~ 164,000 tables in 1260 schemes.
I tried and pg_upgrade and pg_dumpall and pg_dump.
But they all work very, very long time.
For so long that I do not have patience.
And pg_dump worked for almost a day, gave "out off memory"
(but this experience made a colleague, so vouch for the accuracy can not).
I tried to just dump schemes-only, but also the procedure lasted more than 17 hours and not over .... I ran out of
patience.
If I am not mistaken, all of these programs work on approximately the same algorithm.
At the beginning of block all the tables in all schemas, indexes, and so then....
So I do not see a way to significantly speed up the process.
The only thing that came up while doing a dump on each schema.
But will it be the right approach?
Maybe tell me what to do?
