linux - 如何修复 Debian Lenny 中的 apt-get 更新以便可以安装 PostgreSql 9.1

Question

我试过了

apt-get update

在 Debian Lenny 上，但出现以下错误。如何解决此问题以便可以安装 PostgreSql 9.1？

root:~# apt-get update
Ign http://security.debian.org etch/updates Release.gpg
Get:1 http://archive.debian.org Debian-4.0 Release.gpg [1033B]
Get:2 http://archive.debian.org etch-backports Release.gpg [189B]
Ign http://security.debian.org etch/updates Release
Hit http://archive.debian.org Debian-4.0 Release
Ign http://security.debian.org etch/updates/main Packages/DiffIndex
Ign http://security.debian.org etch/updates/main Sources/DiffIndex
Hit http://archive.debian.org etch-backports Release
Ign http://security.debian.org etch/updates/main Packages
Ign http://archive.debian.org Debian-4.0/main Packages/DiffIndex
Ign http://archive.debian.org Debian-4.0/contrib Packages/DiffIndex
Ign http://archive.debian.org Debian-4.0/non-free Packages/DiffIndex
Ign http://security.debian.org etch/updates/main Sources
Get:3 http://archive.debian.org etch-backports Release [72,9kB]
Err http://security.debian.org etch/updates/main Packages
  404 Not Found [IP: 212.211.132.250 80]
Err http://security.debian.org etch/updates/main Sources
  404 Not Found [IP: 212.211.132.250 80]
Hit http://archive.debian.org Debian-4.0/main Packages
Hit http://archive.debian.org Debian-4.0/contrib Packages
Ign http://archive.debian.org etch-backports Release
Hit http://archive.debian.org Debian-4.0/non-free Packages
Ign http://archive.debian.org etch-backports/main Packages/DiffIndex
Ign http://archive.debian.org etch-backports/contrib Packages/DiffIndex
Ign http://archive.debian.org etch-backports/non-free Packages/DiffIndex
Hit http://archive.debian.org etch-backports/main Packages
Hit http://archive.debian.org etch-backports/contrib Packages
Hit http://archive.debian.org etch-backports/non-free Packages
Fetched 73,1kB in 0s (90,3kB/s)
Failed to fetch http://security.debian.org/dists/etch/updates/main/binary-amd64/Packages.gz  404 Not Found [IP: 212.211.132.250 80]
Failed to fetch http://security.debian.org/dists/etch/updates/main/source/Sources.gz  404 Not Found [IP: 212.211.132.250 80]
Reading package lists... Done
W: There is no public key available for the following key IDs:
9AA38DCD55BE302B
W: Conflicting distribution: http://archive.debian.org Debian-4.0 Release (expected Debian-4.0 but got etch)
W: GPG error: http://archive.debian.org etch-backports Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY EA8E8B2116BA136C
W: You may want to run apt-get update to correct these problems
E: Some index files failed to download, they have been ignored, or old ones used instead.

sources.list 包含:

deb http://archive.debian.org/debian Debian-4.0 main contrib non-free
deb http://security.debian.org/ etch/updates main
deb-src http://security.debian.org/ etch/updates main
deb http://archive.debian.org/debian-backports etch-backports main contrib non-free

Answer 1

看起来你在 lenny 发行版中有 etch repos，那么为什么不用 lenny repos 更新你的 source.list:

###### Debian Main Repos
deb http://ftp.us.debian.org/debian/ lenny main contrib non-free 

###### Debian Update Repos
deb http://security.debian.org/ lenny/updates main contrib non-free 
deb http://ftp.us.debian.org/debian/ lenny-proposed-updates main contrib non-free

这可能会解决问题，但 postgresql 9.1 仅在测试发行版中可用，因此您可以尝试添加此行

deb http://ftp.us.debian.org/debian testing main contrib non-free

在文件/etc/apt/source.list 中

另加

Package: *
Pin: release n=testing
Pin-Priority: 500

在/etc/apt/preferences 中

这样做你将拥有测试版本的所有包，但除非你指定它们不会被安装，所以运行

apt-get update
apt-get install <package name>=<version>

例如

apt-get install postgresql=9.1+129

你可以检查不同的版本

apt-cache showpkg postgresql