Hello friends, I will need to migrate 500+ tables from one server (8.3) to another (9.3). I cannot dump and load the entire database due to storage limitations (because the source is > 20 TB, and the target is about 1.5 TB).
I was thinking about using pg_dump with customized -t flag, then use restore. The table names will be in the list, or I could dump their names in a table. What would be your suggestions on how to do it more efficiently?
Thank you for your ideas, this is great to have you around, guys!