Sarathlal N

Install PostgreSQL 11 on Debian 10 (Buster)

Setup PostgreSQL PPA

First, import PostgreSQL packages signing key on our system.

wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O - | sudo apt-key add -

Now add PostgreSQL apt repository.

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'

Install PostgreSQL

Update the repository list & install PostgreSQL.

sudo apt-get update
sudo apt-get install postgresql postgresql-contrib

Turn on PostgreSQL server

sudo systemctl start postgresql

Login to PostgreSQL CLI as user postgres

After installing the PostgreSQL database server by default, it creates a user ‘postgres’ with the role ‘postgres’. It also creates a system account with the same name ‘postgres’.

So now login to our system as user postgres and connect the database.

sudo -u postgres psql

To exit from PostgreSQL database CLI interface, use the below command.

\q

Looking for a skilled WordPress/WooCommerce developer? I'm currently available for freelance, contract, or full-time remote opportunities! Let's create something amazing together. Send me a quick message, and I'll respond within 24 hours!

Recent Posts

  1. REST API Methods Explained with Best Practices for Building Clean and Secure APIs
  2. My 28-Day Plan to Master Modern WordPress Development Using AI Tools
  3. Scaling WordPress - How Custom Database Tables Solve the Post Meta Bottleneck
  4. WordPress Transients Explained - A Developer's Guide to Site Performance
  5. Behind the Click - The Hidden Journey of Your Web Requests

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.