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

2017-04-03 Thread 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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


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

2017-04-03 Thread 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  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 +


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


[HACKERS] If an extension library is loaded during pg_upgrade, can it tell?

2017-04-03 Thread Chapman Flack
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.

-Chap


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers