The PostgreSQL Development Team has announced the latest version PostgreSQL 11. PostgreSQL is an open source object-relational database system. It is one of the leading database server used for production servers. PostgreSQL allows us to execute stored procedures in various programming languages, like C/C++, Python, Java, Perl, Ruby, and its own PL/pgSQL, which is similar to Oracle’s PL/SQL. This tutorial will help you with installing PostgreSQL database server on your Ubuntu 18.04 LTS, Ubuntu 16.04 LTS, and 14.04 LTS systems.
- Recommended => Install pgAdmin4 on Ubuntu
Step 1 – Enable PostgreSQL Apt Repository
PostgreSQL packages are also available in default Ubuntu repository. So you need to add PostgreSQL apt repository to your system suggested on official PostgreSQL website using following command.
Start with the import of the GPG key for PostgreSQL packages.
sudo apt-get install wget ca-certificates wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
Now add the repository to your system.
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 – Install PostgreSQL on Ubuntu
Now as we have added PostgreSQL official repository in our system, First we need to update the repository list. After that install Latest PostgreSQL Server in our Ubuntu system using following commands.
sudo apt-get update sudo apt-get install postgresql postgresql-contrib
Multiple other dependencies will also be installed.
Step 3 – Connect to PostgreSQL
After installing the PostgreSQL database server, by default, it creates a user ‘postgres’ with role ‘postgres’. Also creates a system account with the same name ‘postgres’. So to connect to Postgres server, log in to your system as user postgres and connect database.
sudo su - postgres psql
Now you are logged in to PostgreSQL database server. To check login info use following command from the database command prompt.
postgres-# \conninfo
To disconnect from PostgreSQL database command prompt just type below command and press enter. It will return you back to the Ubuntu command prompt.
postgres-# \q
Your PostgreSQL installation has been completed successfully. Let’s move to install Graphical user interface for PostgreSQL like pgAdmin4 and phpPgAdmin of Ubuntu systems.
Is the ca-certificates package needed for PostgreSQL?
No, This is used by wget and Apt package manager for verification of 3’rd party packages.
Works fine for Ubuntu! Thanks!!
sudo sh -c ‘echo “deb http://apt.postgresql.org/pub/repos/apt/ `cat /etc/os-release | grep UBUNTU_CODENAME | sed s/UBUNTU_CODENAME=//`-pgdg main” > /etc/apt/sources.list.d/pgdg.list’
I get an apt error:
E: The repository ‘http://apt.postgresql.org/pub/repos/apt sylvia-pgdg Release’ does not have a Release file
Is there a way to fix this?
Hi. Do you use Mint? Please, run this:
[email protected]:/home/shmakovpn# cat /etc/os-release
NAME=”Linux Mint”
VERSION=”19 (Tara)”
ID=linuxmint
ID_LIKE=ubuntu
PRETTY_NAME=”Linux Mint 19″
VERSION_ID=”19″
HOME_URL=”https://www.linuxmint.com/”
SUPPORT_URL=”https://forums.ubuntu.com/”
BUG_REPORT_URL=”http://linuxmint-troubleshooting-guide.readthedocs.io/en/latest/”
PRIVACY_POLICY_URL=”https://www.linuxmint.com/”
VERSION_CODENAME=tara
UBUNTU_CODENAME=bionic
[email protected]:/home/shmakovpn#
Then run
[email protected]:/home/shmakovpn# lsb_release -cs
tara
— — —
Thus you should use UBUNTU_CODENAME instead of VERSION_CODENAME
—
Try this
cat /etc/os-release | grep UBUNTU_CODENAME | sed ‘s/UBUNTU_CODENAME=//’
bionic (in my case)
—–
So the solution is
sudo sh -c ‘echo “deb http://apt.postgresql.org/pub/repos/apt/ `cat /etc/os-release | grep UBUNTU_CODENAME | sed s/UBUNTU_CODENAME=//`-pgdg main” > /etc/apt/sources.list.d/pgdg.list’
Enjoy
Cool mate. This works on my 14.04. Thanks!
Thank you. However, as far as I know phpPgAdmin is not supporting PostgreSQL 10. Please take that into account.
Very clear and easy-to-follow tutorial here.
Thanks! You’re help me for make progress for my final project.
Awsome, worked like a charm.
It was breeze… I was able to install it in less than 2 minutes on my Ubuntu 16.04.
Many thanks!
We installed 9.6 but it did not get loaded completely or correctly. Learned that a few directories that should have had something in them were empty, more or less confirming that the install was incorrect. With your instructions we were able to get it loaded correctly.
Thanks!
Thanks very much for this tutorial
\conninfo and \q
Thanks 🙂
In newer versions of psql, you need to run
\conninfo
not
conninfo
🙂
Thank you for posting this tutorial.
I am running into issue while apt-get update. I see following two errors. I did try to follow bunch of links which mentioned about this but no luck so far.
Err http://apt.postgresql.org vivid-pgdg/main i386 Packages
404 Not Found [IP: 213.189.17.228 80]
W: Failed to fetch http://apt.postgresql.org/pub/repos/apt/dists/vivid-pgdg/main/binary-i386/Packages 404 Not Found [IP: 213.189.17.228 80]
Run smooth! Thanks
Thanks
I do all the steps but I need the graphic interface. When I search for “postgre” in my computer it seems that postgresql is not installed!
Instead, when I do all the last steps it seems that it is stalled, so I don’t understand anything:
[email protected]:~$ sudo su – postgres
[sudo] password for user:
[email protected]:~$ psql
psql (9.5.1)
Type “help” for help.
postgres=# conninfo
You are connected to database “postgres” as user “postgres” via socket in “/var/run/postgresql” at port “5432”.
postgres=#
How can I install the graphic interface?
Thank you!
You can install pgadmin3. If you are using ubuntu download pgadmin3 with sudo apt-get install pgadmin3 command
Thanks! It helps a lot!!
How to change password. what is the default / current password
sudo -u postgres psql
# \password
большое спасибо!
thank for this tutorial..