fabtools.postgres
¶
PostgreSQL users and databases¶
This module provides tools for creating PostgreSQL users and databases.
See also
Manage users¶
-
fabtools.postgres.
create_user
(name, password, superuser=False, createdb=False, createrole=False, inherit=True, login=True, connection_limit=None, encrypted_password=False)[source]¶ Create a PostgreSQL user.
Example:
import fabtools # Create DB user if it does not exist if not fabtools.postgres.user_exists('dbuser'): fabtools.postgres.create_user('dbuser', password='somerandomstring') # Create DB user with custom options fabtools.postgres.create_user('dbuser2', password='s3cr3t', createdb=True, createrole=True, connection_limit=20)
Manage databases¶
-
fabtools.postgres.
create_database
(name, owner, template='template0', encoding='UTF8', locale='en_US.UTF-8')[source]¶ Create a PostgreSQL database.
Example:
import fabtools # Create DB if it does not exist if not fabtools.postgres.database_exists('myapp'): fabtools.postgres.create_database('myapp', owner='dbuser')