Allow an user (not superuser) to create a testing database from a production database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Hi everyone,


We have a database which recurrently we create a testing database making a copy of it. Under the superuser “postgres” we use the command “CREATE DATABASE totvs_test WITH TEMPLATE totvs_production;” which works pretty well.


But now I would like to allow an user, which is not the owner of the totvs_production database, and neither is a superuser, to execute this same command.

In order to achieve this, it seems that I have to give him the access “CREATEDB” and make our production database a template database. Do you know if there any safety, performance or any other kind of issue in making our production database as a template in postgres and keep using it for production tasks? This user, who would make this copy, already has access to SELECT in all the data of this database, but they have no rights in DELETE, UPDATE or INSERT.


Thanks in advance.



Jorge Luiz Moreira Silva

Diretor Industrial
Polimet Indústria Metalúrgica

+55 (15) 3363-8633



[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux