For AI agents: The documentation index is at https://docs.digitalocean.com/llms.txt. Markdown versions of pages use the same URL with index.html.md in place of the HTML page (for example, append index.html.md to the directory path instead of opening the HTML document).

Reliable and scalable PostgreSQL database, ready to use on Ubuntu 20.04. This product offers a pre-configured PostgreSQL database server installed on Ubuntu 20.04. PostgreSQL is a powerful, open-source, object-relational database system that is highly scalable, reliable, and secure. It is widely used for a variety of applications, including web applications, data warehousing, and business intelligence.

Software Included

This Marketplace listing does not include a detailed software list.

Creating an App using the Control Panel

Click the Deploy to DigitalOcean button to create a Droplet based on this 1-Click App. If you aren’t logged in, this link will prompt you to log in with your DigitalOcean account.

Creating an App using the API

In addition to creating a Droplet from the PostgreSQL on Ubuntu24.04 1-Click App using the control panel, you can also use the DigitalOcean API. As an example, to create a 4GB PostgreSQL on Ubuntu24.04 Droplet in the SFO2 region, you can use the following curl command. You need to either save your API access token to an environment variable or substitute it in the command below.

curl -X POST -H 'Content-Type: application/json' \
         -H 'Authorization: Bearer '$TOKEN'' -d \
        '{"name":"choose_a_name","region":"sfo2","size":"s-2vcpu-4gb","image":"apps4rent-postgresqlonubun"}' \
        "https://api.digitalocean.com/v2/droplets"

Getting Started After Deploying PostgreSQL on Ubuntu24.04

Once the PostgreSQL on Ubuntu 24.04 One-Click Droplet is created, you can log into it as root. Make sure to substitute the Droplet’s public IPv4 address:

Bash

ssh root@your_droplet_public_ipv4

The PostgreSQL database server will already be running as a service and ready to use. To verify that the PostgreSQL service has been installed and is running correctly, you can run the following commands:

1. To verify the current operational status of the PostgreSQL service:

Bash

sudo systemctl status postgresql.service

sudo systemctl status postgresql@16-main

2. To check the installed version of potgreSQL:

Bash

psql –version

3. To connect to the PostgreSQL interactive terminal as the postgres account:

Bash

sudo -u postgres psql

3. Once the PostgreSQL prompt opens, you can verify the current version of the database installed by running:

SQL

SELECT version();

4. To exit the PostgreSQL prompt and return to your Linux command shell, run:

SQL

\q

5. To return to your regular system user shell from the postgres account, simply run:

SQL

exit