install postgreSQL in ubuntu 16.04


When following the Install PostgreSQL in Ubuntu in Ubuntu 16.04, got error as below:
 
$ apt-get install postgresql-9.6
Reading package lists... Done
Building dependency tree       
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 adobereader-enu:i386 : Depends: libgtk2.0-0:i386 (>= 2.4) but it is not going to be installed
 postgresql-9.6 : Depends: postgresql-client-9.6
                  Depends: postgresql-common (>= 171~) but it is not going to be installed
                  Recommends: postgresql-contrib-9.6 but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
The suggested solution in the last line and a normal ubuntu upgrade do not solve the issue,  and the cmd below can fix it:
$sudo apt full-upgrade
After the fix, then can apt-get to install postgresql again. After install postgresql, then run cmd below to test it. A  user named postgres will be created automatically when install postgresql. Switch to this account first,
$sudo -i -u postgres
Now you can enter psql client:
$psql
postgres=#\q
Then you can login to the other postgresql database as below:
psql -h server -U user -d databasename -p port

Comments

  1. This comment has been removed by the author.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.


    rpa training in chennai | best rpa training in chennai | rpa training in chennai | rpa training in bangalore
    rpa training in pune | rpa online training

    ReplyDelete
  5. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

    java training in chennai | java training in bangalore


    java training in tambaram | java training in velachery

    ReplyDelete
  6. Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
    Best Devops Training in pune

    ReplyDelete
  7. This comment has been removed by the author.

    ReplyDelete
  8. https://k2incenseonlineheadshop.com/
    info@k2incenseonlineheadshop.com
    k2incenseonlineheadshop Buy liquid incense cheap Buy liquid incense cheap For Sale At The Best Incense Online Shop

    ReplyDelete


  9. http://buydocumentation.com/

    Buy Driver’s License online, US driver license, drivers license renewal ca WhatsApp +1 (925) 526-5453


    Here at Buy Documentation, you can buy fake documents at a fraction of a cost. We keep our prices low to meet the needs of all our customers. We provide Best Quality Novelty Real and Fake IDs and Passport, Marriage Certificates and Drivers license online

    https://buydocumentation.com/canada-visa/

    https://buydocumentation.com/buy-real-drivers-license/

    https://buydocumentation.com/buy-real-id-cards/

    https://buydocumentation.com/social-security-number-ssn/

    ReplyDelete
  10. The following time I read a blog, I trust that it doesn't bomb me similarly as much as this specific one. That is to say, I realize it was my decision to peruse, regardless I really trusted you would presumably have something valuable to discuss. All I hear is a lot of crying about something you could fix on the off chance that you were not very bustling searching for consideration. best interiors

    ReplyDelete
  11. Thanks for sharing this information. I really like your blog post very much. You have really shared a informative and interesting blog post .
    data analytics courses in hyderabad with placements

    ReplyDelete
  12. Very educating story, saved your site for hopes to read more! data science course in kanpur

    ReplyDelete

Post a Comment

Popular posts from this blog

timestamp with 16, 13 and 10 digits to Qlik date

install ipython in Cloudera VM using pip