Horton

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

Ron Johnson <ron.l.johnson@cox.net>

View thread View on postgr.es
From: Ron Johnson <ron.l.johnson@cox.net>
To: pgsql-general@lists.postgresql.org
Date: 2018-03-01T17:59:48Z
Lists: pgsql-general 
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.

Commits

  1. Move handling of database properties from pg_dumpall into pg_dump.