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

On 03/01/2018 11:46 AM, Adrian Klaver wrote:
[snip]
>> Hmmm.  I just looked at the script, and it says:
>>
>> $ pg_dumpall --schema-only > globals.sql
>>
>> That's not good.
>
> Well it would dump the globals, but also the schema definitions for all 
> the objects in the cluster. Though at this point we are only half way 
> through the process. What is you restore procedure?

$ psql < globals.sql
$ pg_restore --clean --create --if-exists --exit-on-error --jobs=2 
${SRC}/${DB}.pgdump


-- 
Angular momentum makes the world go 'round.