Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 1 Aug 2011 19:11:38 +0200
From:      Michel Talon <talon@lpthe.jussieu.fr>
To:        Sergio de Almeida Lenzi <lenzi.sergio@gmail.com>
Cc:        freebsd-ports@freebsd.org
Subject:   Re: UPDATING 20110730
Message-ID:  <20110801171138.GA56708@lpthe.jussieu.fr>
In-Reply-To: <1312217948.22733.26.camel@z6000.lenzicasa>
References:  <20110801085135.GA45113@lpthe.jussieu.fr> <4E367999.8000906@FreeBSD.org> <1312217948.22733.26.camel@z6000.lenzicasa>

next in thread | previous in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20110801171138.GA56708>