saltstack-formulas / postgres-formula

http://docs.saltstack.com/en/latest/topics/development/conventions/formulas.html
Other
77 stars 283 forks source link

freebsd: User 'pgsql' is not available #290

Open noelmcloughlin opened 5 years ago

noelmcloughlin commented 5 years ago

Seeing this error on FreeBSD even with ./defaults.yaml: version: '10'

          ID: postgres_schema-db2-public
    Function: postgres_schema.present
        Name: public
      Result: False
     Comment: An exception occurred in this state: Traceback (most recent call last):
                File "/usr/local/lib/python2.7/site-packages/salt/state.py", line 1933, in call
                  **cdata['kwargs'])
                File "/usr/local/lib/python2.7/site-packages/salt/loader.py", line 1939, in wrapper
                  return f(*args, **kwargs)
                File "/usr/local/lib/python2.7/site-packages/salt/states/postgres_schema.py", line 75, in present
                  schema_attr = __salt__['postgres.schema_get'](dbname, name, **db_args)
                File "/usr/local/lib/python2.7/site-packages/salt/modules/postgres.py", line 2107, in schema_get
                  db_password=db_password)
                File "/usr/local/lib/python2.7/site-packages/salt/modules/postgres.py", line 2162, in schema_list
                  password=db_password)
                File "/usr/local/lib/python2.7/site-packages/salt/modules/postgres.py", line 438, in psql_query
                  password=password)
                File "/usr/local/lib/python2.7/site-packages/salt/modules/postgres.py", line 377, in _psql_prepare_and_run
                  rcmd, runas=runas, password=password, host=host, port=port, user=user)
                File "/usr/local/lib/python2.7/site-packages/salt/modules/postgres.py", line 186, in _run_psql
                  ret = __salt__['cmd.run_all'](cmd, python_shell=False, **kwargs)
                File "/usr/local/lib/python2.7/site-packages/salt/modules/cmdmod.py", line 2069, in run_all
                  **kwargs)
                File "/usr/local/lib/python2.7/site-packages/salt/modules/cmdmod.py", line 428, in _run
                  'User \'{0}\' is not available'.format(runas)
              CommandExecutionError: User 'pgsql' is not available