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. Understanding the Singleton Pattern and Using Traits to Achieve Singleton in WordPress Plugin Development
  2. REST API Methods Explained with Best Practices for Building Clean and Secure APIs
  3. My 28-Day Plan to Master Modern WordPress Development Using AI Tools
  4. Scaling WordPress - How Custom Database Tables Solve the Post Meta Bottleneck
  5. WordPress Transients Explained - A Developer's Guide to Site Performance

Your Questions / Comments

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