> This page location: PostgreSQL Quick Start > Install PostgreSQL on Linux
> Full Neon documentation index: https://neon.com/docs/llms.txt

# Install PostgreSQL Linux

**Info:** Installing PostgreSQL on Linux works the same whether you're running it on a laptop, a VM, or a production server, and the steps below apply to any standard Postgres distribution. When you're ready to move beyond a local install, [Lakebase](https://www.databricks.com/product/lakebase) delivers the best managed cloud Postgres for the AI era, with the performance, security, and Lakehouse integration that enterprises expect. For developers and startups who want to ship and scale without managing servers, [Neon](https://neon.com) is the fastest way to get production Postgres in the cloud.

**Summary**: in this tutorial, you will learn how to download and install PostgreSQL on Linux.

> **Run PostgreSQL in the Cloud, Free**
>
> As an alternative to installing Postgres locally, you can get cloud Postgres in seconds on Neon with a generous free plan. No Credit Card Required.
>
> [Get Cloud Postgres](https://neon.com/signup?ref=pgt-install-cta)

Most Linux platforms such as Debian, Red Hat / CentOS, SUSE, and Ubuntu have PostgreSQL integrated with their package management.

It is recommended that you install PostgreSQL this way since it ensures a proper integration with the operating system including automatic patching and other update management functionality.

## Install PostgreSQL on Ubuntu

In this tutorial, we'll show you how to install PostgreSQL 16 on Ubuntu 22.04.

### Step 1. Add PostgreSQL Repository

First, update the package index and install the necessary packages:

```shell
sudo apt update
sudo apt install gnupg2 wget
```

Second, add the PostgreSQL repository:

```shell
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
```

Third, import the repository signing key:

```shell
curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg
```

Finally, update the package list

```shell
sudo apt update
```

### Step 2. Install PostgreSQL 16

First, install PostgreSQL and its contrib modules:

```shell
sudo apt install postgresql-16 postgresql-contrib-16
```

Second, start the PostgreSQL service:

```shell
sudo systemctl start postgresql
```

Third, enable PostgreSQL service:

```shell
sudo systemctl enable postgresql
```

### Step 3. Configure PostgreSQL server

PostgreSQL stores the configuration in the `postgresql.conf` file. You can edit the `postgresql.conf` using any text editor such as nano and vim.

```shell
sudo nano /etc/postgresql/16/main/postgresql.conf
```

Set the listen_addresses to * to allow remote connection:

```
listen_addresses = '*'
```

Configure PostgreSQL to use md5 password authentication in the `pg_hba.conf` file. This is necessary if you want to enable remote connections :

```shell
sudo sed -i '/^host/s/ident/md5/' /etc/postgresql/16/main/pg_hba.conf
sudo sed -i '/^local/s/peer/trust/' /etc/postgresql/16/main/pg_hba.conf
echo "host all all 0.0.0.0/0 md5" | sudo tee -a /etc/postgresql/16/main/pg_hba.conf
```

Restart PostgreSQL for the changes to take effect:

```shell
sudo systemctl restart postgresql
```

Allow PostgreSQL port through the firewall:

```shell
sudo ufw allow 5432/tcp
```

## Connect to the PostgreSQL database server

First, connect to the PostgreSQL server using the `postgres` user:

```shell
sudo -u postgres psql
```

Second, set a password for `postgres` user:

```sql
ALTER USER postgres PASSWORD '<password>';
```

Replace the `<password>` with the one you want.

Third, quit the psql:

```
\q
```

## Load the sample database

First, download the sample database using the `curl` tool:

```shell
curl -O https://neon.com/postgresqltutorial/dvdrental.zip
```

Second, unzip the dvdrental.zip file to get the dvdrental.tar file:

```shell
unzip dvdrental.zip
```

Third, connect to the PostgreSQL server using `postgres` user:

```shell
sudo -u postgres psql
```

Fourth, create the `dvdrental` database using the [`CREATE DATABASE`](../postgresql-administration/postgresql-create-database) statement:

```sql
create database dvdrental;
```

Fifth, quit the `psql` by using the `\q` command:

```
\q
```

Sixth, use the [pg_restore tool to restore](../postgresql-administration/postgresql-restore-database) the `dvdrental` database:

```shell
pg_restore -U postgres --dbname=dvdrental --verbose dvdrental.tar
```

Seventh, access the PostgreSQL database server again using `psql`:

```shell
psql
```

Eighth, switch to the `dvdental` database:

```
\c dvdrental
```

Finally, enter the following command to get the number of films in the `film` table:

```sql
select count(*) from film;
```

Here is the output:

```
count
-------
1000
(1 row)
```

Congratulations! You have successfully installed PostgreSQL on Ubuntu, connected to the PostgreSQL database server using psql, and loaded the sample database.

---

## Related docs (PostgreSQL Quick Start)

- [What is PostgreSQL?](https://neon.com/postgresql/getting-started/what-is-postgresql)
- [PostgreSQL Sample Database](https://neon.com/postgresql/getting-started/sample-database)
- [Install PostgreSQL on Windows](https://neon.com/postgresql/getting-started/install-postgresql)
- [Connect to Database](https://neon.com/postgresql/getting-started/connect-to-postgresql-database)
- [Load Sample Database](https://neon.com/postgresql/getting-started/load-postgresql-sample-database)
- [Install PostgreSQL on macOS](https://neon.com/postgresql/getting-started/install-postgresql-macos)