[SQL] Database duplicate copy

Hi All 

I have created the below standby database using the below command 

CREATE DATABASE standby OWNER admin TEMPLATE assembly;   

this worked but the assembly database has privileges which are not copied to
standby server , is there any thing that need to be added in the create
syntax or do after the standby db is created ? 

Below is the list , how to create satndy database exactly as assembly
database with access privileges 

postgres=# \list                                  List of databases   Name    |  Owner   | Encoding |   Collate   |
Ctype   |   Access
 
privileges 
-----------+----------+----------+-------------+-------------+------------------ 
----- postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 

standby   | admin  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

assembly | admin  | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/admin    +           |          |          |
|            |
 
admin=CTc/admin

template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres    +           |          |          |
    |             |
 
postgres=CTc/post 
gres template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres    +           |          |          |
         |             |
 
postgres=CTc/post 
gres 



--
View this message in context: http://www.postgresql-archive.org/Database-duplicate-copy-tp5973520.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.