Re: Regrading TODO item alerting pg_hba.conf from SQL - Mailing list pgsql-hackers

From Gevik Babakhani
Subject Re: Regrading TODO item alerting pg_hba.conf from SQL
Date
Msg-id 1145310878.16744.10.camel@voyager.truesoftware.nl
Whole thread Raw
In response to Re: Regrading TODO item alerting pg_hba.conf from SQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hello again :)

> It doesn't seem particularly complicated: inside the connection-startup
> transaction done by InitPostgres, you could check to make sure the
> selected user has the CONNECT privilege on the selected database.
> [ looks at code... ]  Actually ReverifyMyDatabase is the right place,
> since it already has its hands on the pg_database row.  You don't want
> this to cost an extra pg_database search during startup.
> 

I looked at the code as suggested. (so far many questions but I guess
all in right time) 

Anyway... would it be correct to start any connection checking 
inside the if statement from line 186 "if (IsUnderPostmaster && !
IsAutoVacuumProcess())" in method ReverifyMyDatabase? Sorry for being
too trivial, but I want to be sure.

Regards,
Gevik.





pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Is full_page_writes=off safe in conjunction with PITR?
Next
From: Gevik Babakhani
Date:
Subject: question regarding pg_database.h and DatabaseRelationId