Based on my understanding, the recommendation is to use pg_upgrade over ‘dump and restore’.
Is that right?
pg_dump + pg_restore still works very well, but the process is generally slower. But if you have a small database and the time it takes is not big, then you are fine to use this method if you want to.
If I want to use pg_upgrade, I need to provide the -bbindir (--old-bindir=bindir) and so my second question is what if I’ll provide 9.4 (the new PostgreSQL executable directory) also as the ‘old-bindir’, can it work that way? Always?
[I am trying to solve a problem that I might not have the old-bindir available on the machine and only the new-bindir will be available (as well as the old & new datadir of course J]
You need both binaries in the server for pg_upgrade, there is no way around it.
Regards,
--
Matheus de Oliveira Analista de Banco de Dados Dextra Sistemas - MPS.Br nível F! www.dextra.com.br/postgres