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.
