postgresql_instance_credentials
Creates, updates, deletes, gets or lists a postgresql_instance_credentials resource.
Overview
| Name | postgresql_instance_credentials |
| Type | Resource |
| Id | linode.databases.postgresql_instance_credentials |
Fields
The following fields are returned by SELECT queries:
- get_databases_postgre_sql_instance_credentials
PostgreSQL Managed Database root username and password.
| Name | Datatype | Description |
|---|---|---|
password | string | Read-only The randomly generated root password for the Managed Database instance. (example: s3cur3P@ssw0rd) |
username | string | Read-only The root username for the Managed Database instance. (example: linroot) |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get_databases_postgre_sql_instance_credentials | select | Display the root username and password for an accessible PostgreSQL Managed Database. The database's status needs to be active.Learn more... Learn more... | ||
post_databases_postgre_sql_instance_credentials_reset | exec | Reset the root password for a PostgreSQL Managed Database. A new root password is randomly generated and accessible with the Get PostgreSQL Managed Database credentials operation. - The database's status needs to be active.- Only unrestricted users can access this operation. These users have access regardless of the acting token's OAuth scopes. - It may take several seconds for credentials to reset. Learn more... Learn more... |
Parameters
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|
SELECT examples
- get_databases_postgre_sql_instance_credentials
Display the root username and password for an accessible PostgreSQL Managed Database. The database's status needs to be active.
Learn more...
Learn more...
SELECT
password,
username
FROM linode.databases.postgresql_instance_credentials;
Lifecycle Methods
- post_databases_postgre_sql_instance_credentials_reset
Reset the root password for a PostgreSQL Managed Database. A new root password is randomly generated and accessible with the Get PostgreSQL Managed Database credentials operation.
- The database's status needs to be active.
- Only unrestricted users can access this operation. These users have access regardless of the acting token's OAuth scopes.
- It may take several seconds for credentials to reset.
Learn more...
Learn more...
EXEC linode.databases.postgresql_instance_credentials.post_databases_postgre_sql_instance_credentials_reset
;