ERROR: could not load library “/usr/lib64/pgsql/hstore.so”: /lib64/libc.so.6: version `GLIBC_2.14' not...
Multi tool use
up vote
2
down vote
favorite
I’m trying to enable hstore on my PostgreSQL database running on an Amazon Linux AMI. I’ve already jumped through a ton of hurdles and ended up with this error that I can’t get past:
ERROR: could not load library "/usr/lib64/pgsql/hstore.so": /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /usr/lib64/pgsql/hstore.so)
I run ldd --version
to get my version of GLIBC and it returns ldd (GNU libc) 2.17
.
The only solutions that I've come across suggest
Running
yum update
, which doesn’t make much sense because my system appears to be running a more recent version than that required.Recompiling the program against the version of
glibc
that’s on your system, which I don’t quite understand. What program would I have to recompile? PostgreSQL?
This has been driving me nuts for days and I have run into a corner. Any help is greatly appreciated!
linux amazon-ec2 postgresql amazon-web-services
add a comment |
up vote
2
down vote
favorite
I’m trying to enable hstore on my PostgreSQL database running on an Amazon Linux AMI. I’ve already jumped through a ton of hurdles and ended up with this error that I can’t get past:
ERROR: could not load library "/usr/lib64/pgsql/hstore.so": /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /usr/lib64/pgsql/hstore.so)
I run ldd --version
to get my version of GLIBC and it returns ldd (GNU libc) 2.17
.
The only solutions that I've come across suggest
Running
yum update
, which doesn’t make much sense because my system appears to be running a more recent version than that required.Recompiling the program against the version of
glibc
that’s on your system, which I don’t quite understand. What program would I have to recompile? PostgreSQL?
This has been driving me nuts for days and I have run into a corner. Any help is greatly appreciated!
linux amazon-ec2 postgresql amazon-web-services
1
Yes; You should be recompiling postgres
– Ramhound
Mar 12 '15 at 1:23
Is there any other solution? This is a huge production db machine for a service that needs to be up 24/7
– D-Nice
Mar 12 '15 at 1:32
Have you tried creating a snapshot, and doing the first solution, because if its a dll problem you will experience downtime.
– Ramhound
Mar 12 '15 at 11:03
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
I’m trying to enable hstore on my PostgreSQL database running on an Amazon Linux AMI. I’ve already jumped through a ton of hurdles and ended up with this error that I can’t get past:
ERROR: could not load library "/usr/lib64/pgsql/hstore.so": /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /usr/lib64/pgsql/hstore.so)
I run ldd --version
to get my version of GLIBC and it returns ldd (GNU libc) 2.17
.
The only solutions that I've come across suggest
Running
yum update
, which doesn’t make much sense because my system appears to be running a more recent version than that required.Recompiling the program against the version of
glibc
that’s on your system, which I don’t quite understand. What program would I have to recompile? PostgreSQL?
This has been driving me nuts for days and I have run into a corner. Any help is greatly appreciated!
linux amazon-ec2 postgresql amazon-web-services
I’m trying to enable hstore on my PostgreSQL database running on an Amazon Linux AMI. I’ve already jumped through a ton of hurdles and ended up with this error that I can’t get past:
ERROR: could not load library "/usr/lib64/pgsql/hstore.so": /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /usr/lib64/pgsql/hstore.so)
I run ldd --version
to get my version of GLIBC and it returns ldd (GNU libc) 2.17
.
The only solutions that I've come across suggest
Running
yum update
, which doesn’t make much sense because my system appears to be running a more recent version than that required.Recompiling the program against the version of
glibc
that’s on your system, which I don’t quite understand. What program would I have to recompile? PostgreSQL?
This has been driving me nuts for days and I have run into a corner. Any help is greatly appreciated!
linux amazon-ec2 postgresql amazon-web-services
linux amazon-ec2 postgresql amazon-web-services
edited Mar 20 '15 at 18:22
JakeGould
30.9k1093137
30.9k1093137
asked Mar 12 '15 at 1:21
D-Nice
112
112
1
Yes; You should be recompiling postgres
– Ramhound
Mar 12 '15 at 1:23
Is there any other solution? This is a huge production db machine for a service that needs to be up 24/7
– D-Nice
Mar 12 '15 at 1:32
Have you tried creating a snapshot, and doing the first solution, because if its a dll problem you will experience downtime.
– Ramhound
Mar 12 '15 at 11:03
add a comment |
1
Yes; You should be recompiling postgres
– Ramhound
Mar 12 '15 at 1:23
Is there any other solution? This is a huge production db machine for a service that needs to be up 24/7
– D-Nice
Mar 12 '15 at 1:32
Have you tried creating a snapshot, and doing the first solution, because if its a dll problem you will experience downtime.
– Ramhound
Mar 12 '15 at 11:03
1
1
Yes; You should be recompiling postgres
– Ramhound
Mar 12 '15 at 1:23
Yes; You should be recompiling postgres
– Ramhound
Mar 12 '15 at 1:23
Is there any other solution? This is a huge production db machine for a service that needs to be up 24/7
– D-Nice
Mar 12 '15 at 1:32
Is there any other solution? This is a huge production db machine for a service that needs to be up 24/7
– D-Nice
Mar 12 '15 at 1:32
Have you tried creating a snapshot, and doing the first solution, because if its a dll problem you will experience downtime.
– Ramhound
Mar 12 '15 at 11:03
Have you tried creating a snapshot, and doing the first solution, because if its a dll problem you will experience downtime.
– Ramhound
Mar 12 '15 at 11:03
add a comment |
3 Answers
3
active
oldest
votes
up vote
0
down vote
The error is on the hstore
shared library, so it is probably the only one that needs compiling with your version of GLIBC. The one contained in your postgres package evidently was compiled with version 2.14, while yours is 2.17.
Normally hstore
should be satisfied with a higher-level version, but the check it does is apparently “equal-to 2.14” instead of “greater-or-equal-to 2.14.”
The article PostgreSQL feature highlight: hstore
describes how to
install the hstore
library from the source code:
After downloading the source code and installing the core, do the
following commands.
cd $PG_SOURCE_ROOT
cd contrib/hstore
make install
At this point all the libraries and files related to hstore are
installed in $INSTALL_FOLDER/share/extension.
$ ls $INSTALL_FOLDER/share/extension
hstore--1.0--1.1.sql hstore--1.1.sql hstore--unpackaged--1.0.sql hstore.control
Then connect to your Postgres server and finish hstore installation
with CREATE EXTENSION command.
postgres=# CREATE EXTENSION hstore;
CREATE EXTENSION
postgres=# dx hstore
List of installed extensions
Name | Version | Schema | Description
--------+---------+--------+--------------------------------------------------
hstore | 1.1 | public | data type for storing sets of (key, value) pairs
(1 row)
With a psql client, 'dx' allows to check the list of extensions
already installed on your server.
add a comment |
up vote
0
down vote
I'm running on Manjaro Linux (a fork of Arch), and I had this after I had upgraded Postgres from version 10 to 11.
(The path was slightly different for me. I got: could not load library "/usr/lib/postgresql/hstore.so"
.)
I followed the arch wiki instructions on upgrading postgres, and was up and running in no time.
add a comment |
up vote
-1
down vote
Get a newer hstore.so yours is to old for the system you're running. Or try to find a compat-glibc package for glueing.
Thanks, this sounds promising. I haven't been able to find any standalone copies of hstore.so on the web. I suspect that I may be going about it the wrong way -- how would you suggest updating only the hstore.so file?
– D-Nice
Mar 13 '15 at 0:39
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f888537%2ferror-could-not-load-library-usr-lib64-pgsql-hstore-so-lib64-libc-so-6-ve%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
The error is on the hstore
shared library, so it is probably the only one that needs compiling with your version of GLIBC. The one contained in your postgres package evidently was compiled with version 2.14, while yours is 2.17.
Normally hstore
should be satisfied with a higher-level version, but the check it does is apparently “equal-to 2.14” instead of “greater-or-equal-to 2.14.”
The article PostgreSQL feature highlight: hstore
describes how to
install the hstore
library from the source code:
After downloading the source code and installing the core, do the
following commands.
cd $PG_SOURCE_ROOT
cd contrib/hstore
make install
At this point all the libraries and files related to hstore are
installed in $INSTALL_FOLDER/share/extension.
$ ls $INSTALL_FOLDER/share/extension
hstore--1.0--1.1.sql hstore--1.1.sql hstore--unpackaged--1.0.sql hstore.control
Then connect to your Postgres server and finish hstore installation
with CREATE EXTENSION command.
postgres=# CREATE EXTENSION hstore;
CREATE EXTENSION
postgres=# dx hstore
List of installed extensions
Name | Version | Schema | Description
--------+---------+--------+--------------------------------------------------
hstore | 1.1 | public | data type for storing sets of (key, value) pairs
(1 row)
With a psql client, 'dx' allows to check the list of extensions
already installed on your server.
add a comment |
up vote
0
down vote
The error is on the hstore
shared library, so it is probably the only one that needs compiling with your version of GLIBC. The one contained in your postgres package evidently was compiled with version 2.14, while yours is 2.17.
Normally hstore
should be satisfied with a higher-level version, but the check it does is apparently “equal-to 2.14” instead of “greater-or-equal-to 2.14.”
The article PostgreSQL feature highlight: hstore
describes how to
install the hstore
library from the source code:
After downloading the source code and installing the core, do the
following commands.
cd $PG_SOURCE_ROOT
cd contrib/hstore
make install
At this point all the libraries and files related to hstore are
installed in $INSTALL_FOLDER/share/extension.
$ ls $INSTALL_FOLDER/share/extension
hstore--1.0--1.1.sql hstore--1.1.sql hstore--unpackaged--1.0.sql hstore.control
Then connect to your Postgres server and finish hstore installation
with CREATE EXTENSION command.
postgres=# CREATE EXTENSION hstore;
CREATE EXTENSION
postgres=# dx hstore
List of installed extensions
Name | Version | Schema | Description
--------+---------+--------+--------------------------------------------------
hstore | 1.1 | public | data type for storing sets of (key, value) pairs
(1 row)
With a psql client, 'dx' allows to check the list of extensions
already installed on your server.
add a comment |
up vote
0
down vote
up vote
0
down vote
The error is on the hstore
shared library, so it is probably the only one that needs compiling with your version of GLIBC. The one contained in your postgres package evidently was compiled with version 2.14, while yours is 2.17.
Normally hstore
should be satisfied with a higher-level version, but the check it does is apparently “equal-to 2.14” instead of “greater-or-equal-to 2.14.”
The article PostgreSQL feature highlight: hstore
describes how to
install the hstore
library from the source code:
After downloading the source code and installing the core, do the
following commands.
cd $PG_SOURCE_ROOT
cd contrib/hstore
make install
At this point all the libraries and files related to hstore are
installed in $INSTALL_FOLDER/share/extension.
$ ls $INSTALL_FOLDER/share/extension
hstore--1.0--1.1.sql hstore--1.1.sql hstore--unpackaged--1.0.sql hstore.control
Then connect to your Postgres server and finish hstore installation
with CREATE EXTENSION command.
postgres=# CREATE EXTENSION hstore;
CREATE EXTENSION
postgres=# dx hstore
List of installed extensions
Name | Version | Schema | Description
--------+---------+--------+--------------------------------------------------
hstore | 1.1 | public | data type for storing sets of (key, value) pairs
(1 row)
With a psql client, 'dx' allows to check the list of extensions
already installed on your server.
The error is on the hstore
shared library, so it is probably the only one that needs compiling with your version of GLIBC. The one contained in your postgres package evidently was compiled with version 2.14, while yours is 2.17.
Normally hstore
should be satisfied with a higher-level version, but the check it does is apparently “equal-to 2.14” instead of “greater-or-equal-to 2.14.”
The article PostgreSQL feature highlight: hstore
describes how to
install the hstore
library from the source code:
After downloading the source code and installing the core, do the
following commands.
cd $PG_SOURCE_ROOT
cd contrib/hstore
make install
At this point all the libraries and files related to hstore are
installed in $INSTALL_FOLDER/share/extension.
$ ls $INSTALL_FOLDER/share/extension
hstore--1.0--1.1.sql hstore--1.1.sql hstore--unpackaged--1.0.sql hstore.control
Then connect to your Postgres server and finish hstore installation
with CREATE EXTENSION command.
postgres=# CREATE EXTENSION hstore;
CREATE EXTENSION
postgres=# dx hstore
List of installed extensions
Name | Version | Schema | Description
--------+---------+--------+--------------------------------------------------
hstore | 1.1 | public | data type for storing sets of (key, value) pairs
(1 row)
With a psql client, 'dx' allows to check the list of extensions
already installed on your server.
edited Mar 20 '15 at 18:24
JakeGould
30.9k1093137
30.9k1093137
answered Mar 15 '15 at 19:31
harrymc
251k11259558
251k11259558
add a comment |
add a comment |
up vote
0
down vote
I'm running on Manjaro Linux (a fork of Arch), and I had this after I had upgraded Postgres from version 10 to 11.
(The path was slightly different for me. I got: could not load library "/usr/lib/postgresql/hstore.so"
.)
I followed the arch wiki instructions on upgrading postgres, and was up and running in no time.
add a comment |
up vote
0
down vote
I'm running on Manjaro Linux (a fork of Arch), and I had this after I had upgraded Postgres from version 10 to 11.
(The path was slightly different for me. I got: could not load library "/usr/lib/postgresql/hstore.so"
.)
I followed the arch wiki instructions on upgrading postgres, and was up and running in no time.
add a comment |
up vote
0
down vote
up vote
0
down vote
I'm running on Manjaro Linux (a fork of Arch), and I had this after I had upgraded Postgres from version 10 to 11.
(The path was slightly different for me. I got: could not load library "/usr/lib/postgresql/hstore.so"
.)
I followed the arch wiki instructions on upgrading postgres, and was up and running in no time.
I'm running on Manjaro Linux (a fork of Arch), and I had this after I had upgraded Postgres from version 10 to 11.
(The path was slightly different for me. I got: could not load library "/usr/lib/postgresql/hstore.so"
.)
I followed the arch wiki instructions on upgrading postgres, and was up and running in no time.
answered Dec 5 at 11:45
meshy
1013
1013
add a comment |
add a comment |
up vote
-1
down vote
Get a newer hstore.so yours is to old for the system you're running. Or try to find a compat-glibc package for glueing.
Thanks, this sounds promising. I haven't been able to find any standalone copies of hstore.so on the web. I suspect that I may be going about it the wrong way -- how would you suggest updating only the hstore.so file?
– D-Nice
Mar 13 '15 at 0:39
add a comment |
up vote
-1
down vote
Get a newer hstore.so yours is to old for the system you're running. Or try to find a compat-glibc package for glueing.
Thanks, this sounds promising. I haven't been able to find any standalone copies of hstore.so on the web. I suspect that I may be going about it the wrong way -- how would you suggest updating only the hstore.so file?
– D-Nice
Mar 13 '15 at 0:39
add a comment |
up vote
-1
down vote
up vote
-1
down vote
Get a newer hstore.so yours is to old for the system you're running. Or try to find a compat-glibc package for glueing.
Get a newer hstore.so yours is to old for the system you're running. Or try to find a compat-glibc package for glueing.
answered Mar 12 '15 at 18:36
bbaassssiiee
9171915
9171915
Thanks, this sounds promising. I haven't been able to find any standalone copies of hstore.so on the web. I suspect that I may be going about it the wrong way -- how would you suggest updating only the hstore.so file?
– D-Nice
Mar 13 '15 at 0:39
add a comment |
Thanks, this sounds promising. I haven't been able to find any standalone copies of hstore.so on the web. I suspect that I may be going about it the wrong way -- how would you suggest updating only the hstore.so file?
– D-Nice
Mar 13 '15 at 0:39
Thanks, this sounds promising. I haven't been able to find any standalone copies of hstore.so on the web. I suspect that I may be going about it the wrong way -- how would you suggest updating only the hstore.so file?
– D-Nice
Mar 13 '15 at 0:39
Thanks, this sounds promising. I haven't been able to find any standalone copies of hstore.so on the web. I suspect that I may be going about it the wrong way -- how would you suggest updating only the hstore.so file?
– D-Nice
Mar 13 '15 at 0:39
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f888537%2ferror-could-not-load-library-usr-lib64-pgsql-hstore-so-lib64-libc-so-6-ve%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
sA3Li9sR EURMN2 QNuVb1 P97mBiaHOEQMGnbqsb aeR6t nMlFZfC,A9KzpFIt08rPp7psa Si6t29GA7bj8fxXUa,6W
1
Yes; You should be recompiling postgres
– Ramhound
Mar 12 '15 at 1:23
Is there any other solution? This is a huge production db machine for a service that needs to be up 24/7
– D-Nice
Mar 12 '15 at 1:32
Have you tried creating a snapshot, and doing the first solution, because if its a dll problem you will experience downtime.
– Ramhound
Mar 12 '15 at 11:03