Re: list installed packages present only in stable

From	kamaraju kusumanchi <raju.mailinglists@gmail.com>
Newsgroups	linux.debian.user
Subject	Re: list installed packages present only in stable
Date	2016-11-03 03:20 +0100
Message-ID	<szfNf-65A-1@gated-at.bofh.it> (permalink)
References	<svBCG-bd-9@gated-at.bofh.it> <sz0Oe-4WT-11@gated-at.bofh.it>
Organization	linux.* mail to news gateway

Show all headers | View raw

On Wed, Nov 2, 2016 at 6:16 AM, Jonathan Dowland <jmtd@debian.org> wrote:
> On Sun, Oct 23, 2016 at 08:48:46PM -0400, kamaraju kusumanchi wrote:
>> How can I list all the packages installed on my system that are
>> currently part of the stable distribution but not present in either
>> testing or sid?
>
> This is a good question (sorry I don't have the answer here). I recently
> hit a similar situation with mediawiki, which exists in everything except
> stable. I realised that if you have upgraded between Debian versions at
> some point, you might have some packages installed from the former release
> (now oldstable) that are not in current release, and so you might not get
> security updates for those packages (once security updates cease for
> oldstable).
>
> In the case of mediawiki there is a version in jessie-backports, but default
> pining rules / apt preferences would not upgrade the package automatically in
> this situation.

Hi Jonathan,

Not sure if you read the entire thread, I ended up writing a script to
do this now. So, if you want to see packages that are currently
installed on your system but not part of jessie, you can do the
following.

Step 1: Update the cache
 % grep_installed.py --exclude-dists 'jessie' --update-cache
Processed: http://httpredir.debian.org/debian/dists/jessie/main/binary-amd64/Packages.gz
Processed: http://httpredir.debian.org/debian/dists/jessie/contrib/binary-amd64/Packages.gz
Processed: http://httpredir.debian.org/debian/dists/jessie/non-free/binary-amd64/Packages.gz
writing: /home/rajulocal/.cache/grep_insalled/jessie.gz

Step 2: Query the cache on the list of installed packages
 % dpkg -l  | grep '^ii' | awk '{print $2}' | grep_installed.py
--exclude-dists 'jessie'

Could you give it a try and let me know what you think?
The script can be downloaded from
https://gitlab.com/d3k2mk7/rutils/blob/master/bin/grep_installed.py .
Running it with -h option gives the set of options and some sample
commands.

thanks
raju
-- 
Kamaraju S Kusumanchi | http://raju.shoutwiki.com/wiki/Blog

Thread

list installed packages present only in stable kamaraju kusumanchi <raju.mailinglists@gmail.com> - 2016-10-24 02:50 +0200
  Re: list installed packages present only in stable Cindy-Sue Causey <butterflybytes@gmail.com> - 2016-10-25 17:30 +0200
    Re: list installed packages present only in stable Michael Lange <klappnase@freenet.de> - 2016-10-25 20:00 +0200
      Re: list installed packages present only in stable kamaraju kusumanchi <raju.mailinglists@gmail.com> - 2016-10-26 05:40 +0200
        Re: list installed packages present only in stable Michael Lange <klappnase@freenet.de> - 2016-10-26 11:20 +0200
          Re: list installed packages present only in stable kamaraju kusumanchi <raju.mailinglists@gmail.com> - 2016-10-26 14:20 +0200
            Re: list installed packages present only in stable Frank <zuiderduin@gmx.com> - 2016-10-26 18:00 +0200
            Re: list installed packages present only in stable Michael Lange <klappnase@freenet.de> - 2016-10-26 18:40 +0200
  Re: list installed packages present only in stable Rick Thomas <rbthomas@pobox.com> - 2016-10-29 18:40 +0200
  Re: list installed packages present only in stable kamaraju kusumanchi <raju.mailinglists@gmail.com> - 2016-11-01 07:20 +0100
  Re: list installed packages present only in stable Jonathan Dowland <jmtd@debian.org> - 2016-11-02 11:20 +0100
    Re: list installed packages present only in stable kamaraju kusumanchi <raju.mailinglists@gmail.com> - 2016-11-03 03:20 +0100
      Re: list installed packages present only in stable Jonathan Dowland <jmtd@debian.org> - 2016-11-03 14:10 +0100
        Re: list installed packages present only in stable kamaraju kusumanchi <raju.mailinglists@gmail.com> - 2016-11-04 02:10 +0100
          Re: list installed packages present only in stable Jörg-Volker Peetz <jvpeetz@web.de> - 2016-11-04 14:50 +0100
            Re: list installed packages present only in stable Jörg-Volker Peetz <jvpeetz@web.de> - 2016-11-04 17:20 +0100
              Re: list installed packages present only in stable Jörg-Volker Peetz <jvpeetz@web.de> - 2016-11-04 19:00 +0100
  Re: list installed packages present only in stable steve <dlist@bluewin.ch> - 2016-11-02 11:50 +0100
    Re: list installed packages present only in stable kamaraju kusumanchi <raju.mailinglists@gmail.com> - 2016-11-03 03:30 +0100
      Re: list installed packages present only in stable steve <dlist@bluewin.ch> - 2016-11-03 08:40 +0100
        Re: list installed packages present only in stable Mark Fletcher <mark27q1@gmail.com> - 2016-11-03 10:50 +0100
          Re: list installed packages present only in stable steve <dlist@bluewin.ch> - 2016-11-03 11:00 +0100
            Re: list installed packages present only in stable <tomas@tuxteam.de> - 2016-11-03 12:50 +0100
              Re: list installed packages present only in stable <tomas@tuxteam.de> - 2016-11-03 14:00 +0100
                Re: list installed packages present only in stable steve <dlist@bluewin.ch> - 2016-11-03 14:30 +0100
                Re: list installed packages present only in stable <tomas@tuxteam.de> - 2016-11-03 14:50 +0100
                Re: list installed packages present only in stable steve <dlist@bluewin.ch> - 2016-11-03 15:10 +0100
                Re: list installed packages present only in stable David Wright <deblis@lionunicorn.co.uk> - 2016-11-03 15:20 +0100
                Re: list installed packages present only in stable steve <dlist@bluewin.ch> - 2016-11-03 15:50 +0100
                Re: list installed packages present only in stable <tomas@tuxteam.de> - 2016-11-03 16:40 +0100
              Re: list installed packages present only in stable steve <dlist@bluewin.ch> - 2016-11-03 14:00 +0100
            Re: list installed packages present only in stable Mark Fletcher <mark27q1@gmail.com> - 2016-11-03 23:50 +0100

csiph-web