From: | srilinux <srilinux09(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | created database but access is not copied ? any suggestions |
Date: | 2017-07-28 20:43:22 |
Message-ID: | 1501274602412-5973259.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
gres
template1 | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-07-28 20:57:47 | Re: created database but access is not copied ? any suggestions |
Previous Message | Igor Neyman | 2017-07-28 19:53:15 | Re: Issues with lag command |