Как установить postgresql 9.1 на человечности 12.04 путем добавления репозитория?

Я установил использование postgresql

sudo apt-get install postgresql-9.1 postgresql-9.1-contrib postgresql-9.1-postgis

затем из-за некоторых причин я должен удалить postgresql от своей системы. И удаленное использование:

sudo /etc/init.d/postgresql stop
sudo apt-get --purge remove postgresql\*
sudo rm -r /etc/postgresql/
sudo rm -r /etc/postgresql-common/
sudo rm -r /var/lib/postgresql/
userdel -r postgres
sudo userdel -r postgres
sudo groupdel postgres

Теперь я хочу установить ту же версию снова, но нет никакого найденного репозитория. Как я мог добавить repo и установку?

кошка/etc/apt/sources.list дает:

# deb cdrom:[Ubuntu 12.04.2 LTS _Precise Pangolin_ - Release i386 (20130213)]/ precise main restricted

# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.
deb http://in.archive.ubuntu.com/ubuntu/ precise main restricted
deb-src http://in.archive.ubuntu.com/ubuntu/ precise main restricted

## Major bug fix updates produced after the final release of the
## distribution.
deb http://in.archive.ubuntu.com/ubuntu/ precise-updates main restricted
deb-src http://in.archive.ubuntu.com/ubuntu/ precise-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team. Also, please note that software in universe WILL NOT receive any
## review or updates from the Ubuntu security team.
deb http://in.archive.ubuntu.com/ubuntu/ precise universe
deb-src http://in.archive.ubuntu.com/ubuntu/ precise universe
deb http://in.archive.ubuntu.com/ubuntu/ precise-updates universe
deb-src http://in.archive.ubuntu.com/ubuntu/ precise-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu 
## team, and may not be under a free licence. Please satisfy yourself as to 
## your rights to use the software. Also, please note that software in 
## multiverse WILL NOT receive any review or updates from the Ubuntu
## security team.
deb http://in.archive.ubuntu.com/ubuntu/ precise multiverse
deb-src http://in.archive.ubuntu.com/ubuntu/ precise multiverse
deb http://in.archive.ubuntu.com/ubuntu/ precise-updates multiverse
deb-src http://in.archive.ubuntu.com/ubuntu/ precise-updates multiverse

## N.B. software from this repository may not have been tested as
## extensively as that contained in the main release, although it includes
## newer versions of some applications which may provide useful features.
## Also, please note that software in backports WILL NOT receive any review
## or updates from the Ubuntu security team.
deb http://in.archive.ubuntu.com/ubuntu/ precise-backports main restricted universe multiverse
deb-src http://in.archive.ubuntu.com/ubuntu/ precise-backports main restricted universe multiverse

# deb http://security.ubuntu.com/ubuntu precise-security main restricted
# deb-src http://security.ubuntu.com/ubuntu precise-security main restricted
# deb http://security.ubuntu.com/ubuntu precise-security universe
# deb-src http://security.ubuntu.com/ubuntu precise-security universe
# deb http://security.ubuntu.com/ubuntu precise-security multiverse
# deb-src http://security.ubuntu.com/ubuntu precise-security multiverse

## Uncomment the following two lines to add software from Canonical's
## 'partner' repository.
## This software is not part of Ubuntu, but is offered by Canonical and the
## respective vendors as a service to Ubuntu users.
# deb http://archive.canonical.com/ubuntu precise partner
# deb-src http://archive.canonical.com/ubuntu precise partner

## This software is not part of Ubuntu, but is offered by third-party
## developers who want to ship their latest software.
# deb http://extras.ubuntu.com/ubuntu precise main
# deb-src http://extras.ubuntu.com/ubuntu precise main
deb http://cz.archive.ubuntu.com/ubuntu precise main
# deb http://qgis.org/debian precise main
# deb-src http://qgis.org/debian precise main
deb http://in.archive.ubuntu.com/ubuntu/ precise-proposed restricted main multiverse universe

И политика способного кэша postgresql дает:

N: Unable to locate package postgresql

склонные sudo - получают обновление:

Get:1 http://archive.canonical.com precise Release.gpg [2,839 B]
Get:2 http://extras.ubuntu.com precise Release.gpg [2,829 B]                                                    
Get:3 http://in.archive.ubuntu.com precise Release.gpg [2,839 B]                                                
Get:4 http://archive.canonical.com precise Release [2,835 B]                                                    
Get:5 http://in.archive.ubuntu.com precise-updates Release.gpg [2,847 B]                                        
Get:6 http://in.archive.ubuntu.com precise-backports Release.gpg [2,849 B]                                      
Get:7 http://extras.ubuntu.com precise Release [2,825 B]                                                        
Get:8 http://ppa.launchpad.net precise Release.gpg [2,856 B]                                                    
Get:9 http://ppa.launchpad.net precise Release.gpg [2,865 B]                                                    
Get:10 http://ppa.launchpad.net precise Release.gpg [2,848 B]                                                   
Get:11 http://in.archive.ubuntu.com precise-proposed Release.gpg [2,848 B]                                      
Ign http://archive.canonical.com precise Release                                                                
E: GPG error: http://archive.canonical.com precise Release: The following signatures were invalid: NODATA 1 NODATA 2
0
задан 17 March 2017 в 21:43

1 ответ

Можно использовать Репозиторий Кв. PostgreSQL. PostgreSQL способный репозиторий поддерживает версии LTS Ubuntu (12.04, 14.04 и 16.04) на amd64 и i386 архитектуре. Для использования способного репозитория

  1. Создают файл /etc/apt/sources.list.d/pgdg.list и добавляют строку для репозитория:

    deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
    
  2. Импорт ключ подписи репозитория и обновление списки пакета:

    wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
    sudo apt-get update
    
-1
ответ дан 3 November 2019 в 15:00

Другие вопросы по тегам:

Похожие вопросы: