how to upgrade postgresql?
Stuart McGraw
smcg4191 at mtneva.com
Tue Mar 20 00:03:13 UTC 2018
I am not sure if this is a Ubuntu question or a Postgresql one
but I have to start somewhere so...
I am new to Ubuntu and have installed 17.10. 17.10 comes with
Postgresql-9.6.6 by default but I have requirement for Postgresql-10
so I did not install postgresql from Ubuntu's repos but instead
added this file to /etc/apt/sources.list.d/:
deb http://apt.postgresql.org/pub/repos/apt/ zesty-pgdg main
The pgdg repo does not apparently provides a separate package
for artful (17.10), one is supposed to use the zesty package[*1].
I eventually got it installed, working around a version conflict
with a perl package (libdbd-pg-perl).
However, when I did this several months ago, the current pg
version was 10.1. It is now 10.3 but despite doing a "apt-get
update; apt-get upgrade" (or dist-upgrade) apt does not offer
to upgrade postgresql. When I do "apt list 'postgresql-*" I
see only postgresql-10.1 packages.
Since I am new to Ubuntu I am kind of lost as to how to figure
out what is wrong and get postgresql upgraded. Any suggestions?
---
[*1] https://dba.stackexchange.com/questions/190845/postgresql-10-for-ubuntu-17-10-artful
More information about the ubuntu-users
mailing list