Who dropped a role?
Dear PG Masters!
In a server today I didn't find an important role.
I don't know what my colleagues did with it, but it seems to be lost.
Do you know a trick, how get info about it?
1.) Who dropped it?
2.) If not dropped what happened with it?
Does role dropping logged somewhere?
Thanks for your help!
dd
Hello!
Sorry, meanwhile I found it as Group Role.
I never used this kind of role. How to restore it to normal login role?
Thanks for it!
dd
2016-12-08 9:53 GMT+01:00 Durumdara <durumdara@gmail.com>:
Show quoted text
Dear PG Masters!
In a server today I didn't find an important role.
I don't know what my colleagues did with it, but it seems to be lost.
Do you know a trick, how get info about it?1.) Who dropped it?
2.) If not dropped what happened with it?Does role dropping logged somewhere?
Thanks for your help!
dd
Hello
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Durumdara
Sent: Donnerstag, 8. Dezember 2016 10:13
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Who dropped a role?
Hello!
Sorry, meanwhile I found it as Group Role.
I never used this kind of role. How to restore it to normal login role?
ALTER ROLE ... LOGIN;
You probably need to reassign the password (I don’t remember right now if the pw is dropped when changing form LOGIN to NOLOGIN).
\password ...
Thanks for it!
dd
2016-12-08 9:53 GMT+01:00 Durumdara <durumdara@gmail.com <mailto:durumdara@gmail.com> >:
Dear PG Masters!
In a server today I didn't find an important role.
I don't know what my colleagues did with it, but it seems to be lost.
Do you know a trick, how get info about it?
1.) Who dropped it?
2.) If not dropped what happened with it?
Does role dropping logged somewhere?
Thanks for your help!
dd
On Thu, Dec 8, 2016 at 4:34 AM, Charles Clavadetscher <
clavadetscher@swisspug.org> wrote:
Hello
*From:* pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@
postgresql.org] *On Behalf Of *Durumdara
*Sent:* Donnerstag, 8. Dezember 2016 10:13
*To:* pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] Who dropped a role?Hello!
Sorry, meanwhile I found it as Group Role.
I never used this kind of role. How to restore it to normal login role?
ALTER ROLE ... LOGIN;
You probably need to reassign the password (I don’t remember right now if
the pw is dropped when changing form LOGIN to NOLOGIN).\password ...
Thanks for it!
dd
2016-12-08 9:53 GMT+01:00 Durumdara <durumdara@gmail.com>:
Dear PG Masters!
In a server today I didn't find an important role.
I don't know what my colleagues did with it, but it seems to be lost.
Do you know a trick, how get info about it?
1.) Who dropped it?
2.) If not dropped what happened with it?
Does role dropping logged somewhere?
Thanks for your help!
dd
*In addition to the info on how to reset the role to login, you might want
to make sure that, at minimum, you have log_statement = 'ddl' in
postgresql.conf and do a SELECT pg_reload_conf();*
*That way, all DDL type statements will be recorded in the postgres log.*
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.