Re: postgresql-10.3 on unbuntu-17.10 - how??
От | Adrian Klaver |
---|---|
Тема | Re: postgresql-10.3 on unbuntu-17.10 - how?? |
Дата | |
Msg-id | d71e1f44-e5af-d0b5-68ee-785e294d069a@aklaver.com обсуждение исходный текст |
Ответ на | Re: postgresql-10.3 on unbuntu-17.10 - how?? (Stuart McGraw <smcg4191@mtneva.com>) |
Ответы |
Re: postgresql-10.3 on unbuntu-17.10 - how??
(Vincenzo Romano <vincenzo.romano@notorand.it>)
Re: postgresql-10.3 on unbuntu-17.10 - how?? (Stuart McGraw <smcg4191@mtneva.com>) |
Список | pgsql-general |
On 03/20/2018 10:52 PM, Stuart McGraw wrote: Looks like these posts are coming through a news group to me. I am Ccing list to get response back there. >>> >>> Is Pgdg 10.3 even available for ubuntu 17.10? How the heck does >>> one upgrade to it? >> >> 18.04 LTS (Bionic Beaver)?: >> >> http://apt.postgresql.org/pub/repos/apt/dists/bionic-pgdg/ > > I tried doing a full reinstall of Ubuntu-17.10 followed by a postgresql > install from the bionic repo (instead of installing 10.1 per above and > trying to upgrade) > > # apt-get -qy install postgresql postgresql-client postgresql-contrib \ > postgresql-doc pgadmin3 postgresql-server-dev-10 libpq-dev > Reading package lists... > Building dependency tree... > Reading state information... > Some packages could not be installed. This may mean that you have > requested an impossible situation or if you are using the unstable > distribution that some required packages have not yet been created > or been moved out of Incoming. > The following information may help to resolve the situation: > > The following packages have unmet dependencies: > libpq-dev : Depends: libpq5 (= 10.3-1.pgdg18.04+1) but it is not > going to be installed > pgadmin3 : Depends: libgcrypt20 (>= 1.8.0) but 1.7.8-2ubuntu1 is to > be installed > Depends: libpq5 (>= 8.4~) but it is not going to be > installed > Recommends: pgagent but it is not going to be installed > postgresql : Depends: postgresql-10 but it is not going to be installed > postgresql-client : Depends: postgresql-client-10 > postgresql-contrib : Depends: postgresql-contrib-10 > E: Unable to correct problems, you have held broken packages. If it where me I would simplify the above for the moment to : apt-get install postgresql-10 > > Is there any reason now not to conclude that the 10.3 bionic version is > simply incompatible with Ubuntu-17.10 (at least without a lot more package > wrangling chops than I have)? > > One can install postgresql-10.1 but one cannot upgrade it to get security > fixes or to be able to load data dumped from another 10.3 database. > > Given that Ubuntu-18.04 will be out soon I guess this is pretty much moot > except for a few unfortunates like me who absolutely need 10.3 but have no > option to upgrade. I guess the lesson is that running the Pgdg versions > of Postgresql on any but the LTS versions of Ubuntu is pretty risky. > Live and learn. Maybe this will help someone else. -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления:
Предыдущее
От: Pavel StehuleДата:
Сообщение: Re: Is there a way to get the name of the calling function in pgplsql?