From owner-freebsd-current@freebsd.org  Mon Feb 27 19:31:45 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 8CC68CF0367
 for <freebsd-current@mailman.ysv.freebsd.org>;
 Mon, 27 Feb 2017 19:31:45 +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 5016F636
 for <freebsd-current@freebsd.org>; Mon, 27 Feb 2017 19:31:44 +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 v1RJX5wX023450
 for <freebsd-current@freebsd.org>; Mon, 27 Feb 2017 11:33:11 -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:33:11 -0800
Content-Type: text/plain; charset=UTF-8; format=fixed
MIME-Version: 1.0
Message-id: <7f145d4875dad1842e77cde9cb3c9469@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:31:45 -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 

OH! forgot to mention:

pkg.sql.xz.*

also located in /var/backups

--Chris