1
vote
1answer
51 views

Postgresql readonly Backup user

Is it true that it is IMPOSSIBLE to have readonly backup user in Postgresql ? I tried to hack around this as I've been advised on IRC channel that you simply can't have a backup only user with no ...
3
votes
2answers
235 views

Change built-in default privileges in PostgreSQL?

Introduction. When I create a database, postgres=# CREATE DATABASE test2 OWNER test2; it is created with an empty privileges column: Name | Owner | Encoding | Collate | Ctype | ...
0
votes
1answer
85 views

PostgreSQL, How to keep only one schema?

I don't want some users be available to create schemas, and only use the public schema. I'd like to remove the permission of creating schemas, but I can't found anything on PotsgreSQL 9.1 ...