Re: The same role for multiple databases

Provided you're just performing a simple pg_upgrade without making schema
changes or any wholesale database changes, then, even if the upgrade is a
major version change, you really shouldn't have any issues. At least I've
never had any problems with this.
--
Jay

On Mon, Mar 13, 2017 at 5:30 AM, Poul Kristensen <bcc5226(at)gmail(dot)com> wrote:

> Thanks for fast responce.
>
> Could this iteraction roles, schemas, databases - e.g. configurations in
> pg_hba.conf - between multiple databases and different Postgres minor
> version e.g. 9.6 to 9.6.1 cause trouble when upgrading still between minor
> versions?
> An if any potential problems would this be announced in release comments.
>
> Thanks.
>
>
>
>
>
> 2017-03-10 16:17 GMT+01:00 John Scalia <jayknowsunix(at)gmail(dot)com>:
>
>> Yes, (or is that too glib?)
>>
>> Roles are global in postgresql, so it's just a simple grant assignment.
>> --
>> Jay
>>
>> On Fri, Mar 10, 2017 at 9:16 AM, Poul Kristensen <bcc5226(at)gmail(dot)com>
>> wrote:
>>
>>>
>>> Hi!
>>>
>>> Is it possible to grant some priviliges for a role to multiple databases?
>>>
>>> Just to illustrate:
>>> grant all priviliges on database1 to role a.
>>> grant all priviliges on database2 to role a.
>>>
>>>
>>> Thanks!
>>>
>>> Poul
>>>
>>>
>>>
>>>
>>>
>>
>
>
> --
> Med venlig hilsen / Best regards
> Poul Kristensen
> Linux-OS/Virtualizationexpert and Oracle DBA
>