Thread: [SQL] created database but access is not copied ? any suggestions

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 ?

Below is the list , how to grant access privileges

postgres=# \list                                 List of databases  Name    |  Owner   | Encoding |   Collate   |
Ctype   |   Access
 
privileg
es
-----------+----------+----------+-------------+-------------+------------------
-----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/adm
 
in*

template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres   +          |          |          |
  |             |
 
postgres=CTc/post
grestemplate1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres   +          |          |          |
      |             |
 
postgres=CTc/post
gres
(5 rows)




--
View this message in context:
http://www.postgresql-archive.org/created-database-but-access-is-not-copied-any-suggestions-tp5973259.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

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 ?

Hi There

my requirement is to make an exact copy of the database assembly for testing
purpose.

the standby created is functioning well and I am under impression I achieved
what I need to 

is there some thing that is not right?





--
View this message in context:
http://www.postgresql-archive.org/created-database-but-access-is-not-copied-any-suggestions-tp5973259p5973263.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

On Friday, July 28, 2017, srilinux <srilinux09@gmail.com> wrote:

Hi There

my requirement is to make an exact copy of the database assembly for testing
purpose.

the standby created is functioning well and I am under impression I achieved
what I need to

is there some thing that is not right?

Yes original command used is template instead of table space 

On Friday, July 28, 2017, David G Johnston [via PostgreSQL] <[hidden email]> wrote:

On Friday, July 28, 2017, srilinux <[hidden email]> wrote:

Hi There

my requirement is to make an exact copy of the database assembly for testing
purpose.

the standby created is functioning well and I am under impression I achieved
what I need to

is there some thing that is not right?

Did you maybe mean to write "template" instead of "tablespace"?

David J. 

---

If you reply to this email, your message will be added to the discussion below:

http://www.postgresql-archive.org/created-database-but-access-is-not-copied-any-suggestions-tp5973259p5973303.html

To unsubscribe from created database but access is not copied ? any suggestions, click here.
NAML

---

View this message in context: Re: [SQL] created database but access is not copied ? any suggestions
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.