PostgreSQL

Opterius Panel supports both MySQL/MariaDB and PostgreSQL. MySQL is the default for most web applications (WordPress, Joomla, PrestaShop). PostgreSQL is available for applications that need it — typically Node.js apps, Python/Django apps, or projects that specifically require PostgreSQL features like JSONB, full-text search, or advanced data types.

MySQL vs PostgreSQL#

PostgreSQL on Opterius#

When you create a PostgreSQL database, Opterius:

1. Creates the database with UTF-8 encoding
2. Creates a dedicated role (user) with full access to that database
3. Shows you the generated password once — save it immediately

All PostgreSQL databases and users are prefixed with your account username (e.g. myuser_dbname) to prevent naming collisions on shared servers.

Accessing PostgreSQL#

PostgreSQL listens on localhost port 5432. You cannot connect remotely by default (same as MySQL).

From your application, use the connection details shown on the database page:

Host:     127.0.0.1
Port:     5432
Database: your_db_name
User:     your_pg_username
Password: (set at creation time)

From the terminal (SSH into the server, or use the Web Terminal):

psql -U your_pg_username -d your_db_name -h 127.0.0.1

Next Steps#

• Creating a PostgreSQL Database
• Connecting to PostgreSQL
• MySQL on Opterius