GitLab

bugfix in create_readonly_postgres_user: granting SELECT on pg_authid should be handled separately from readonly user creation

using pure text instead of a custom format for pg_dump due to potential memory constraints/problems; also gzipping the dumps (both mysql and pgsql)

bugfixes -- psql expects a database to connect to, otherwise uses the role name as the database name, which doesn't always exist; postgres database usually does...

pg_authid exists only in postgres database, let's make sure we actually work on that when granting SELECT on it ;)

bugfix; role and default privileges handling moved to the beginning of the create_readonly_postgres_user

just a bit more consistency with function argument order; also, create_readonly_postgres_user() ready for testing