Re: Version upgrade: is restoring the postgres database needed?

[Melvin Davidson <melvin6925@xxxxxxxxx>]

On Thu, Mar 1, 2018 at 5:24 AM, Ron Johnson <ron.l.johnson@xxxxxxx> wrote:

Or do we just apply the globals.sql created by "pg_dumpall --globals-only"?

(We're upgrading by restoring all databases on a new server, that, naturally, has it's own new postgres, template0 and template1 databases.)


Thanks

--
Angular momentum makes the world go 'round.

>is restoring the postgres database needed?

That would depend on how you did the dump. If you did a_complete pg_dumpall (did not use -g or any other limiting flags), then all roles and databases are contained

in the output file created. NOTE: restoring from the dumped file will require rebuilding all indexes, because indexes are not dumped.

--

Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!