talon at lpthe.jussieu.fr
Mon Aug 1 17:11:42 UTC 2011
On Mon, Aug 01, 2011 at 01:59:08PM -0300, Sergio de Almeida Lenzi wrote:
> Even I use portmaster (a very good piece of software),
> it becomes very slow when you have 1550 ports installed in your
> 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
> 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
> 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
> is to install them on the slaves, (again, using the postgres database
> Hope this can give someone some ideas....
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.
More information about the freebsd-ports