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.