This module provides tools for creating PostgreSQL users and databases.
See also
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)
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')