Обсуждение: Re: If an extension library is loaded during pg_upgrade,can it tell?

Поиск
Список
Период
Сортировка

Re: If an extension library is loaded during pg_upgrade,can it tell?

От
Bruce Momjian
Дата:
On Mon, Apr  3, 2017 at 09:53:34PM -0400, Chapman Flack wrote:
> Hi,
> 
> Is there any distinctive state that could be checked by extension code
> to determine that it has been loaded incidentally during the operation
> of pg_upgrade rather than under normal conditions?
> 
> PL/Java ordinarily checks what version of its schema is around, but
> that may be premature while pg_upgrade is doing its thing and the schema
> might not be all there yet.

You can check the backend global variable IsBinaryUpgrade to check if
binary upgrade is being performed.  Does that help you?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



Re: If an extension library is loaded during pg_upgrade,can it tell?

От
Chapman Flack
Дата:
On 04/03/17 22:08, Bruce Momjian wrote:
> On Mon, Apr  3, 2017 at 09:53:34PM -0400, Chapman Flack wrote:
>> Hi,
>>
>> Is there any distinctive state that could be checked by extension code
>> to determine that it has been loaded incidentally during the operation
>> of pg_upgrade rather than under normal conditions?
>> ... 
> You can check the backend global variable IsBinaryUpgrade to check if
> binary upgrade is being performed.  Does that help you?

That sounds like exactly what I'd hoped for. Thanks!

-Chap