PostgreSQL is a powerful Relational Database Management System (RDBMS) supported on our servers. Like other RDBMS platforms, it stores information in structured tables made up of rows and columns.
Many web applications—such as shopping carts, forums, blogs, and content management systems (CMS)—require a database to function.
MySQL vs. PostgreSQL – A Quick Note
Most open-source applications use MySQL because it’s easier to use and generally faster for common tasks. PostgreSQL, on the other hand, is more complex and feature-rich, offering developers greater flexibility and advanced capabilities.
For a detailed comparison, check out our article:Â What is the Difference Between MySQL and PostgreSQL
Important: Check Your Hosting Plan
Not all hosting plans include PostgreSQL support. If you don’t see the PostgreSQL Databases section under the Databases menu in your Control Panel, your current plan does not support PostgreSQL.
How to Create a PostgreSQL Database
Follow these simple steps to create a PostgreSQL database in your TrexHost Control Panel:
- Navigate to Databases > PostgreSQL Databases in your Web Hosting Control Panel.
- You’ll see a form for creating a new PostgreSQL database.
- Enter the database name – it will automatically be prefixed with your hosting account username (e.g.,Â
username_). You just need to choose the unique part that identifies this specific database. - Specify and confirm a password for the database.
- Click the Create button.
Managing Your Existing Databases
Below the creation form, you’ll find a table listing all your existing PostgreSQL databases. For each one, you can:
- Change the password
- Delete the database
- Log in via phpPgAdmin (a web-based management tool)
Important Notes
- Each database on our servers has only one user (created by default). Additional users cannot be created.
- The database name and database username are identical in our system.
- For easier management, we recommend creating separate databases for each application you run (e.g., one for your blog, another for your store).
Ready to Get Started?
Creating a PostgreSQL database takes just a few clicks. Log in to your Control Panel today and start building your data-driven applications with TrexHost!