PostgreSQL Installation

Install PostgreSQL on the server that will host Veyo (or a database server reachable from it) and create the Veyo superuser. Pick your platform below.

Windows

Install PostgreSQL on Windows Server and create the Veyo superuser.

1. Download the installer

Open postgresql.org/download/windows and click Download the installer. Pick the latest stable version for Windows x86-64.

2. Run the installer

Right-click the downloaded file and choose Run as administrator. Step through the wizard:

• Accept the default installation directory.
• Accept the default data directory.
• When prompted, set a password for the built-in postgres superuser and save it somewhere safe.
• Accept the default port (5432).
• Accept the default locale.
• Uncheck Stack Builder on the final screen.

Click Finish to complete the installation.

3. Verify the service

Open Services (services.msc) and confirm postgresql-x64-XX is running. PostgreSQL is also configured to start automatically with Windows.

4. Create the Veyo superuser

Open the Start menu, search for SQL Shell (psql), and launch it. Press Enter through the connection prompts to accept the defaults, then enter the postgres password you set during install.

At the postgres=# prompt, run:

CREATE ROLE veyo_admin WITH LOGIN SUPERUSER PASSWORD 'choose-a-strong-password';

Verify the role was created:

\du

You should see veyo_admin listed with the Superuser attribute. Type \q to exit.

Linux

Install PostgreSQL on Ubuntu Server (22.04 LTS or newer) and create the Veyo superuser. Run every command as a user with sudo privileges.

1. Add the PostgreSQL APT repository

sudo apt update
sudo apt install -y 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
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'

2. Install PostgreSQL

sudo apt update
sudo apt install -y postgresql

3. Verify the service

sudo systemctl status postgresql

You should see active (exited). The service is enabled on boot by default.

4. Create the Veyo superuser

sudo -u postgres psql -c "CREATE ROLE veyo_admin WITH LOGIN SUPERUSER PASSWORD 'choose-a-strong-password';"

Verify the role:

sudo -u postgres psql -c "\du"

You should see veyo_admin listed with the Superuser attribute.

Once the veyo_admin role exists, continue to Veyo Installation & Setup.