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:54:15Z
Lists: pgsql-general 
On 03/01/2018 11:28 AM, Melvin Davidson wrote:
[snip]
>
> *>Hmmm.  I just looked at the script, and it says:
>
> >$ pg_dumpall --schema-only > globals.sql
>
> >That's not good.
>
>
> *
> *No that's actually correct.
> pg_dumpall  can and will dump the globals
> *
> *pg_dump cannot*

I was invoking --schema-only and piping it to globals.sql.  That's deceptive.

-- 
Angular momentum makes the world go 'round.

Commits

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