FAQ
Diese Seite ist noch nicht in deiner Sprache verfügbar. Englische Seite aufrufen
-
Where can I find?
My service is not working, where can I get help?
Raise an incident at the Help Center.
Where can I find the different storage performance classes and their specifications?
You can learn more about them on Flavors and performance classes of PostgreSQL Flex.
Where can I find the ID of my instance?
If you are using the Portal, it is not displayed on the overview page. But you can copy it from the URL, where it is located behind
postgres-flex/. Alternatively, you can use the List instances request of our API.Where can I find the host name?
Click on your instance in the PostgreSQL Flex overview. In the instance overview, select the user menu. Click on your user and find the host name on the right side.
Where can I find the API documentation?
You can find the API documentation in the API Explorer. There, you can also download a collection for Postman and other OpenAPI compatible clients.
-
How can I?
How can I create a PostgreSQL instance at STACKIT?
Follow the instructions described in the Getting started section.
How can I restore my database / instance to an earlier point in time?
Restores are performed using the clone function on the instances overview page. You select a specific point in time for the restore and a cloned instance is created. You can then use it with your application. Alternatively, you can retrieve the data (deleted table for example) and transfer it to the “original” instance. You can then decide which instance to keep and which to delete. In the near future, we will offer pgBouncer as a new feature. This means that you will always have the same connection string to the application. If you now create a clone and want to continue working with it, you can configure it in pgBouncer to use the preserved instance and work with the data of the clone from now on. The “old/original” instance can then be deleted.
I need a PostgreSQL extension installed on one of my databases, how can I do this?
STACKIT PostgreSQL supports a long list of PostgreSQL extensions. Your database owner has all the required permissions to create extensions. Give it a try!
How can I change the flavor (CPU/Memory)?
You can change the flavor in the instance overview page in the Portal or via the API.
I accidentally deleted my instance. How can I get it back?
Deleted instances are initially set to the deleted state and are retained for 5 days. In this state they can be restored using the cloning feature. You can find out more about delayed deletion here.
How can I permanently delete an instance?
Instances in the deleted state can be permanently deleted using the force delete request from our API.
I have forgotten my user's password. How can I reset it?
As of now, you need to reset the user using the API in order to generate a new password. In the near future, this will also be possible in the Portal.
How can I change the storage performance class or disk size of an instance?
To change the storage performance class settings, you have to use the cloning function. We have a detailed description on cloning here. The disk size can also be changed in the Portal or by using the update instance request of our API. Note, that the size can only be increased.
-
General
Can I encrypt my connection to the database?
Connections to your database are always encrypted using TLS 1.3 and signed certificates. Unencrypted access is not possible.
Can I change the PostgreSQL port?
Currently you can’t change the PostgreSQL port.
Why is there no in-place recovery?
An in-place recovery is currently not possible due to technical limitations. The closest thing we can offer is point-in-time recovery to a cloned instance.
If I create a new user on a PostgreSQL and with this user I create a new database so that I can create schemas. Is the new database part of automatic backup?
Yes, the complete instance is backed up and all changes are included.
Are there other ways to use the PostgreSQL Flex service with more options?
We have an “API First” approach. Because of that, there are features that are not yet available in the Portal. You’ll find more information about using the API in the Tutorials.
What is the maximum number of connections I can have?
The amount of connections correlates to your chosen flavor, more specifically the RAM of your instance. We have all the information about it listed in our service plans.
Why can I revoke a user's login permission?
While it seems odd at first, it actually is a useful feature we provide to our customers. By disabling your users from logging into your database for a short time, you can make sure that no data can be added during maintenance windows.
Can I see the test results of the recovery tests?
We can provide you with the results of our regularly conducted recovery tests. Please create a service request to obtain the test results in our Help Center.
How can I do auditing currently on PostgreSQL Flex?
Auditing is activated by default and the customer currently can´t deactivate it. If you want to get the audit log, please create a service request in our Help Center.