How do I create a postgresql user with fabric

Question

I want to create a database user for my setup fabric script but createuser has interactive password entering and seams not to like fabric.

score 35 · Answer 1 · edited Mar 07 '18 at 20:03

35

To extend the answer with a Fabric example...

# In fabfile.py
def create_database():
    """Creates role and database"""
    db_user = get_user()  # define these
    db_pass = get_pass()
    db_name = get_db_name()
    sudo('psql -c "CREATE USER %s WITH NOCREATEDB NOCREATEUSER " \
         "ENCRYPTED PASSWORD E\'%s\'"' % (db_user, db_pass), user='postgres')
    sudo('psql -c "CREATE DATABASE %s WITH OWNER %s"' % (
         db_name, db_user), user='postgres')

edited Mar 07 '18 at 20:03

Community

1
1

answered Jan 11 '11 at 20:38

robhudson

2,658
1
21
19

2

Upwote. But did you really mean table in `db_table = get_table()`? Looks like you meant a database name. – Vlad T. Feb 22 '18 at 11:34

score 8 · Accepted Answer · answered Apr 19 '10 at 11:36

8

Just use plain SQL to create a new user:

CREATE ROLE user_name WITH ENCRYPTED PASSWORD 'your password';

answered Apr 19 '10 at 11:36

Frank Heikens

117,544
24
142
135

how do I send this SQL to postgres in a one-liner? – user320080 Apr 19 '10 at 12:10
Connect with the psql client and send the query. http://www.postgresql.org/docs/8.4/interactive/app-psql.html – Frank Heikens Apr 19 '10 at 12:41

score 1 · Answer 3 · answered Nov 22 '15 at 09:06

This is probably of some use without having to write your own modules or you could use it as reference.

from fabtools import require

require.postgres.create_db ???

https://fabtools.readthedocs.org/en/0.19.0/api/require/postgres.html?highlight=postgres#module-fabtools.require.postgres

How do I create a postgresql user with fabric

3 Answers3

Linked