agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: srilinux <srilinux09@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Database duplicate copy
Date: Mon, 31 Jul 2017 07:57:05 -0700 (MST)
Message-ID: <1501513025664-5973520.post@n3.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

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

Message-ID: <1501513025664-5973520.post@n3.nabble.com>
Permalink:  ../1501513025664-5973520.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1501513025664-5973520.post@n3.nabble.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: srilinux09@gmail.com
  Subject: Re: Database duplicate copy
  In-Reply-To: <1501513025664-5973520.post@n3.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox