Update the documentation for pg upgrade

We already have the database.md doc so the pg_upgrade section belongs more there than in maintenance.

I've also added more warnings and notes to be as explicit as possible that upgrade can be involved if something goes wrong.