apt - Unable to install postgreSQL 9.6 in Ubuntu 18.04

相关文章推荐

纯真的熊猫 · 认知科学的危机：一场跨学科革命为什么会走向失 ...· 7 月前 ·

温文尔雅的橙子 · 6月份度蜜月去国外哪里好?六月蜜月旅游好去处 ...· 7 月前 ·

非常酷的手套 · 石黑一雄-全部作品在线阅读-微信读书· 9 月前 ·

玉树临风的黄瓜 · 東斯拉夫語- 知乎· 1 年前 ·

刚分手的鸡蛋 · 如何评价迪丽热巴在《新舞林大会》中的表现？ ...· 1 年前 ·

Stack Exchange network consists of 183 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. Visit Stack Exchange

Ask Ubuntu is a question and answer site for Ubuntu users and developers. It only takes a minute to sign up.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

I'm trying to install postgreSQL 9.6 in Ubuntu 18.04 via Ubuntu Software Centre and type from terminal

sudo apt-get install postgresql-9.6

according to official documentation https://www.postgresql.org/download/linux/ubuntu/

Create the file /etc/apt/sources.list.d/pgdg.list and add a line for the repository
  deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
Import the repository signing key, and update the package lists
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc |   sudo apt-key add -
sudo apt-get update
The version to be installaed is 10
Any help?
Thanks in advance.
postgresql:
Installed: (none)
  Candidate: 10+191.pgdg18.04+1
  Version table:
     10+191.pgdg18.04+1 500
        500 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64 Packages
        500 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main i386 Packages
     10+190 500
        500 http://gr.archive.ubuntu.com/ubuntu bionic/main amd64 Packages
        500 http://gr.archive.ubuntu.com/ubuntu bionic/main i386 Packages
If I check where are the postgresql folders, it seems that I have both versions, 9.6 and 10
/usr/lib/postgresql
                I don't think you can install version 9.6 from Ubuntu Software, so you need to add a repository. You have included the exact instructions to do so: 1) create a file containing one line of text, then 2) import a key using the wget command. What exactly goes wrong?
– Jos
                Jul 4, 2018 at 10:17
                @Jos after I typed sudo apt-cache policy postgresql, it appears the the response I've attached above
– webtechnelson
                Jul 4, 2018 at 10:36
                It seems that you have successfully installed version 9.6. Now it's a good idea to remove version 10 with sudo apt remove postgresql-10.
– Jos
                Jul 4, 2018 at 10:47
                @Jos I have removed postgres 10, following the command you suggest and then I ran sudo apt-get install postgresql-9.6, the folder 9.6 appears in /usr/lib/postgresql, however, when I type in terminal sudo apt-cache policy postgresql, it says there is no postgresql installed. postgresql:   Installed: (none)   Candidate: 10+191.pgdg18.04+1
– webtechnelson
                Jul 4, 2018 at 11:48
After few months I had to erase and install from scratch, so in order to install postgresql 9.6 I followed next steps:
Important notes: If you have already installed postgresql 10 and you want 9.6, you need to remove postgresql 10 completely and then manually install postgresql 9.6, so follow method 2.
Method 1
Step 1
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'  
Step 2
wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O - | sudo apt-key add - 
Step 3.
sudo apt-get update  
sudo apt-get upgrade 
sudo apt-get install postgresql-9.6 
Method 2
In order to install postgres 9.6 having already postgres 10 or other version different from 9.6 installed, you need first to uninstall postgresql (any version and file related) completely following the next steps.
sudo apt-get --purge remove postgresql
dpkg -l | grep postgres (to look for postgresfiles in the system)
sudo rm -rf postgresql ... (remove all the files that appeared in the list after running the previous command)
Finally install manually postgreSQL with the next command:
sudo apt-get install postgresql-9.6
I hope it can help somebody that could have the same problem.
Not completely the same in my case when trying to replace postgresql 10 with postgresql 9.4. 
I removed the old unwanted packages by 
dpkg -l | grep postgres | cut -d' ' -f3 | xargs sudo apt --purge remove -y
But while I am trying to remove the packages, I also encounter several issues, I terminate the process before it reaches the 100% and the following commands are used to fix the issues along the way. 
sudo lsof /var/lib/dpkg/lock-frontend
sudo kill -9 <PID>
sudo dpkg --configure -a
# if necessary, rerun the removing command above
And start the installation as:
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install -y postgresql-9.4

Stack Exchange Network