| From: | Gevik Babakhani <pgdev(at)xs4all(dot)nl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Regrading TODO item alerting pg_hba.conf from SQL |
| Date: | 2006-04-17 21:54:38 |
| Message-ID: | 1145310878.16744.10.camel@voyager.truesoftware.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2006-04-17 22:05:39 | Re: Is full_page_writes=off safe in conjunction with |
| Previous Message | Bruce Momjian | 2006-04-17 21:24:45 | Re: Is full_page_writes=off safe in conjunction with PITR? |