How to Install PostgreSQL

PostgreSQL is a powerful, open-source relational database management system that is known for its stability and feature-rich capabilities. This tutorial will guide you through the installation of PostgreSQL on different Linux distributions.

1. Updating Package Index

Before installation, it’s always a good practice to update your package index. Open your terminal and run the following command:

sudo apt update

For CentOS, use:

sudo yum update

2. Installing PostgreSQL

The installation command may vary depending on your Linux distribution:

• For Ubuntu:

  sudo apt install postgresql postgresql-contrib

• For CentOS:

  sudo yum install postgresql-server postgresql-contrib

• For Fedora:

  sudo dnf install postgresql-server postgresql-contrib

3. Initializing the Database

After installation, you need to initialize the PostgreSQL database:

sudo postgresql-setup initdb

For Ubuntu, the initialization is done automatically during the installation, so you may skip this step.

4. Starting the PostgreSQL Service

You can start the PostgreSQL service using:

sudo systemctl start postgresql

To enable PostgreSQL to start automatically on boot:

sudo systemctl enable postgresql

5. Accessing PostgreSQL

PostgreSQL uses a concept called roles for managing database access. By default, it creates a role named after your Unix username. Log into the PostgreSQL prompt using:

sudo -i -u postgres
psql

This switches to the postgres user and opens the PostgreSQL prompt.

6. Creating a New Role

To create a new role, use the following command in the PostgreSQL prompt:

CREATE ROLE newuser WITH LOGIN PASSWORD 'password';

This creates a new role with login capabilities and an associated password. Replace newuser and password with your desired username and password.

7. Creating a New Database

To create a new database owned by the newly created user, run:

CREATE DATABASE mydatabase OWNER newuser;

Replace mydatabase with the desired name of your database.

8. Conclusion

By following this tutorial, you have successfully installed PostgreSQL and created users and databases. PostgreSQL is a robust database system that supports a wide range of applications. Continue to explore its features and capabilities to enhance your database management skills!

About the Author

Dorian Kane

Author

View All Posts