Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dcC94-0007d7-DD for pgsql-sql@arkaria.postgresql.org; Mon, 31 Jul 2017 14:58:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dcC93-0002M9-Oq for pgsql-sql@arkaria.postgresql.org; Mon, 31 Jul 2017 14:58:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dcC85-0000Za-CX for pgsql-sql@postgresql.org; Mon, 31 Jul 2017 14:57:09 +0000 Received: from mwork.nabble.com ([162.253.133.43]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dcC82-0003UK-0a for pgsql-sql@postgresql.org; Mon, 31 Jul 2017 14:57:08 +0000 Received: from mben.nabble.com (unknown [162.253.133.72]) by mwork.nabble.com (Postfix) with ESMTP id A12B157D63489 for ; Mon, 31 Jul 2017 07:57:05 -0700 (MST) Date: Mon, 31 Jul 2017 07:57:05 -0700 (MST) From: srilinux To: pgsql-sql@postgresql.org Message-ID: <1501513025664-5973520.post@n3.nabble.com> Subject: Database duplicate copy MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org 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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql