How to install Postgresql on PopOS or any Ubuntu-based linux distribution

PublishedMay 13, 2024

•1 min read

I'm a passionate software developer.

Install postgresql

sudo apt install postgresql libpq-dev

Check installation

psql --version
which psql
psql --help

Output

Check Postgresql configuration

pg_config

Output

Check Postgresql service

sudo service postgrtesql status

Output

Connect to Postgresql

sudo -u postgres psql

Output

Done

Celebrate

The It Crowd Birthday GIFs | Tenor

Reach me out

Final thoughts

Thank you for reading this article.

If you have any questions, thoughts, suggestions,or corrections, please share them with us.

We appreciate your feedback and look forward to hearing from you.

Feel free to suggest topics for future blog articles.Until next time!

#databases #postgresql #alexandrecalaca #popos #ubuntu

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

Introduction to React Props

Components Introduction In order to truly understand props in React, we first need to be clear on what components are. A component is a reusable piece of the user interface that encapsulates structure, styling, and behavior. Instead of repeating the ...

Oct 4, 20254 min read

From Github Codespaces to Repository: Step-by-Step Setup

Introduction Context By default, Codespace is using the GITHUB_TOKEN env var (the “Codespaces token”), which can’t create repos. It’s necessary to authenticate gh with a token/account that has the right scopes, or create the repo on the web first. Ob...

Sep 28, 20252 min read

From Github Codespaces to Repository: Step-by-Step Setup

How to create a Git commit without a message?

Solution Here it is: git commit --allow-empty-message -m "" Explanation To create a Git commit without a message, or with an empty message, you can use the --allow-empty-message flag with the git commit command. git commit --allow-empty-message -m "...

Sep 25, 20251 min read

How to create a Git commit without a message?

Step-by-Step Guide to Forcefully Remove and Recreate Docker Containers

Steps Cleanup phase This phase’s goal is to removes existing containers, volumes, networks and images Stop and remove volumes docker compose down --volumes --remove-orphans The previous command stops and removes containers, networks, and default volu...

Sep 12, 20252 min read

Step-by-Step Guide to Forcefully Remove and Recreate Docker Containers

A Complete Guide to Uninstalling Docker completely on Pop!_OS and Ubuntu-based Systems

Steps Stop the service It’s not mandatory, but before uninstalling, it's a good practice to stop any running Docker services. sudo systemctl stop docker Remove docker packages It’s used to completely and forcefully remove a list of specified packag...

Sep 12, 20252 min read

A Complete Guide to Uninstalling Docker completely on Pop!_OS and Ubuntu-based Systems

Alexandre Calaça's Blog

265 posts

I'm a passionate software engineer with a deep love for turning complex problems into elegant solutions through code.

Command Palette

Install postgresql

Check installation

Check Postgresql configuration

Check Postgresql service

Connect to Postgresql

Done

Celebrate

Reach me out

Final thoughts

Comments

More from this blog