Re: pg_upgrade

From: Tomasz Szypowski <tomasz(dot)szypowski(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: pg_upgrade
Date: 2019-03-18 22:05:54
Message-ID: CACmJi2JR4poEvU2Lvmjji07z6fyJiy4=2Xb0Lb_xK0aGcN2g3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

So what set it to false?
Suppose I have created cluster in 9.5. Template1 has set template flag. Now
I upgrade it to 11.2, so I created cluster on 11.2 by initdb,. Here
template1 has set template flag as well. Now I do perform pg_upgrade and
both template1 are template. Should I manually unset the flag? If yes how
would it be possible to perform pg_upgrade without unsetting the flag -
there is no such point in instruction

Regards
Thomas Szypowski

W dniu pon., 18.03.2019 o 22:58 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> napisał(a):

> Tomasz Szypowski <tomasz(dot)szypowski(at)gmail(dot)com> writes:
> > thanks for the response. After initdb tempate1 has datistemplate as true
>
> Right, initdb leaves it set that way, but I'm guessing that it's not
> like that in the database you're trying to pg_upgrade.
>
> regards, tom lane
>
--
pozdrawiam
Tomek

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2019-03-18 22:24:06 Re: BUG #15700: PG 10 vs. 11: Large increase in memory usage when selecting BYTEA data (maybe memory leak)
Previous Message Tom Lane 2019-03-18 22:03:40 Re: BUG #15700: PG 10 vs. 11: Large increase in memory usage when selecting BYTEA data (maybe memory leak)