How To Install and Use PostgreSQL on Ubuntu 18.04

Thanks. Useful article

Hello guys can you add how to set up the postgres to allow authorized user to connect from postgres clients such as pgadmin . inshort allow remote access. because once we have access then its easy to manage database . then you dont always need the sql cmds . also we can directly connect our apps

Thank you very much! The post was really helpful.

@mdrake Thanks for the detailed step by step guide, I hope it will help many and really appreciate that DigitalOcean takes serious efforts for requests. cheers.

After this line sudo adduser sammy it ask me for Postgres password. What password is expected? Anything I add at this line it says “Sorry try again” and after three attends it says sudo: 3 incorrect password attempts

I don’t know my postgresql password install i can not connection it

Hi, following this tutorial I created a video tutorial and posted it on YouTube. I entered the configuration part also for PostGIS. The video is in Italian, but the English subtitles work discreetly https://youtu.be/NvM09ken26o

Hello, I am trying to deploy my rails app on digital ocean. and am following this article https://gorails.com/deploy/ubuntu/18.04 but when i am trying to run this command sudo apt-get install postgresql postgresql-contrib libpq-dev it is showing the following errors.

Building dependency tree 
Reading state information... Done
libpq-dev is already the newest version (11.2-1.pgdg16.04+1).
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 postgresql : Depends: postgresql-11 but it is not going to be installed
 postgresql-contrib : Depends: postgresql-contrib-11
E: Unable to correct problems, you have held broken packages.```

What is the problem an what should i do.

[I am workign with my new user, not in root user]

Thank you

Hi, I ran into a bundle install issue where I couldn’t install my PG gem.

I had to run “sudo apt-get install libpq-dev” to get the right packages. Hope this helps anyone that may be stuck on installing the pg gem.

Hey guys. This tutorial does not describe how to add postgres user to the sudoers file. It seems it should be added right before the ‘Accessing a Postgres Prompt Without Switching Accounts’ section as I was unable to do this step or beyond. Thanks!