From owner-freebsd-current@freebsd.org  Mon Feb 27 19:28:40 2017
Return-Path: <owner-freebsd-current@freebsd.org>
Delivered-To: freebsd-current@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 9C97FCF02A1
 for <freebsd-current@mailman.ysv.freebsd.org>;
 Mon, 27 Feb 2017 19:28:40 +0000 (UTC)
 (envelope-from bsd-lists@bsdforge.com)
Received: from udns.ultimatedns.net (static-24-113-41-81.wavecable.com
 [24.113.41.81])
 (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
 (Client did not present a certificate)
 by mx1.freebsd.org (Postfix) with ESMTPS id 7F2D9EBA
 for <freebsd-current@freebsd.org>; Mon, 27 Feb 2017 19:28:39 +0000 (UTC)
 (envelope-from bsd-lists@bsdforge.com)
Received: from ultimatedns.net (localhost [127.0.0.1])
 by udns.ultimatedns.net (8.14.9/8.14.9) with ESMTP id v1RJTseo022980
 for <freebsd-current@freebsd.org>; Mon, 27 Feb 2017 11:30:00 -0800 (PST)
 (envelope-from bsd-lists@bsdforge.com)
To: <freebsd-current@freebsd.org>
In-Reply-To: <977961980.1791329.1488200543673@mail.yahoo.com>
References: <977961980.1791329.1488200543673.ref@mail.yahoo.com>,
 <977961980.1791329.1488200543673@mail.yahoo.com>
From: "Chris H" <bsd-lists@bsdforge.com>
Subject: Re: Problem with pkg
Date: Mon, 27 Feb 2017 11:30:00 -0800
Content-Type: text/plain; charset=UTF-8; format=fixed
MIME-Version: 1.0
Message-id: <5c593f14409ce5e6e633e69bc6c44135@ultimatedns.net>
Content-Transfer-Encoding: 8bit
X-BeenThere: freebsd-current@freebsd.org
X-Mailman-Version: 2.1.23
Precedence: list
List-Id: Discussions about the use of FreeBSD-current
 <freebsd-current.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-current>, 
 <mailto:freebsd-current-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-current/>
List-Post: <mailto:freebsd-current@freebsd.org>
List-Help: <mailto:freebsd-current-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-current>, 
 <mailto:freebsd-current-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 27 Feb 2017 19:28:40 -0000

On Mon, 27 Feb 2017 13:02:23 +0000 (UTC) Filippo Moretti
<filippomore@yahoo.com> wrote

> After a blackout caused by my wife I only get a few pkg shown with the
> command pkg info while they should be hundreds.I also get this error message
> when trying to install packages by pkg installpkg: Repository FreeBSD load
> error: access repo file(/var/db/pkg/repo-FreeBSD.sqlite) failed: No such file
> or directory(I do have a file name local.sqlite)Is there a way to recover the
> pkg database or should I reinstall the OS.Filippo 
>
> 
perodic(8) creates them for you. As a rule, you should be able
to find a suitable backup copy in
/var/backups
in the form of pkgdb.bak.tbz*

Hope this helps!

--Chris