在Ubuntu上安装postgres软件包不可用

我正在用Ruby和Postgresbuild立一个VPS。在我的本地机器上，我安装了postgresql 9.2.3（客户机和服务器），因此想要在我的VPS上安装它。遵循这个博客文章的说明http://hendrelouw73.wordpress.com/2012/11/14/how-to-install-postgresql-9-1-on-ubuntu-12-10-linux/for在Ubuntu上安装postgres （唯一的区别是我试图安装9.2.3，他安装了9.1），我做了以下

sudo apt-get install postgresql-9.2.3 Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package postgresql-9.2.3 E: Couldn't find any package by regex 'postgresql-9.2.3'

但是，正如你所看到的，它找不到一个包postgresql-9.2.3 。然而，我已经在我的本地机器上安装了这个软件包（我用Homebrew在我的Mac上安装了这个软件包）。

你能帮我理解我做错了什么吗？

更新我也尝试安装它，离开'3'结束，就像你看到下面，但它不工作，你可以看到。

  sudo apt-get install postgresql-9.2 Reading package lists... Done Building dependency tree Reading state information... Done Package postgresql-9.2 is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package 'postgresql-9.2' has no installation candidate

更新

 Ign http://security.ubuntu.com quantal-security InRelease Ign http://archive.ubuntu.com quantal InRelease Hit http://security.ubuntu.com quantal-security Release.gpg Ign http://archive.ubuntu.com quantal-updates InRelease Hit http://security.ubuntu.com quantal-security Release Hit http://archive.ubuntu.com quantal Release.gpg Get:1 http://archive.ubuntu.com quantal-updates Release.gpg [933 B] Hit http://security.ubuntu.com quantal-security/main i386 Packages Hit http://archive.ubuntu.com quantal Release Get:2 http://archive.ubuntu.com quantal-updates Release [49.6 kB] Hit http://security.ubuntu.com quantal-security/main Translation-en Hit http://archive.ubuntu.com quantal/main i386 Packages Hit http://archive.ubuntu.com quantal/universe i386 Packages Ign http://security.ubuntu.com quantal-security/main Translation-en_US Hit http://archive.ubuntu.com quantal/main Translation-en Hit http://archive.ubuntu.com quantal/universe Translation-en Get:3 http://archive.ubuntu.com quantal-updates/main i386 Packages [259 kB] Get:4 http://archive.ubuntu.com quantal-updates/universe i386 Packages [192 kB] Hit http://archive.ubuntu.com quantal-updates/main Translation-en Hit http://archive.ubuntu.com quantal-updates/universe Translation-en Ign http://archive.ubuntu.com quantal/main Translation-en_US Ign http://archive.ubuntu.com quantal/universe Translation-en_US Ign http://archive.ubuntu.com quantal-updates/main Translation-en_US Ign http://archive.ubuntu.com quantal-updates/universe Translation-en_US Fetched 501 kB in 3s (148 kB/s) Reading package lists... Done postgresql-9.1 - object-relational SQL database, version 9.1 server postgresql-9.1-dbg - debug symbols for postgresql-9.1 postgresql-9.1-debversion - Debian version number type for PostgreSQL postgresql-9.1-ip4r - IPv4 and IPv4 range index types for PostgreSQL 9.1 postgresql-9.1-orafce - Oracle support functions for PostgreSQL 9.1 postgresql-9.1-pgfincore - set of PostgreSQL functions to manage blocks in memory postgresql-9.1-pgmemcache - PostgreSQL interface to memcached postgresql-9.1-pgmp - arbitrary precision integers and rationals for PostgreSQL 9.1 postgresql-9.1-pgpool2 - connection pool server and replication proxy for PostgreSQL - modules postgresql-9.1-pljava-gcj - Java procedural language for PostgreSQL 9.1 postgresql-9.1-pllua - Lua procedural language for PostgreSQL 9.1 postgresql-9.1-plproxy - database partitioning system for PostgreSQL 9.1 postgresql-9.1-plr - Procedural language interface between PostgreSQL and R postgresql-9.1-plsh - PL/sh procedural language for PostgreSQL 9.1 postgresql-9.1-postgis - Geographic objects support for PostgreSQL 9.1 postgresql-9.1-prefix - Prefix Range module for PostgreSQL postgresql-9.1-preprepare - Pre Prepare your Statement server side postgresql-9.1-slony1-2 - replication system for PostgreSQL: PostgreSQL 9.1 server plug-in

在Ubuntu官方仓库中，只有PostgreSQL 9.1可用。这就是为什么找不到。

为了在你的VPS中使用apt来获得PostgreSQL v9.2，你应该遵循官方PostgreSQL在这里find的Ubuntu程序

它包括添加PostgreSQL官方存储库作为您的存储库源之一

创build文件/etc/apt/sources.list.d/pgdg.list
插入这行deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
导入存储库签名密钥wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
刷新你的存储库cachingsudo apt-get update

现在你可以简单地执行sudo apt-get install postgresql-9.2

事实上，你能够在不同的操作系统上使用不同的仓库安装postgresql-9.2.3并不相关。

如果您使用Web或通过apt查询Ubuntu存储库，您会注意到quantal附带的版本是9.1。

postgresql-9.2.3在quantal中不可用的确切原因是因为它在被冻结的时候并没有被发布的发行版所接受。

要在Ubuntu中使用postgresql-9.2.3 ，你需要自己编译它。有几种方法可以实现这一点，比如使用checkinstall或fpm将backstream或者上游发行版本打包。