Skip to main content

Managed Database

We provide a Managed Database service within the Mayope cloud.

Overview#

The database is powered by PostgreSQL and we aim to always provide the latest version.

Request#

  1. Log into https://cloud.mayope.net.
  2. Click on the Database menu option.
  3. Enter your database name and desired size
  4. Click on Request Database.
  5. The requested database should become online in a couple of minutes.

Access#

To access the database you will need our own psql-client and jdbc-driver

All connections are encrypted, and you can check the certificated against the Let's Encrypt root ca.

Windows#

./psql.exe "sslmode=require ssltermination=proxy host=database-dbf5ee35-eb69-4c49-afdf-c503693f5205.dyn.mayope.net port=5432 user=postgres"

Linux#

.\psql "sslmode=require ssltermination=proxy host=database-dbf5ee35-eb69-4c49-afdf-c503693f5205.dyn.mayope.net port=5432 user=postgres"

JDBC#

Maven#

<dependency>  <groupId>net.mayope.postgresql</groupId>  <artifactId>postgresql</artifactId>  <version>42.3.0-ssl-termination</version>  <type>pom</type></dependency>

Gradle#

implementation 'net.mayope.postgresql:postgresql:42.3.0-ssl-termination'

Connection url#

jdbc:postgresql://database-dbf5ee35-eb69-4c49-afdf-c503693f5205.dyn.mayope.net:5432/test?user=postgres&password={password}&sslmode=require&ssltermination=proxy

Why do we need an own psql-client#

We need to ship our own psql-client because of an open issue with the official sql client: archive.

The changes on the psql-client are minimal and only remove the initial SSLRequest and add the hostname to the ssl-hello request.

You can inspect the changes in the forked repository: mayope_postgres and mayope_pgjdc.