UPDATING 20110730

[Michel Talon]

On Mon, Aug 01, 2011 at 01:59:08PM -0300, Sergio de Almeida Lenzi wrote:
> Hello
> 
> Even I use portmaster (a very good piece of software),
> it becomes very slow when you have 1550 ports installed in your
> system.
> 
> As only a few ports (about 100, in my case)  changes in a week time,
> I build a database (postgres) that contains all the ports installed,
> de depencies and a flag that tells me if that port needs updating
> (pkg_version)
> a shell script scans the ports (pkg_info | cut -d ' ' -f 1) and builds
> the database once a week (can take several hours... 
> 
> Once the database is built,  an sql query (only ms...) tells me what to
> do...
> it then executes pkg_delete, cd /usr/ports/..., make clean all package..
> and after doing all the job, it updates the postgresql database
> (seconds... ).
> 
> In my case I use a central server with all the 1550 ports... and all I
> do
> is to install them on the slaves, (again, using the postgres database
> data)...
> 
> Hope this can give someone some ideas....
> 
> Sergio

Some years ago the idea floated around to use a sqlite database to keep
a fast access copy of the important data in /var/db/pkg, but this idea
was dismissed for "various" reasons, in particular the fact that the
base system has the Berkeley database, or that using the filesystem as a
poor man's database was a better idea.


-- 

Michel TALON