[oi-dev] Moving on with postgresql

[Till Wegmueller]

The repo server needs the pkg client to report the statistics. They do 
not get calculated on the repository. The repo server does not care much 
for the client Version as the API, they communicate over has been stable 
and is versioned.

One could count the hits to the files from Webserver logs, but we can 
only track total installations of a particular manifest (package 
description file).

The Package is called postgres not postgresql.
Searching by posgres shows the packages

pkg search -rp postgres
PACKAGE                                             PUBLISHER
pkg:/database/postgres-common at 9.5.24-2020.0.1.0     openindiana.org
pkg:/service/database/postgres-10 at 10.16-2020.0.1.0  openindiana.org
pkg:/service/database/postgres-11 at 11.10-2020.0.1.0  openindiana.org
pkg:/service/database/postgres-12 at 12.5-2020.0.1.0   openindiana.org
pkg:/service/database/postgres-95 at 9.5.24-2020.0.1.0 openindiana.org
pkg:/service/database/postgres-96 at 9.6.20-2020.0.1.0 openindiana.org

I agree that the statistics will help, but for postgres we are outdated 
compared to most other conservative distros even.

-Till

On 17.04.21 21:13, Reginald Beardsley via oi-dev wrote:
> Color me confused. Which server and which client are you talking about? 
> I was referring to the IPS repository and it is not going to care about 
> the age of a client.
> 
> I'm running 2017.10 on this system and can't install much, if anything, 
> any more. Not sure if there is a way to do it, but with a new system on 
> the way and my normal habit of building from source so I can debug if 
> needed it's moot.
> 
> The only pkg I can find using "pkg search postgresql" before 10.x is
> 
> pkg: /database/postgres-96/mysql_fdw at 2.5.3-2020.0.1.0
> 
> However, I don't use Postgres despite compiling it quite a few times. It 
> just never fit something I needed to do. So it's likely that this is a 
> more nuanced question than I thought.
> 
> But collecting install statistics on the repository servers seems to me 
> an important tool for allocating manpower.
> 
> Reg
> 
> 
> 
> 
> On Saturday, April 17, 2021, 06:25:30 PM CDT, Till Wegmueller 
> <toasterson at gmail.com> wrote:
> 
> 
> Hi Reg
> 
> Unfortunately it does not. It never got that feature added.
> 
> It is a point for possible feature to add, but as many people are still
> running old versions of the client, it will take quite a long time for
> the statistics to get traction.
> 
> -Till
> 
> _______________________________________________
> oi-dev mailing list
> oi-dev at openindiana.org
> https://openindiana.org/mailman/listinfo/oi-dev
>