How to install PostgreSQL 9.5 in Ubuntu 18.04?
I want to install PostgreSQL 9.5. But the available version is 9.6.
I only need 9.5 to build wal2json against it and test it (requirement because of AWS version).
apt 18.04 compiling postgresql
asked Jul 14 '18 at 0:31
Ondra ŽižkaOndra Žižka
88511227
add a comment |
I want to install PostgreSQL 9.5. But the available version is 9.6.
I only need 9.5 to build wal2json against it and test it (requirement because of AWS version).
apt 18.04 compiling postgresql
asked Jul 14 '18 at 0:31
Ondra ŽižkaOndra Žižka
88511227
How exactly did you determine the PostgreSQL version after installation ofpostgresql-9.6? Is it possible that you have another installation of PostgreSQL set up on your system in a way that takes precedence over the former?
– David Foerster
Jul 14 '18 at 11:41
Doh! You are right. I had few docker containers running and one was at 5432. However, still, I need 9.5 and the package available is 9.6. I have changed the question accordingly. Thanks.
– Ondra Žižka
Jul 15 '18 at 1:14
Note for whoever compiles against PostgreSQL: Make sure you have the rightpostgresql-dev-<version>package installed, and notpostgresql-dev-all. Also checkpg_configoutput.
– Ondra Žižka
Jul 16 '18 at 1:51
add a comment |
I want to install PostgreSQL 9.5. But the available version is 9.6.
I only need 9.5 to build wal2json against it and test it (requirement because of AWS version).
apt 18.04 compiling postgresql
asked Jul 14 '18 at 0:31
Ondra ŽižkaOndra Žižka
88511227
I want to install PostgreSQL 9.5. But the available version is 9.6.
I only need 9.5 to build wal2json against it and test it (requirement because of AWS version).
apt 18.04 compiling postgresql
apt 18.04 compiling postgresql
asked Jul 14 '18 at 0:31
Ondra ŽižkaOndra Žižka
88511227
asked Jul 14 '18 at 0:31
Ondra ŽižkaOndra Žižka
88511227
edited Jul 15 '18 at 1:15
Ondra Žižka
asked Jul 14 '18 at 0:31
Ondra ŽižkaOndra Žižka
88511227
asked Jul 14 '18 at 0:31
Ondra ŽižkaOndra Žižka
88511227
asked Jul 14 '18 at 0:31
Ondra ŽižkaOndra Žižka
88511227
88511227
How exactly did you determine the PostgreSQL version after installation ofpostgresql-9.6? Is it possible that you have another installation of PostgreSQL set up on your system in a way that takes precedence over the former?
– David Foerster
Jul 14 '18 at 11:41
Doh! You are right. I had few docker containers running and one was at 5432. However, still, I need 9.5 and the package available is 9.6. I have changed the question accordingly. Thanks.
– Ondra Žižka
Jul 15 '18 at 1:14
Note for whoever compiles against PostgreSQL: Make sure you have the rightpostgresql-dev-<version>package installed, and notpostgresql-dev-all. Also checkpg_configoutput.
– Ondra Žižka
Jul 16 '18 at 1:51
add a comment |
How exactly did you determine the PostgreSQL version after installation ofpostgresql-9.6? Is it possible that you have another installation of PostgreSQL set up on your system in a way that takes precedence over the former?
– David Foerster
Jul 14 '18 at 11:41
Doh! You are right. I had few docker containers running and one was at 5432. However, still, I need 9.5 and the package available is 9.6. I have changed the question accordingly. Thanks.
– Ondra Žižka
Jul 15 '18 at 1:14
Note for whoever compiles against PostgreSQL: Make sure you have the rightpostgresql-dev-<version>package installed, and notpostgresql-dev-all. Also checkpg_configoutput.
– Ondra Žižka
Jul 16 '18 at 1:51
How exactly did you determine the PostgreSQL version after installation of
postgresql-9.6? Is it possible that you have another installation of PostgreSQL set up on your system in a way that takes precedence over the former?– David Foerster
Jul 14 '18 at 11:41
How exactly did you determine the PostgreSQL version after installation of
postgresql-9.6? Is it possible that you have another installation of PostgreSQL set up on your system in a way that takes precedence over the former?– David Foerster
Jul 14 '18 at 11:41
Doh! You are right. I had few docker containers running and one was at 5432. However, still, I need 9.5 and the package available is 9.6. I have changed the question accordingly. Thanks.
– Ondra Žižka
Jul 15 '18 at 1:14
Doh! You are right. I had few docker containers running and one was at 5432. However, still, I need 9.5 and the package available is 9.6. I have changed the question accordingly. Thanks.
– Ondra Žižka
Jul 15 '18 at 1:14
Note for whoever compiles against PostgreSQL: Make sure you have the right
postgresql-dev-<version> package installed, and not postgresql-dev-all. Also check pg_config output.– Ondra Žižka
Jul 16 '18 at 1:51
Note for whoever compiles against PostgreSQL: Make sure you have the right
postgresql-dev-<version> package installed, and not postgresql-dev-all. Also check pg_config output.– Ondra Žižka
Jul 16 '18 at 1:51
add a comment |
1 Answer
1
active
oldest
votes
The last supported release that includes postgresql-9.5 in its default repositories is Ubuntu 16.04. Manually download the following two files from the official Ubuntu website:
postgresql-client-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
postgresql-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
The two .deb files have been updated to postgresql-client-9.5_9.5.14-0ubuntu0.16.04_amd64.deb and postgresql-9.5_9.5.14-0ubuntu0.16.04_amd64.deb.
Change directories using cd to the directory containing the two .deb files that you downloaded. Run the following commands:
sudo apt install libedit2 libpq5 libssl1.0.0 postgresql-client-common zlib1g libgssapi-krb5-2 libldap-2.4-2 libpam0g libxml2 postgresql-common locales ssl-cert tzdata sysstat
sudo dpkg -i postgresql-client-9.5_9.5.12-0ubuntu0.16.04_amd64.deb postgresql-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
answered Jul 15 '18 at 1:43
karelkarel
58.8k13128147
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
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',
autoActivateHeartbeat: false,
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%2faskubuntu.com%2fquestions%2f1054949%2fhow-to-install-postgresql-9-5-in-ubuntu-18-04%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The last supported release that includes postgresql-9.5 in its default repositories is Ubuntu 16.04. Manually download the following two files from the official Ubuntu website:
postgresql-client-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
postgresql-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
The two .deb files have been updated to postgresql-client-9.5_9.5.14-0ubuntu0.16.04_amd64.deb and postgresql-9.5_9.5.14-0ubuntu0.16.04_amd64.deb.
Change directories using cd to the directory containing the two .deb files that you downloaded. Run the following commands:
sudo apt install libedit2 libpq5 libssl1.0.0 postgresql-client-common zlib1g libgssapi-krb5-2 libldap-2.4-2 libpam0g libxml2 postgresql-common locales ssl-cert tzdata sysstat
sudo dpkg -i postgresql-client-9.5_9.5.12-0ubuntu0.16.04_amd64.deb postgresql-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
answered Jul 15 '18 at 1:43
karelkarel
58.8k13128147
add a comment |
The last supported release that includes postgresql-9.5 in its default repositories is Ubuntu 16.04. Manually download the following two files from the official Ubuntu website:
postgresql-client-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
postgresql-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
The two .deb files have been updated to postgresql-client-9.5_9.5.14-0ubuntu0.16.04_amd64.deb and postgresql-9.5_9.5.14-0ubuntu0.16.04_amd64.deb.
Change directories using cd to the directory containing the two .deb files that you downloaded. Run the following commands:
sudo apt install libedit2 libpq5 libssl1.0.0 postgresql-client-common zlib1g libgssapi-krb5-2 libldap-2.4-2 libpam0g libxml2 postgresql-common locales ssl-cert tzdata sysstat
sudo dpkg -i postgresql-client-9.5_9.5.12-0ubuntu0.16.04_amd64.deb postgresql-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
answered Jul 15 '18 at 1:43
karelkarel
58.8k13128147
add a comment |
The last supported release that includes postgresql-9.5 in its default repositories is Ubuntu 16.04. Manually download the following two files from the official Ubuntu website:
postgresql-client-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
postgresql-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
The two .deb files have been updated to postgresql-client-9.5_9.5.14-0ubuntu0.16.04_amd64.deb and postgresql-9.5_9.5.14-0ubuntu0.16.04_amd64.deb.
Change directories using cd to the directory containing the two .deb files that you downloaded. Run the following commands:
sudo apt install libedit2 libpq5 libssl1.0.0 postgresql-client-common zlib1g libgssapi-krb5-2 libldap-2.4-2 libpam0g libxml2 postgresql-common locales ssl-cert tzdata sysstat
sudo dpkg -i postgresql-client-9.5_9.5.12-0ubuntu0.16.04_amd64.deb postgresql-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
answered Jul 15 '18 at 1:43
karelkarel
58.8k13128147
The last supported release that includes postgresql-9.5 in its default repositories is Ubuntu 16.04. Manually download the following two files from the official Ubuntu website:
postgresql-client-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
postgresql-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
The two .deb files have been updated to postgresql-client-9.5_9.5.14-0ubuntu0.16.04_amd64.deb and postgresql-9.5_9.5.14-0ubuntu0.16.04_amd64.deb.
Change directories using cd to the directory containing the two .deb files that you downloaded. Run the following commands:
sudo apt install libedit2 libpq5 libssl1.0.0 postgresql-client-common zlib1g libgssapi-krb5-2 libldap-2.4-2 libpam0g libxml2 postgresql-common locales ssl-cert tzdata sysstat
sudo dpkg -i postgresql-client-9.5_9.5.12-0ubuntu0.16.04_amd64.deb postgresql-9.5_9.5.12-0ubuntu0.16.04_amd64.deb
answered Jul 15 '18 at 1:43
karelkarel
58.8k13128147
edited 2 days ago
answered Jul 15 '18 at 1:43
karelkarel
58.8k13128147
answered Jul 15 '18 at 1:43
karelkarel
58.8k13128147
answered Jul 15 '18 at 1:43
karelkarel
58.8k13128147
58.8k13128147
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- 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%2faskubuntu.com%2fquestions%2f1054949%2fhow-to-install-postgresql-9-5-in-ubuntu-18-04%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
How exactly did you determine the PostgreSQL version after installation of
postgresql-9.6? Is it possible that you have another installation of PostgreSQL set up on your system in a way that takes precedence over the former?– David Foerster
Jul 14 '18 at 11:41
Doh! You are right. I had few docker containers running and one was at 5432. However, still, I need 9.5 and the package available is 9.6. I have changed the question accordingly. Thanks.
– Ondra Žižka
Jul 15 '18 at 1:14
Note for whoever compiles against PostgreSQL: Make sure you have the right
postgresql-dev-<version>package installed, and notpostgresql-dev-all. Also checkpg_configoutput.– Ondra Žižka
Jul 16 '18 at 1:51