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
+55 (15) 3363-8633