Module: postgres#
create postgres user USERNAME PASSWORD
list postgres users
rename postgres user OLDUSERNAME NEWUSERNAME NEWPASSWORD
set postgres password USERNAME NEWPASSWORD
delete postgres user USERNAME
create postgres database DBNAME
list postgres databases
rename postgres database OLDDBNAME NEWDBNAME
delete postgres database DBNAME
set postgres privileges USERNAME DBNAME
delete postgres privileges USERNAME DBNAME
sync postgres grants
get postgres restrictions
COMMANDS
create postgres user USERNAME PASSWORD
Create a new PostgreSQL user with USERNAME and PASSWORD.
Example
$ cpanel create postgres user "scott" 'tiger'
list postgres users
List all PostgreSQL users associated to the cPanel account.
Example
$ cpanel list postgres users
See a sample of the JSON result data at: https://api.docs.cpanel.net/openapi/cpanel/operation/Postgresql::list_users/
rename postgres user OLDUSERNAME NEWUSERNAME NEWPASSWORD
Rename PostgreSQL user from OLDUSERNAME to NEWUSERNAME with NEWPASSWORD.
Example
$ cpanel rename postgres user "scott" "larry" 'tiger'
set postgres password USERNAME NEWPASSWORD
Change the password for PostgreSQL user USERNAME to NEWPASSWORD.
Example
$ cpanel set postgres password "scott" 'panther'
delete postgres user USERNAME
Delete PostgreSQL user USERNAME.
Example
$ cpanel delete postgres user "scott"
create postgres database DBNAME
Create a new PostgreSQL database with name DBNAME.
Example
$ cpanel create postgres database 'northwind'
list postgres databases
List existing PostgreSQL databases.
Example
$ cpanel list postgres databases
See a sample of the JSON result data at: https://api.docs.cpanel.net/openapi/cpanel/operation/Postgresql-list_databases/
rename postgres database OLDDBNAME NEWDBNAME
Rename PostgreSQL database from OLDDBNAME to NEWDBNAME.
Example
$ cpanel rename postgres database 'northwind' 'southgale'
delete postgres database DBNAME
Delete PostgreSQL database named DBNAME.
Example
$ cpanel delete postgres database 'northwind'
set postgres privileges USERNAME DBNAME
Grant to PostgreSQL user USERNAME all privileges on database DBNAME. To manage user privileges, use GRANT/REVOKE statements. See: https://www.postgresql.org/docs/current/sql-grant.htm and https://www.postgresql.org/docs/current/sql-revoke.htm
Example
$ cpanel set postgres privileges 'scott' 'northwind'
delete postgres privileges USERNAME DBNAME
Revoke all privileges granted to PostgreSQL user USERNAME on database DBNAME.
Example
$ cpanel delete postgres privileges 'scott' 'northwind'
sync postgres grants
Manually synchronize the user grants after adding users or tables to a PostgreSQL database. See ‘Add a PostgreSQL user’ at: https://docs.cpanel.net/cpanel/databases/postgresql-databases/ for further information.
Example
$ cpanel sync postgres grants
get postgres restrictions
Return PostgreSQL object name length and prefix restrictions.
Example
$ cpanel get postgres restrictions
See a sample of the JSON result data at: https://api.docs.cpanel.net/openapi/cpanel/operation/Postgresql::get_restrictions/