Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] pg_basebackup issue - Mailing list pgsql-general

From chiru r
Subject Re: [GENERAL] pg_basebackup issue
Date
Msg-id CA+RSxMgF-VwzUXae31WQW9i67HZRHs2XcPfmAu-KBg-zp7xe-Q@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] pg_basebackup issue  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [GENERAL] pg_basebackup issue  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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@gmail.com> wrote:
On Saturday, April 22, 2017, chiru r <chirupg@gmail.com> 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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] pg_basebackup issue
Next
From: Melvin Davidson
Date:
Subject: [GENERAL] Total ram size study