Skip site navigation (1)Skip section navigation (2) 
Date:      Sat, 3 Sep 2022 09:38:47 -0700
From:      paul beard <paulbeard@gmail.com>
To:        Kevin Oberman <rkoberman@gmail.com>
Cc:        Graham Perrin <grahamperrin@freebsd.org>, questions@freebsd.org
Subject:   Re: pkgdb question
Message-ID:  <CAMtcK2pEXwNUoNKsYWLo=gtHtU6Tv3OByZuMfcgQhpZLc2NUeg@mail.gmail.com>
In-Reply-To: <CAN6yY1teeqfpfgN4zpNJmYftb%2B%2B_4qAvR_t-RyQ=j5BMqyQG8A@mail.gmail.com>
References:  <CAMtcK2p%2BroY87MO_ENKeyAWk90hMX=JGHCmj1eoHscto9w1LPw@mail.gmail.com> <9e1c8c23-3c6b-a395-b002-8af3267e73f9@freebsd.org> <CAN6yY1teeqfpfgN4zpNJmYftb%2B%2B_4qAvR_t-RyQ=j5BMqyQG8A@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help 
--000000000000aed59905e7c87bae
Content-Type: text/plain; charset="UTF-8"

I managed to get what I wanted by mounting the /var /partition of my
damaged disk image and running pkg query %o. I'll put that on the cron as
soon as all this rebuilding is done.

Finding out the many ways my backup or disaster mitigation strategies have
failed has been instructive.

On Sat, Sep 3, 2022 at 9:33 AM Kevin Oberman <rkoberman@gmail.com> wrote:

> On Sat, Sep 3, 2022 at 9:19 AM Graham Perrin <grahamperrin@freebsd.org>
> wrote:
>
>> On 02/09/2022 23:57, paul beard wrote:
>>
>> list of ports, preferably w origins,
>>
>> pkg prime-origins | sort
>>
>
> Or, if you need name and origin, use sqlite3:
> sqlite3 local.sqlite "select name, origin from packages"
>
> --
> Kevin Oberman, Part time kid herder and retired Network Engineer
> E-mail: rkoberman@gmail.com
> PGP Fingerprint: D03FB98AFA78E3B78C1694B318AB39EF1B055683
>


-- 
Paul Beard / www.paulbeard.org/

--000000000000aed59905e7c87bae
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I managed to get what I wanted by mounting the /var /parti=
tion of my damaged disk image and running pkg query %o. I&#39;ll put that o=
n the cron as soon as all this rebuilding is done.=C2=A0<div><br></div><div=
>Finding out the many ways my backup or disaster mitigation strategies have=
 failed has been instructive.=C2=A0</div></div><br><div class=3D"gmail_quot=
e"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Sep 3, 2022 at 9:33 AM Kev=
in Oberman &lt;<a href=3D"mailto:rkoberman@gmail.com">rkoberman@gmail.com</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-c=
olor:rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><=
div class=3D"gmail_default" style=3D"font-family:tahoma,sans-serif;font-siz=
e:small">On Sat, Sep 3, 2022 at 9:19 AM Graham Perrin &lt;<a href=3D"mailto=
:grahamperrin@freebsd.org" target=3D"_blank">grahamperrin@freebsd.org</a>&g=
t; wrote:<br></div></div><div class=3D"gmail_quote"><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-l=
eft-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
 =20
   =20
 =20
  <div>
    <div>On 02/09/2022 23:57, paul beard wrote:<br>
    </div>
    <blockquote type=3D"cite">
      list of ports, preferably w origins, </blockquote>
    <p><span style=3D"font-family:monospace"><span style=3D"color:rgb(0,0,0=
);background-color:rgb(255,255,255)">pkg
          prime-origins | sort</span><br></span></p></div></blockquote><div=
><br></div><div style=3D"font-family:tahoma,sans-serif;font-size:small" cla=
ss=3D"gmail_default">Or, if you need name and origin, use sqlite3:</div><di=
v style=3D"font-family:tahoma,sans-serif;font-size:small" class=3D"gmail_de=
fault">sqlite3 local.sqlite &quot;select name, origin from packages&quot;</=
div></div><div style=3D"font-family:tahoma,sans-serif;font-size:small" clas=
s=3D"gmail_default"> <br></div>-- <br><div dir=3D"ltr"><div dir=3D"ltr"><di=
v><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr">Kevin Oberma=
n, Part time kid herder and retired Network Engineer<br>E-mail: <a href=3D"=
mailto:rkoberman@gmail.com" target=3D"_blank">rkoberman@gmail.com</a><br></=
div><div>PGP Fingerprint: D03FB98AFA78E3B78C1694B318AB39EF1B055683</div></d=
iv></div></div></div></div></div></div></div>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
 class=3D"gmail_signature">Paul Beard / <a href=3D"http://www.paulbeard.org=
/" target=3D"_blank">www.paulbeard.org/</a><br></div>

--000000000000aed59905e7c87bae--

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