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
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 | select | instanceId | Display the root username and password for an accessible PostgreSQL Managed Database. The database's status needs to be active.Learn more... Learn more... | |
reset_credentials | exec | instanceId | 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 |
|---|---|---|
instanceId | string | The ID of the Managed PostgreSQL Database. |
SELECT examples​
- get
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
WHERE instanceId = '{{ instanceId }}' -- required
;
Lifecycle Methods​
- reset_credentials
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.reset_credentials
@instanceId='{{ instanceId }}' --required
;