From owner-freebsd-stable@FreeBSD.ORG  Wed Sep  4 17:43:53 2013
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
Delivered-To: freebsd-stable@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by hub.freebsd.org (Postfix) with ESMTP id 6C409484
 for <freebsd-stable@freebsd.org>; Wed,  4 Sep 2013 17:43:53 +0000 (UTC)
 (envelope-from fjwcash@gmail.com)
Received: from mail-qa0-x233.google.com (mail-qa0-x233.google.com
 [IPv6:2607:f8b0:400d:c00::233])
 (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits))
 (No client certificate requested)
 by mx1.freebsd.org (Postfix) with ESMTPS id 2F7D926D0
 for <freebsd-stable@freebsd.org>; Wed,  4 Sep 2013 17:43:53 +0000 (UTC)
Received: by mail-qa0-f51.google.com with SMTP id bv4so368257qab.17
 for <freebsd-stable@freebsd.org>; Wed, 04 Sep 2013 10:43:52 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:in-reply-to:references:date:message-id:subject:from:to
 :cc:content-type;
 bh=g9SrLHhFIgg4C/LHeQLPY2DpaXlaEEMjua3TZ8FatMY=;
 b=QLAsI3GziJzqeXAhgkei7opeE5Q+ega+0mIF03p9mJ5pmNJtAYwiSSS0eCljgAg3K1
 d2JWlUneZ0r2daJpbjGywXhx/iomSuncXFcAv2JuAFHnrqXOqQ2z/6EoX8yYlYyg8NXi
 eCNr3Wmgc7iRh6/vbSgfs9qmyHMaBybKwjgRuBRoOp7q6b1SQUOvMRqDROlzgdiYL4Cl
 wIFM5xhIRiqUCDe7lmRdCxvHzjU2buiKqoJaI68yiWMtKSyjuLYZkA5EYXjccGeTOULj
 pE8duij94spPaKxZpUSuKNGsV6V/877MgGp1lQicDuPJ94q60LUkd7TroX6XbrBxiq7q
 JmLw==
MIME-Version: 1.0
X-Received: by 10.224.35.196 with SMTP id q4mr2753397qad.106.1378316632362;
 Wed, 04 Sep 2013 10:43:52 -0700 (PDT)
Received: by 10.49.39.33 with HTTP; Wed, 4 Sep 2013 10:43:52 -0700 (PDT)
In-Reply-To: <CADcmFMXNFke=pH8264+yNXA3_vhMy8m_7sPrHb1N6eRfVd=Vdw@mail.gmail.com>
References: <CADcmFMXNFke=pH8264+yNXA3_vhMy8m_7sPrHb1N6eRfVd=Vdw@mail.gmail.com>
Date: Wed, 4 Sep 2013 10:43:52 -0700
Message-ID: <CAOjFWZ7LeNwH=6-QODVqBRbL-T52b+H_kbpdE5UctLH2WNXOZw@mail.gmail.com>
Subject: Re: Package database
From: Freddie Cash <fjwcash@gmail.com>
To: Jim Ballantine <j.ballantine@gmail.com>
Content-Type: text/plain; charset=UTF-8
X-Content-Filtered-By: Mailman/MimeDel 2.1.14
Cc: FreeBSD Stable <freebsd-stable@freebsd.org>
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-stable>,
 <mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
 <mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 04 Sep 2013 17:43:53 -0000

On Wed, Sep 4, 2013 at 10:41 AM, Jim Ballantine <j.ballantine@gmail.com>wrote:

> My /var/db/pkg has become corrupt, and I can't find an archive of it to
> install in it's place.  Does one exist and if so where?  If not any ideas
> on
> how to rebuild the db?
>

Are you using PKGng or the old pkg_* tools?

Meaning, is your data stored as individual files under
/var/db/pkg/PORTNAME/*, or as a single sqlite database under /var/db/pkg?

If using PKGng, there's a backup copy under /var/db/backup*

If using the older pkg_* tools, you're screwed.  :)


-- 
Freddie Cash
fjwcash@gmail.com