Thread: Re: How to install login_hook in Postgres 10.5
Hello Community, While I was searching for logon trigger in postgres similar to that of Oracle, I came across "login_hook", which can be installed as a Postgres database extension to mimic a logon trigger. But I tried to install but failed. Error is that it could not find its .so file. Could you please help me in installing this login_hook ?? Looking forward to hear from you. Any suggestions would be of great help! Thanks & Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
Hello, This extension https://github.com/splendiddata/login_hook seems very interesting ! But I didn't test it myself and maybe the best place to ask support is there https://github.com/splendiddata/login_hook/issues For information there is something equivalent in core "[PATCH] A hook for session start" https://www.postgresql.org/message-id/flat/20171103164305.1f952c0f%40asp437-24-g082ur#d897fd6ec551d242493815312de5f5d5 that finished commited "pgsql: Add hooks for session start and session end" https://www.postgresql.org/message-id/flat/575d6fa2-78d0-4456-8600-302fc35b2591%40dunslane.net#0819e315c6e44c49a36c69080cab644d but was finally rollbacked because it didn't pass installcheck test ... Maybe you are able to patch your pg installation, it would be a solution of choice (there is a nice exemple of extension included) Showing interest for this may also help getting this feature back ;o) Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
On Mon, May 13, 2019 at 01:06:10PM -0700, legrand legrand wrote: > that finished commited > "pgsql: Add hooks for session start and session end" > https://www.postgresql.org/message-id/flat/575d6fa2-78d0-4456-8600-302fc35b2591%40dunslane.net#0819e315c6e44c49a36c69080cab644d > > but was finally rollbacked because it didn't pass installcheck test > ... > > Maybe you are able to patch your pg installation, > it would be a solution of choice (there is a nice exemple > of extension included) You will need to patch Postgres to add this hook, and you could basically reuse the patch which has been committed once. I don't think that it would be that much amount of work to get it working correctly on the test side to be honest, so we may be able to get something into v13 at this stage. This is mainly a matter of resources though, and of folks willing to actually push for it. -- Michael
Attachment
On 5/13/19 8:32 PM, Michael Paquier wrote: > On Mon, May 13, 2019 at 01:06:10PM -0700, legrand legrand wrote: >> that finished commited >> "pgsql: Add hooks for session start and session end" >> https://www.postgresql.org/message-id/flat/575d6fa2-78d0-4456-8600-302fc35b2591%40dunslane.net#0819e315c6e44c49a36c69080cab644d >> >> but was finally rollbacked because it didn't pass installcheck test >> ... >> >> Maybe you are able to patch your pg installation, >> it would be a solution of choice (there is a nice exemple >> of extension included) > > You will need to patch Postgres to add this hook, and you could > basically reuse the patch which has been committed once. I don't > think that it would be that much amount of work to get it working > correctly on the test side to be honest, so we may be able to get > something into v13 at this stage. This is mainly a matter of > resources though, and of folks willing to actually push for it. I am interested in this, so if Andrew wants to create a buildfarm module I will either add it to rhinoceros or stand up another buildfarm animal for it. I am also happy to help push it for v13. Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
Attachment
On 5/14/19 8:34 AM, Joe Conway wrote: > On 5/13/19 8:32 PM, Michael Paquier wrote: >> On Mon, May 13, 2019 at 01:06:10PM -0700, legrand legrand wrote: >>> that finished commited >>> "pgsql: Add hooks for session start and session end" >>> https://www.postgresql.org/message-id/flat/575d6fa2-78d0-4456-8600-302fc35b2591%40dunslane.net#0819e315c6e44c49a36c69080cab644d >>> >>> but was finally rollbacked because it didn't pass installcheck test >>> ... >>> >>> Maybe you are able to patch your pg installation, >>> it would be a solution of choice (there is a nice exemple >>> of extension included) >> You will need to patch Postgres to add this hook, and you could >> basically reuse the patch which has been committed once. I don't >> think that it would be that much amount of work to get it working >> correctly on the test side to be honest, so we may be able to get >> something into v13 at this stage. This is mainly a matter of >> resources though, and of folks willing to actually push for it. > > I am interested in this, so if Andrew wants to create a buildfarm module > I will either add it to rhinoceros or stand up another buildfarm animal > for it. I am also happy to help push it for v13. > I've just been looking at this again. I think the right way to test it is not to use the regression framework but to use a TAP test that would preload the test module. Then it would just happen as part of all the other TAP tests with no extra buildfarm module needed. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Hello, shouldn't we update associated commitfest entry https://commitfest.postgresql.org/15/1318/ to give it a chance to be included in pg13 ? Regards PAscal -- Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
On Thu, Aug 01, 2019 at 05:01:17AM -0700, legrand legrand wrote: > Shouldn't we update associated commitfest entry > https://commitfest.postgresql.org/15/1318/ > > to give it a chance to be included in pg13 ? Well, it is mainly a matter of finding somebody willing to do the legwork, in which case I would let the past commit fest entry as it is, and create a new one once a new patch is ready to be reviewed. -- Michael
Attachment
pavan95 wrote > Hello Community, > > While I was searching for logon trigger in postgres similar to that of > Oracle, I came across "login_hook", which can be installed as a Postgres > database extension to mimic a logon trigger. > > But I tried to install but failed. Error is that it could not find its .so > file. Could you please help me in installing this login_hook ?? > > Looking forward to hear from you. Any suggestions would be of great help! > > Thanks & Regards, > Pavan > > > > -- > Sent from: > http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html issue ERROR: could not access file "login_hook.so": No such file or directory has been fixed see: https://github.com/splendiddata/login_hook/issues/1 Regards PAscal -- Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html