From owner-freebsd-ports@freebsd.org  Tue Jun 28 10:16:27 2016
Return-Path: <owner-freebsd-ports@freebsd.org>
Delivered-To: freebsd-ports@mailman.ysv.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by mailman.ysv.freebsd.org (Postfix) with ESMTP id 44D08B84C3E
 for <freebsd-ports@mailman.ysv.freebsd.org>;
 Tue, 28 Jun 2016 10:16:27 +0000 (UTC)
 (envelope-from 000.fbsd@quip.cz)
Received: from elsa.codelab.cz (elsa.codelab.cz [94.124.105.4])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client did not present a certificate)
 by mx1.freebsd.org (Postfix) with ESMTPS id F1DC22FA2
 for <freebsd-ports@freebsd.org>; Tue, 28 Jun 2016 10:16:26 +0000 (UTC)
 (envelope-from 000.fbsd@quip.cz)
Received: from elsa.codelab.cz (localhost [127.0.0.1])
 by elsa.codelab.cz (Postfix) with ESMTP id 23B5228428
 for <freebsd-ports@freebsd.org>; Tue, 28 Jun 2016 12:16:18 +0200 (CEST)
Received: from illbsd.quip.test (ip-86-49-16-209.net.upcbroadband.cz
 [86.49.16.209])
 (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
 (No client certificate requested)
 by elsa.codelab.cz (Postfix) with ESMTPSA id 6751C28438
 for <freebsd-ports@freebsd.org>; Tue, 28 Jun 2016 12:16:17 +0200 (CEST)
Message-ID: <57724E71.4030600@quip.cz>
Date: Tue, 28 Jun 2016 12:16:17 +0200
From: Miroslav Lachman <000.fbsd@quip.cz>
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
 rv:35.0) Gecko/20100101 Firefox/35.0 SeaMonkey/2.32
MIME-Version: 1.0
To: freebsd-ports@freebsd.org
Subject: How to change repository name of installed packages in local database?
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.22
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-ports>,
 <mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports/>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
 <mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 28 Jun 2016 10:16:27 -0000

I searched the man pages but cannot find the answer.
If we have machine with packages installed from more than one repository 
and one day we want to use some already installed packages from another 
repository, is there any easy way of switching this packages to another 
repo?
I am looking for something similar to "pkg set" but we do not want to 
change package name or package origin but package repository information 
recorded in sqlite.

Example:

# pkg query '%R %n' | sort
codelab libiconv
codelab mariadb55-server
codelab p5-Error
codelab p5-Term-ReadKey
codelab p5-subversion
codelab pkg-rmleaf
codelab unzip
codelab vim-lite
redmine320 ImageMagick-nox11
redmine320 ca_root_nss
redmine320 curl
redmine320 expat
redmine320 fontconfig
redmine320 freetype2
redmine320 indexinfo
..
..

Now we need to switch all packages from testing repo "redmine320" to 
production repo "codelab".

Is there any other way instead of manual deinstall and reinstall of all 
those packages?

Miroslav Lachman