popularity question answers views user  
0
Adding a postgres super user with the database cookbook

I have this database_user block in my recipe:

database_user 'username' do
  connection {psql_connection}
  password 'a password'
  provider Chef::Provider::Database::PostgresqlUser
  privileges [:Superuser] #tried with [:all, :select, etc]
  action :create
end

But when I connect to postgres (as postgres supseruser) and run \du, the new user doesn’t have any roles at all. How can I add a user with superuser privileges?

thanks

more →
0 79  
0
setting the postgresql cookbook password in json

Hi guys.

I am able to set the mysql password in json config… but I am having no luck with configuring a postgresql password in the same way.

Can anyone help ?

Thanks!

more →
0 358