Search Postgresql Archives

Re: pg_basebackup issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



But, SUPERUSER privileges are working, you can see above I am able to do CREATEUSER and CREATEDB.

What is the differences in case A and case B for Superuser?

Thanks,
Chiru
  

On Sat, Apr 22, 2017 at 10:45 AM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Saturday, April 22, 2017, chiru r <chirupg@xxxxxxxxx> wrote:
Thank you for the reply.

It is inheriting role attributes. I am able to do CREATEDB,CREATEROLE... etc .
Even i am able to do manual start backup and stop backup also using backup_admin.

So I've recently read that while some role attributes are inherited SUPERUSER is not.  Everything you are seeing work or not works appears to be due to superuser privileges differences.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux