PostgreSQL: Configuring PostgreSQL with Skyvia

This documentation is part of the Getting Started guide. You can view the complete guide here: How to Get Started with PostgreSQL.

👋 Welcome to the Stackhero documentation!

Stackhero offers a fully managed PostgreSQL cloud solution, designed for reliability and performance:

  • Unlimited connections and data transfers for effortless scalability.
  • PgAdmin web interface included for easy database management.
  • Popular extensions included, such as PostGIS, TimescaleDB, and PgVector.
  • Simple, one-click updates to keep your database secure and up to date.
  • High performance and enhanced security on private, dedicated infrastructure.

Save time and make your life easier: it only takes 5 minutes to try Stackhero's PostgreSQL cloud hosting solution!

Using Skyvia with Stackhero for PostgreSQL is straightforward. Ensure a secure connection by configuring the following settings:

  1. Set Protocol to SSL
  2. Set Port to your PostgreSQL port
  3. Force encryption by setting SSL Mode to Require
  4. Select an SSL TLS Protocol of 1.2 or higher

For additional details on Skyvia configuration, please refer to the Skyvia official documentation.

Example of Skyvia configuration with Stackhero for PostgreSQLExample of Skyvia configuration with Stackhero for PostgreSQL

Continue reading this guide

  1. Read the full guide: Getting Started
    How to Get Started with PostgreSQL
  2. Using the PostgreSQL psql CLI
  3. Creating a User and Database in PostgreSQL
  4. Importing Data from Your Computer to PostgreSQL
  5. Exporting Data from PostgreSQL to Your Computer
  6. Using PostgreSQL with Node.js
  7. Using PostgreSQL with Node.js/TypeORM
  8. Using PostgreSQL with Django
  9. Activating PostgreSQL PostGIS Extension
  10. Deactivating PostgreSQL PostGIS Extension
  11. Activating PgVector Extension
  12. Activating TimescaleDB Extension
  13. Tracking Statistics of SQL Planning and Execution (pg_stat_statements)

Other articles for PostgreSQL

  1. Alternative to ElephantSQL Shutdown
    Smoothly migrate from ElephantSQL: Stackhero offers a secure, dedicated PostgreSQL service.
  2. Automate with the CLI
    Start PostgreSQL, retrieve its credentials, and modify its configuration programmatically using the Stackhero CLI
  3. GitHub Actions & GitLab CI
    Launch a real PostgreSQL service from your GitHub Actions or GitLab CI pipeline, run your tests against it, and automatically tear it down