Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] created database but access is not copied ? any suggestions - Mailing list pgsql-sql

From David G. Johnston
Subject Re: [SQL] created database but access is not copied ? any suggestions
Date
Msg-id CAKFQuwb+uroJ4FwA3K=RexL6Fboj-8WGUKPN28X212_x5j5seg@mail.gmail.com
Whole thread Raw
In response to [SQL] created database but access is not copied ? any suggestions  (srilinux <srilinux09@gmail.com>)
Responses Re: [SQL] created database but access is not copied ? any suggestions  (srilinux <srilinux09@gmail.com>)
List pgsql-sql
Tree view
On Friday, July 28, 2017, srilinux <srilinux09@gmail.com> wrote:
Hi All

I have created the below standby database using the below command

CREATE DATABASE standby OWNER admin TABLESPACE 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 ?


The tablespace named assembly and the database named assembly are not the same thing.

David J. 

pgsql-sql by date:

Previous
From: srilinux
Date:
Subject: [SQL] created database but access is not copied ? any suggestions
Next
From: srilinux
Date:
Subject: Re: [SQL] created database but access is not copied ? any suggestions