How to install postgresl 9.6.8 or 10.3 to Ubuntu 17.10 Artful Aardvark?
Clash Royale CLAN TAG#URR8PPP up vote
0
down vote
favorite
There is this postgres security patch which was deployed at heroku and now I can't install postgres dumps from heroku to my local machine. Because this masterminds able to produce only archived dumps not plain sql.
Ubuntu 17.10 is not supported by postgres and aptitude failed to install 10.3 version from Xenial repos.
Getting "unsupported version (1.13) in file header" when running pg_restore | Stack Overflow
apt repository postgresql
edited Mar 23 at 12:42
Drakonoved
7421515
asked Mar 22 at 21:58
scythargon
1065
add a comment |Â
up vote
0
down vote
favorite
There is this postgres security patch which was deployed at heroku and now I can't install postgres dumps from heroku to my local machine. Because this masterminds able to produce only archived dumps not plain sql.
Ubuntu 17.10 is not supported by postgres and aptitude failed to install 10.3 version from Xenial repos.
Getting "unsupported version (1.13) in file header" when running pg_restore | Stack Overflow
apt repository postgresql
edited Mar 23 at 12:42
Drakonoved
7421515
asked Mar 22 at 21:58
scythargon
1065
I believe thepostgresqlpackage in the official 17.10 repositories installs 9.6.8. Have you triedsudo apt install postgresql?
– fkraiem
Mar 23 at 12:53
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
There is this postgres security patch which was deployed at heroku and now I can't install postgres dumps from heroku to my local machine. Because this masterminds able to produce only archived dumps not plain sql.
Ubuntu 17.10 is not supported by postgres and aptitude failed to install 10.3 version from Xenial repos.
Getting "unsupported version (1.13) in file header" when running pg_restore | Stack Overflow
apt repository postgresql
edited Mar 23 at 12:42
Drakonoved
7421515
asked Mar 22 at 21:58
scythargon
1065
There is this postgres security patch which was deployed at heroku and now I can't install postgres dumps from heroku to my local machine. Because this masterminds able to produce only archived dumps not plain sql.
Ubuntu 17.10 is not supported by postgres and aptitude failed to install 10.3 version from Xenial repos.
Getting "unsupported version (1.13) in file header" when running pg_restore | Stack Overflow
apt repository postgresql
apt repository postgresql
edited Mar 23 at 12:42
Drakonoved
7421515
asked Mar 22 at 21:58
scythargon
1065
edited Mar 23 at 12:42
Drakonoved
7421515
asked Mar 22 at 21:58
scythargon
1065
edited Mar 23 at 12:42
Drakonoved
7421515
edited Mar 23 at 12:42
Drakonoved
7421515
edited Mar 23 at 12:42
Drakonoved
7421515
7421515
asked Mar 22 at 21:58
scythargon
1065
asked Mar 22 at 21:58
scythargon
1065
asked Mar 22 at 21:58
scythargon
1065
1065
I believe thepostgresqlpackage in the official 17.10 repositories installs 9.6.8. Have you triedsudo apt install postgresql?
– fkraiem
Mar 23 at 12:53
add a comment |Â
I believe thepostgresqlpackage in the official 17.10 repositories installs 9.6.8. Have you triedsudo apt install postgresql?
– fkraiem
Mar 23 at 12:53
I believe the
postgresql package in the official 17.10 repositories installs 9.6.8. Have you tried sudo apt install postgresql?– fkraiem
Mar 23 at 12:53
I believe the
postgresql package in the official 17.10 repositories installs 9.6.8. Have you tried sudo apt install postgresql?– fkraiem
Mar 23 at 12:53
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
1
down vote
I was able to upgrade from 10.1 to 10.3 by changing to the xenial repository at https://www.postgresql.org/download/linux/ubuntu/.
answered Apr 10 at 7:52
Haakon
328136
That worked to upgrade all the client programs (pg_dump, pg_restore, psql), but it does not allow the server to be upgraded. To do that, you have to add "deb security.ubuntu.com/ubuntu xenial-security main" to /etc/apt/sources.list.d/pgdg.list". (The libicu55 package is required for PG 10.3 server, and it is not available on Artful.) Once you add this, do an "sudo apt update" and the package will be upgradable.
– Chris Curvey
Apr 24 at 13:59
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
I was able to upgrade from 10.1 to 10.3 by changing to the xenial repository at https://www.postgresql.org/download/linux/ubuntu/.
answered Apr 10 at 7:52
Haakon
328136
That worked to upgrade all the client programs (pg_dump, pg_restore, psql), but it does not allow the server to be upgraded. To do that, you have to add "deb security.ubuntu.com/ubuntu xenial-security main" to /etc/apt/sources.list.d/pgdg.list". (The libicu55 package is required for PG 10.3 server, and it is not available on Artful.) Once you add this, do an "sudo apt update" and the package will be upgradable.
– Chris Curvey
Apr 24 at 13:59
add a comment |Â
up vote
1
down vote
I was able to upgrade from 10.1 to 10.3 by changing to the xenial repository at https://www.postgresql.org/download/linux/ubuntu/.
answered Apr 10 at 7:52
Haakon
328136
That worked to upgrade all the client programs (pg_dump, pg_restore, psql), but it does not allow the server to be upgraded. To do that, you have to add "deb security.ubuntu.com/ubuntu xenial-security main" to /etc/apt/sources.list.d/pgdg.list". (The libicu55 package is required for PG 10.3 server, and it is not available on Artful.) Once you add this, do an "sudo apt update" and the package will be upgradable.
– Chris Curvey
Apr 24 at 13:59
add a comment |Â
up vote
1
down vote
up vote
1
down vote
I was able to upgrade from 10.1 to 10.3 by changing to the xenial repository at https://www.postgresql.org/download/linux/ubuntu/.
answered Apr 10 at 7:52
Haakon
328136
I was able to upgrade from 10.1 to 10.3 by changing to the xenial repository at https://www.postgresql.org/download/linux/ubuntu/.
answered Apr 10 at 7:52
Haakon
328136
answered Apr 10 at 7:52
Haakon
328136
answered Apr 10 at 7:52
Haakon
328136
answered Apr 10 at 7:52
Haakon
328136
328136
That worked to upgrade all the client programs (pg_dump, pg_restore, psql), but it does not allow the server to be upgraded. To do that, you have to add "deb security.ubuntu.com/ubuntu xenial-security main" to /etc/apt/sources.list.d/pgdg.list". (The libicu55 package is required for PG 10.3 server, and it is not available on Artful.) Once you add this, do an "sudo apt update" and the package will be upgradable.
– Chris Curvey
Apr 24 at 13:59
add a comment |Â
That worked to upgrade all the client programs (pg_dump, pg_restore, psql), but it does not allow the server to be upgraded. To do that, you have to add "deb security.ubuntu.com/ubuntu xenial-security main" to /etc/apt/sources.list.d/pgdg.list". (The libicu55 package is required for PG 10.3 server, and it is not available on Artful.) Once you add this, do an "sudo apt update" and the package will be upgradable.
– Chris Curvey
Apr 24 at 13:59
That worked to upgrade all the client programs (pg_dump, pg_restore, psql), but it does not allow the server to be upgraded. To do that, you have to add "deb security.ubuntu.com/ubuntu xenial-security main" to /etc/apt/sources.list.d/pgdg.list". (The libicu55 package is required for PG 10.3 server, and it is not available on Artful.) Once you add this, do an "sudo apt update" and the package will be upgradable.
– Chris Curvey
Apr 24 at 13:59
That worked to upgrade all the client programs (pg_dump, pg_restore, psql), but it does not allow the server to be upgraded. To do that, you have to add "deb security.ubuntu.com/ubuntu xenial-security main" to /etc/apt/sources.list.d/pgdg.list". (The libicu55 package is required for PG 10.3 server, and it is not available on Artful.) Once you add this, do an "sudo apt update" and the package will be upgradable.
– Chris Curvey
Apr 24 at 13:59
add a comment |Â
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1018376%2fhow-to-install-postgresl-9-6-8-or-10-3-to-ubuntu-17-10-artful-aardvark%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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
I believe the
postgresqlpackage in the official 17.10 repositories installs 9.6.8. Have you triedsudo apt install postgresql?– fkraiem
Mar 23 at 12:53