agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: srilinux <srilinux09@gmail.com>
To: pgsql-sql@postgresql.org
Subject: created database but access is not copied ? any suggestions
Date: Fri, 28 Jul 2017 13:43:22 -0700 (MST)
Message-ID: <1501274602412-5973259.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 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-tp597325...
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
view thread (5+ messages) latest in thread
Message-ID: <1501274602412-5973259.post@n3.nabble.com>
Permalink: ../1501274602412-5973259.post@n3.nabble.com/
Also on: postgresql.org/message-id/1501274602412-5973259.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: created database but access is not copied ? any suggestions
In-Reply-To: <1501274602412-5973259.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