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:59:48
Message-ID: 3a9f4ef2-f373-bd34-f0dc-58abc7301984@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2018-03-01 18:08:20 Re: How to avoid trailing zero (after decimal point) for numeric type column
Previous Message Ron Johnson 2018-03-01 17:54:15 Re: Version upgrade: is restoring the postgres database needed?