Re: The Wheezy i386 package index is broken @ apt.postgresql.org

Hi all,

I'm trying to install postgresql 8.4 on a i386 box

sudo apt-get install postgresql-8.4 postgresql-8.4-postgis-2.0
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libarmadillo3 libatk1.0-0 libatk1.0-data libdap11 libdapclient3
libdapserver7 libepsilon0 libfreexl1 libgdal1 libgeos-3.3.3 libgeos-c1
libgtk2.0-0 libgtk2.0-bin libgtk2.0-common libkml0 liblwgeom-2.0.3
liblwgeom-2.1.0 libspatialite3 postgis postgresql-8.4-postgis-2.0-scripts
postgresql-client-8.4
Suggested packages:
gvfs postgresql-9.3-postgis-2.1 oidentd ident-server postgresql-doc-8.4
The following NEW packages will be installed:
libarmadillo3 libatk1.0-0 libatk1.0-data libdap11 libdapclient3
libdapserver7 libepsilon0 libfreexl1 libgdal1 libgeos-3.3.3 libgeos-c1
libgtk2.0-0 libgtk2.0-bin libgtk2.0-common libkml0 liblwgeom-2.0.3
liblwgeom-2.1.0 libspatialite3 postgis postgresql-8.4
postgresql-8.4-postgis-2.0 postgresql-8.4-postgis-2.0-scripts
postgresql-client-8.4
0 upgraded, 23 newly installed, 0 to remove and 53 not upgraded.
Need to get 8,555 kB/24.6 MB of archives.
After this operation, 84.1 MB of additional disk space will be used.
Do you want to continue [Y/n]?
Err http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main
liblwgeom-2.1.0 i386 2.1.0-2.pgdg70+1
404 Not Found [IP: 213.189.17.228 80]
Err http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main postgis
i386 2.1.0-2.pgdg70+1
404 Not Found [IP: 213.189.17.228 80]
Err http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main
postgresql-client-8.4 i386 8.4.17-1.pgdg70+1
404 Not Found [IP: 213.189.17.228 80]
Err http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main
postgresql-8.4 i386 8.4.17-1.pgdg70+1
404 Not Found [IP: 213.189.17.228 80]
Failed to fetch
http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/liblwgeom-2.1.0_2.1.0-2.pgdg70+1_i386.deb
404 Not Found [IP: 213.189.17.228 80]
Failed to fetch
http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/postgis_2.1.0-2.pgdg70+1_i386.deb
404 Not Found [IP: 213.189.17.228 80]
Failed to fetch
http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-8.4/postgresql-client-8.4_8.4.17-1.pgdg70+1_i386.deb
404 Not Found [IP: 213.189.17.228 80]
Failed to fetch
http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-8.4/postgresql-8.4_8.4.17-1.pgdg70+1_i386.deb
404 Not Found [IP: 213.189.17.228 80]
E: Unable to fetch some archives, maybe run apt-get update or try with
--fix-missing?

It looks like the actual packages on the server are:
http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-8.4/

notice that these are *_8.4.19-1.* and not *_8.4.17-1.* like the index
is configured with.

Can someone fix this or give me a simple work-around?

Thanks,
-Steve

Hmmm, I just tried this again and now I am getting:

W: A error occurred during the signature verification. The repository is
not updated and the previous index files will be used. GPG error:
http://apt.postgresql.org wheezy-pgdg Release: The following signatures
were invalid: KEYEXPIRED 1381654177

W: Failed to fetch
http://apt.postgresql.org/pub/repos/apt/dists/wheezy-pgdg/Release

I have installed the key as described here:
https://wiki.postgresql.org/wiki/Apt

-Steve

On 1/10/2014 8:29 PM, Stephen Woodbridge wrote:
> Hi all,
>
> I'm trying to install postgresql 8.4 on a i386 box
>
> sudo apt-get install postgresql-8.4 postgresql-8.4-postgis-2.0
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> The following extra packages will be installed:
> libarmadillo3 libatk1.0-0 libatk1.0-data libdap11 libdapclient3
> libdapserver7 libepsilon0 libfreexl1 libgdal1 libgeos-3.3.3 libgeos-c1
> libgtk2.0-0 libgtk2.0-bin libgtk2.0-common libkml0 liblwgeom-2.0.3
> liblwgeom-2.1.0 libspatialite3 postgis
> postgresql-8.4-postgis-2.0-scripts
> postgresql-client-8.4
> Suggested packages:
> gvfs postgresql-9.3-postgis-2.1 oidentd ident-server postgresql-doc-8.4
> The following NEW packages will be installed:
> libarmadillo3 libatk1.0-0 libatk1.0-data libdap11 libdapclient3
> libdapserver7 libepsilon0 libfreexl1 libgdal1 libgeos-3.3.3 libgeos-c1
> libgtk2.0-0 libgtk2.0-bin libgtk2.0-common libkml0 liblwgeom-2.0.3
> liblwgeom-2.1.0 libspatialite3 postgis postgresql-8.4
> postgresql-8.4-postgis-2.0 postgresql-8.4-postgis-2.0-scripts
> postgresql-client-8.4
> 0 upgraded, 23 newly installed, 0 to remove and 53 not upgraded.
> Need to get 8,555 kB/24.6 MB of archives.
> After this operation, 84.1 MB of additional disk space will be used.
> Do you want to continue [Y/n]?
> Err http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main
> liblwgeom-2.1.0 i386 2.1.0-2.pgdg70+1
> 404 Not Found [IP: 213.189.17.228 80]
> Err http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main postgis
> i386 2.1.0-2.pgdg70+1
> 404 Not Found [IP: 213.189.17.228 80]
> Err http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main
> postgresql-client-8.4 i386 8.4.17-1.pgdg70+1
> 404 Not Found [IP: 213.189.17.228 80]
> Err http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg/main
> postgresql-8.4 i386 8.4.17-1.pgdg70+1
> 404 Not Found [IP: 213.189.17.228 80]
> Failed to fetch
> http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/liblwgeom-2.1.0_2.1.0-2.pgdg70+1_i386.deb
> 404 Not Found [IP: 213.189.17.228 80]
> Failed to fetch
> http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgis/postgis_2.1.0-2.pgdg70+1_i386.deb
> 404 Not Found [IP: 213.189.17.228 80]
> Failed to fetch
> http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-8.4/postgresql-client-8.4_8.4.17-1.pgdg70+1_i386.deb
> 404 Not Found [IP: 213.189.17.228 80]
> Failed to fetch
> http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-8.4/postgresql-8.4_8.4.17-1.pgdg70+1_i386.deb
> 404 Not Found [IP: 213.189.17.228 80]
> E: Unable to fetch some archives, maybe run apt-get update or try with
> --fix-missing?
>
> It looks like the actual packages on the server are:
> http://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-8.4/
>
> notice that these are *_8.4.19-1.* and not *_8.4.17-1.* like the index
> is configured with.
>
> Can someone fix this or give me a simple work-around?
>
> Thanks,
> -Steve
>
>

Re: Stephen Woodbridge 2014-01-11 <52D0D505(dot)6070804(at)swoodbridge(dot)com>
> Hmmm, I just tried this again and now I am getting:
>
> W: A error occurred during the signature verification. The
> repository is not updated and the previous index files will be used.
> GPG error: http://apt.postgresql.org wheezy-pgdg Release: The
> following signatures were invalid: KEYEXPIRED 1381654177
>
> W: Failed to fetch
> http://apt.postgresql.org/pub/repos/apt/dists/wheezy-pgdg/Release
>
> I have installed the key as described here:
> https://wiki.postgresql.org/wiki/Apt

Hi,

see http://www.postgresql.org/message-id/20131010083115.GC24812@msgid.df7cb.de

Is that a new setup, or does it predate the key renewal?

Christoph
--
cb(at)df7cb(dot)de | http://www.df7cb.de/

On 1/12/2014 6:48 AM, Christoph Berg wrote:
> Re: Stephen Woodbridge 2014-01-11 <52D0D505(dot)6070804(at)swoodbridge(dot)com>
>> Hmmm, I just tried this again and now I am getting:
>>
>> W: A error occurred during the signature verification. The
>> repository is not updated and the previous index files will be used.
>> GPG error: http://apt.postgresql.org wheezy-pgdg Release: The
>> following signatures were invalid: KEYEXPIRED 1381654177
>>
>> W: Failed to fetch
>> http://apt.postgresql.org/pub/repos/apt/dists/wheezy-pgdg/Release
>>
>> I have installed the key as described here:
>> https://wiki.postgresql.org/wiki/Apt
>
> Hi,
>
> see http://www.postgresql.org/message-id/20131010083115.GC24812@msgid.df7cb.de
>
> Is that a new setup, or does it predate the key renewal?
>
> Christoph
>

Christoph,

> If it is already past that date, and you get apt warnings about
> expired signatures, delete that file:
> # sudo rm /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg
> and run "apt-get update" again.

This solved the problem. Thank you for pointing it out.

-Steve