agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedcreated database but access is not copied ? any suggestions
5+ messages / 2 participants
[nested] [flat]
* created database but access is not copied ? any suggestions
@ 2017-07-28 20:43 srilinux <srilinux09@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: srilinux @ 2017-07-28 20:43 UTC (permalink / raw)
To: 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-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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: created database but access is not copied ? any suggestions
@ 2017-07-28 20:57 David G. Johnston <david.g.johnston@gmail.com>
parent: srilinux <srilinux09@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: David G. Johnston @ 2017-07-28 20:57 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: pgsql-sql
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: created database but access is not copied ? any suggestions
@ 2017-07-28 21:16 srilinux <srilinux09@gmail.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: srilinux @ 2017-07-28 21:16 UTC (permalink / raw)
To: pgsql-sql
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-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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: created database but access is not copied ? any suggestions
@ 2017-07-28 23:00 David G. Johnston <david.g.johnston@gmail.com>
parent: srilinux <srilinux09@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: David G. Johnston @ 2017-07-28 23:00 UTC (permalink / raw)
To: srilinux <srilinux09@gmail.com>; +Cc: pgsql-sql
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?
>
>
Did you maybe mean to write "template" instead of "tablespace"?
David J.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: created database but access is not copied ? any suggestions
@ 2017-07-29 17:38 srilinux <srilinux09@gmail.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: srilinux @ 2017-07-29 17:38 UTC (permalink / raw)
To: pgsql-sql
Yes original command used is template instead of table space
On Friday, July 28, 2017, David G Johnston [via PostgreSQL] <
ml+s1045698n5973303h92@n3.nabble.com> wrote:
>
>
> On Friday, July 28, 2017, srilinux <[hidden email]
> <http:///user/SendEmail.jtp?type=node&node=5973303&i=0>; 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
> <http://www.postgresql-archive.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=597325...;
> .
> NAML
> <http://www.postgresql-archive.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21...;
>
--
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2017-07-29 17:38 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-07-28 20:43 created database but access is not copied ? any suggestions srilinux <srilinux09@gmail.com>
2017-07-28 20:57 ` David G. Johnston <david.g.johnston@gmail.com>
2017-07-28 21:16 ` srilinux <srilinux09@gmail.com>
2017-07-28 23:00 ` David G. Johnston <david.g.johnston@gmail.com>
2017-07-29 17:38 ` srilinux <srilinux09@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox