Extension compatibility between postgresql minor version

Maybe, maybe not.

Have you tried installing '=postgresql93-contrib-9.3.14' ?

On Thu, Nov 24, 2016 at 3:41 PM David Richer <david.richer@autodesk.com>
wrote:

Yes, I tried, it’s no longer available in the pgdg repository. I would have a look if I find the rpm package somewhere.

From: Vladimir Rusinov <vrusinov@google.com>
Date: Thursday, November 24, 2016 at 11:19 AM
To: David Richer <david.richer@autodesk.com>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Extension compatibility between postgresql minor version

Maybe, maybe not.

Have you tried installing '=postgresql93-contrib-9.3.14' ?

On Thu, Nov 24, 2016 at 3:41 PM David Richer <david.richer@autodesk.com<mailto:david.richer@autodesk.com>> wrote:
Hi guys,

I want to check my production server for the free space map issue. https://wiki.postgresql.org/wiki/Free_Space_Map_Problems
I am on Centos 6 currently running 9.3.14 using pgdg repository.

I need to install postgresql93-contrib to get the pg_freespacemap extension. Only postgresql93-contrib-9.3.15 package is available in pgdg repository. It will force me to upgrade my postgresql to 9.3.15 which will restart my production postgresql server which I am not yet ready to do, I want to know if we are affected by the free space map issue first.

My question: Would it be safe to install postgresql93-contrib-9.3.15 and not upgrade my postgresql server? In other words, would an extension compiled with 9.3.14 will work with a postgresql 9.3.15 server?

Thanks,
Davud

On 11/24/2016 07:40 AM, David Richer wrote:

Hi guys,

I want to check my production server for the free space map issue.
https://wiki.postgresql.org/wiki/Free_Space_Map_Problems

I am on Centos 6 currently running 9.3.14 using pgdg repository.

I need to install postgresql93-contrib to get the pg_freespacemap
extension. Only postgresql93-contrib-9.3.15 package is available in pgdg
repository. It will force me to upgrade my postgresql to 9.3.15 which
will restart my production postgresql server which I am not yet ready to
do, I want to know if we are affected by the free space map issue first.

My question: Would it be safe to install postgresql93-contrib-9.3.15 and
not upgrade my postgresql server? In other words, would an extension
compiled with 9.3.14 will work with a postgresql 9.3.15 server?

I was following you until I got to the last sentence. Is that what you
really meant to say?

Thanks,

Davud

--
Adrian Klaver
adrian.klaver@aklaver.com

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

I am not an expert but I am assuming that the native part of the extension (pg_freespacemap.so) is compiled with postgresql headers and libs.

On 2016-11-24, 11:55 AM, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote:

On 11/24/2016 07:40 AM, David Richer wrote:

Hi guys,

I want to check my production server for the free space map issue.
https://wiki.postgresql.org/wiki/Free_Space_Map_Problems

I am on Centos 6 currently running 9.3.14 using pgdg repository.

I need to install postgresql93-contrib to get the pg_freespacemap
extension. Only postgresql93-contrib-9.3.15 package is available in pgdg
repository. It will force me to upgrade my postgresql to 9.3.15 which
will restart my production postgresql server which I am not yet ready to
do, I want to know if we are affected by the free space map issue first.

My question: Would it be safe to install postgresql93-contrib-9.3.15 and
not upgrade my postgresql server? In other words, would an extension
compiled with 9.3.14 will work with a postgresql 9.3.15 server?

I was following you until I got to the last sentence. Is that what you
really meant to say?

Thanks,

Davud

--
Adrian Klaver
adrian.klaver@aklaver.com

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

On 11/24/2016 09:01 AM, David Richer wrote:

I am not an expert but I am assuming that the native part of the extension (pg_freespacemap.so) is compiled with postgresql headers and libs.

The part that confused me is the last part where you ask about using a
9.3.14 extension with a 9.3.15 server which is the opposite of
everything you said previously, in particular the prior sentence.

On 2016-11-24, 11:55 AM, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote:

On 11/24/2016 07:40 AM, David Richer wrote:

Hi guys,

I want to check my production server for the free space map issue.
https://wiki.postgresql.org/wiki/Free_Space_Map_Problems

I am on Centos 6 currently running 9.3.14 using pgdg repository.

I need to install postgresql93-contrib to get the pg_freespacemap
extension. Only postgresql93-contrib-9.3.15 package is available in pgdg
repository. It will force me to upgrade my postgresql to 9.3.15 which
will restart my production postgresql server which I am not yet ready to
do, I want to know if we are affected by the free space map issue first.

My question: Would it be safe to install postgresql93-contrib-9.3.15 and
not upgrade my postgresql server? In other words, would an extension
compiled with 9.3.14 will work with a postgresql 9.3.15 server?

I was following you until I got to the last sentence. Is that what you
really meant to say?

Thanks,

Davud

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Adrian Klaver
adrian.klaver@aklaver.com

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

Adrian Klaver <adrian.klaver@aklaver.com> writes:

On 11/24/2016 09:01 AM, David Richer wrote:

I am not an expert but I am assuming that the native part of the extension (pg_freespacemap.so) is compiled with postgresql headers and libs.

The part that confused me is the last part where you ask about using a
9.3.14 extension with a 9.3.15 server which is the opposite of
everything you said previously, in particular the prior sentence.

It would probably work either way, although a prudent man would peruse
the 9.3.15 release notes to see if anything was said about changes that
cause breakage of extensions. But we try hard to avoid such changes
in minor releases, particularly in long-stable branches.

regards, tom lane

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

Yes are right, I meant a 9.3.15 extension with a 9.3.14 server.
Thanks for the help guys!

On 2016-11-24, 12:10 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

Adrian Klaver <adrian.klaver@aklaver.com> writes:

On 11/24/2016 09:01 AM, David Richer wrote:

I am not an expert but I am assuming that the native part of the extension (pg_freespacemap.so) is compiled with postgresql headers and libs.

The part that confused me is the last part where you ask about using a
9.3.14 extension with a 9.3.15 server which is the opposite of
everything you said previously, in particular the prior sentence.

It would probably work either way, although a prudent man would peruse
the 9.3.15 release notes to see if anything was said about changes that
cause breakage of extensions. But we try hard to avoid such changes
in minor releases, particularly in long-stable branches.

regards, tom lane

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