dynhyp
Sign inStart Trial

"Step-by-Step Guide: Installing Strapi 5 with PostgreSQL 17 on DynHyp Platform"

Introduction

In today's digital development landscape, managing database servers and content management systems can be a complex challenge. DynHyp simplifies this process by providing an innovative solution that makes database server creation and management effortless. In this guide, we'll explore how to install Strapi 5 using PostgreSQL 17 on the DynHyp platform.
Strapi 5, a leading headless CMS in modern web applications, when combined with PostgreSQL 17's advanced features, creates a powerful and scalable infrastructure. Thanks to DynHyp's user-friendly interface, you can integrate this powerful combination into your projects within minutes.
In this comprehensive guide, we'll walk through the entire process from setting up PostgreSQL 17 on DynHyp to successfully configuring Strapi 5. You'll learn how to perform critical steps such as database creation, connection settings, and Strapi configuration through DynHyp's intuitive interface.

1. PostgreSQL Server Setup (DynHyp)

Step 1: Creating the Server

  1. Log in to DynHyp Dashboard
  2. Click on "Database Servers" in the left menu
  3. Click the "Create Server" button above the PostgreSQL option
  4. Fill in the required information in the server configuration screen:
PostgreSQL server creation form
PostgreSQL server creation form

Step 2: Connection Test and Information

  1. Click on the three dots (⋮) menu on the right side of the created server
  2. Select "Connection Info" from the menu
Dynhyp Postgre Server Connection Info & Test Connection
Dynhyp Postgre Server Connection Info & Test Connection
  1. Click "Test Connection" to test the connection
    • A success message will be displayed when the connection is successful
  2. Important: Copy the connection information using the "Copy Snippet" button and store it in a secure location

2. Strapi Installation

Step 1: Creating a New Project

Open your terminal or command prompt and run the following command:
npx create-strapi-app@latest my-strapi-project
cd my-strapi-project
Strapi installation start screen
Strapi installation start screen

Step 2: Answering Installation Questions

Answer the installation questions as follows:
  1. "Do you want to use the default database (sqlite)?" → n
  2. "Choose your default database client" → postgres
  3. "Database name:" → dynhypstrapi
  4. "Host:" → qvwnhiz4snlr.dynhyp.com
  5. "Port:" → 5432
  6. "Username:" → postgre
  7. "Password:" → [Password from DynHyp]
  8. "Enable SSL connection:" → y
  9. "Start with an example structure & data?" → y
  10. "Start with Typescript?" → n
  11. "Install dependencies with npm?" → y
  12. "Initialize a git repository?" → y
Strapi Installation Questions & Answers
Strapi Installation Questions & Answers

Step 3: Starting Strapi

After the installation is complete, start Strapi in development mode:
npm run develop
After successful installation, you can access the admin panel at http://localhost:1337/admin.
Strapi Admin Panel Login Screen
Strapi Admin Panel Login Screen

Important Notes

  • Securely store the connection information obtained from DynHyp
  • Ensure that your PostgreSQL server's security settings allow Strapi connections
  • After creating your first admin account, store your login credentials securely

Next Steps

After successful installation, you can:
  1. Start creating your content types from the admin panel
  2. Test your API endpoints
  3. Configure user roles and permissions
  4. Connect your frontend application to the Strapi API

POSTED BY

Berk Göknil
Berk Göknil
Dynhyp Team

MORE ARTICLES

FATAL: Peer authentication failed for user "postgres"

FATAL: Peer authentication failed for user "postgres"

Berk Göknil

PostgreSQL Create User: A Complete Guide [2024]

PostgreSQL Create User: A Complete Guide [2024]

Berk Göknil

Drizzle ORM: A Type-Safe and Modern ORM for TypeScript Applications

Drizzle ORM: A Type-Safe and Modern ORM for TypeScript Applications

Berk Göknil