Postgres Pro
Downloads
Home   >   mailing lists

Re: Who dropped a role? - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Who dropped a role?
Date
Msg-id CANu8Fiwyb1PSWEk4d4vO=xjWdw=Di5pKrXLFWJej4JBimZHQjg@mail.gmail.com
Whole thread Raw
In response to Re: Who dropped a role?  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
List pgsql-general
Tree view


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.

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Importing SQLite database
Next
From: Igor Korot
Date:
Subject: Re: Importing SQLite database