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

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Version upgrade: is restoring the postgres database needed?
Date: 2018-03-01 17:54:15
Message-ID: 8712f788-d4c0-b425-c219-6e05b8c92866@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2018-03-01 17:59:48 Re: Version upgrade: is restoring the postgres database needed?
Previous Message Daevor The Devoted 2018-03-01 17:47:53 Re: Enforce primary key on every table during dev?