Installing PostgreSQL

You can either use the PostgreSQL that is included with your Ubuntu, or use the PostgreSQL Advanced Packaging Tool (APT) Repository. For the list of supported versions, see Database Vault Overview.

The supported algorithm is AES-256.

Installing PostgreSQL in Ubuntu: 

PostgreSQL is included automatically with Ubuntu. You can install it by using the following APT command: 

Copy 
apt install postgresql

Using the PostgreSQL APT Repository

If the PostgreSQL version included in your version of Ubuntu is not the one that you want to use, you can use the PostgreSQL APT Repository. The PostgreSQL APT Repository supports the following versions of Ubuntu: 

  • noble (24.04, LTS)

  • mantic (23.10, non-LTS)

  • jammy (22.04, LTS)

  • focal (20.04, LTS)

To automatically install and configure the PostgreSQL APT Repository, use the following APT commands: 

Copy 
sudo apt install -y postgresql-common
sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

To manually install and configure the PostgreSQL APT Repository, perform the following: 

  1. Import the repository signing key. For example: 

    Copy 
    sudo apt install curl ca-certificates
    sudo install -d /usr/share/postgresql-common/pgdg
    sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc

  2. Create the repository confirmation file. For example: 

    Copy 
    sudo sh -c 'echo "deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

  3. Update the package lists. For example: 

    Copy 
    sudo apt update

  4. Install the latest version of PostgreSQL. For example: 

    Copy 
    sudo apt -y install postgresql

    Note: If you want to use a particular version of PostgreSQL, enter that instead of 'postgresql'. For example, use 'postgresql-16'.