Re: Best Open Source OS for Postgresql

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Best Open Source OS for Postgresql
Дата
Msg-id e125651f-2701-0533-71f9-8b450b4bb9df@aklaver.com
обсуждение исходный текст
Ответ на Re: Best Open Source OS for Postgresql  (Bob Jolliffe <bobjolliffe@gmail.com>)
Список pgsql-general
On 2/1/23 9:22 AM, Bob Jolliffe wrote:
> I have generally favoured ubuntu LTS editions over the years, more out 
> of familiarity than any particular good technical reason.  In the past, 
> postgresql on FreeBSD would have been my first goto, but it's harder to 
> get freebsd skills out on the market than ubuntu/debian linux.
> 
> I do have one gripe about the packaged postgis packages : the list of 
> dependencies seem quite enormous.  For example, the previous poster 
> mentions 234MB.  I find the list of dependencies a little baffling and 
> disconcerting.

It is a big program that covers a lot of ground. What is disconcerting 
is that you see the dependencies called out instead of being wrapped 
into a blob.

Not going to make much difference to the dependencies but this:


sudo apt install postgis=3.0.3+dfsg-2.pgdg20.04+1


should actually be:

sudo apt install postgresql-12-postgis-3=3.0.3+dfsg-2.pgdg20.04+1

The first form has a dependency on the latest Postgres, so will want to 
install Postgres 15.

> 
> Regards
> Bob
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Kirk Wolak
Дата:
Сообщение: Re: Sequence vs UUID
Следующее
От: Tom Lane
Дата:
Сообщение: Re: VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches)