Postgres Pro
Downloads
Home   >   mailing lists

Re: Version upgrade: is restoring the postgres database needed? - Mailing list pgsql-general

From Ron Johnson
Subject Re: Version upgrade: is restoring the postgres database needed?
Date
Msg-id 8712f788-d4c0-b425-c219-6e05b8c92866@cox.net
Whole thread Raw
In response to Version upgrade: is restoring the postgres database needed?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Daevor The Devoted
Date:
Subject: Re: Enforce primary key on every table during dev?
Next
From: Ron Johnson
Date:
Subject: Re: Version upgrade: is restoring the postgres database needed?