| From: | Juan Pablo Espino <jp(dot)espino(at)gmail(dot)com> |
|---|---|
| To: | Rod Taylor <pg(at)rbt(dot)ca> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Login/logout |
| Date: | 2005-06-18 19:33:03 |
| Message-ID: | 3e7daec1050618123368a7a4eb@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi, thanks for the response.
On 6/18/05, Rod Taylor <pg(at)rbt(dot)ca> wrote:
> On Sat, 2005-06-18 at 11:46 -0500, Juan Pablo Espino wrote:
> > Thanks for the quick response. Yes I want to retrieve the
> > login/logout info, but I want to insert this info in a table that I
> > use as an audit table. Regards
>
> I suggest putting together a short script to scan the logs periodically
> and add the new entries to your table.
>
It sounds to me good in order to resolve my problem. Nevertheless I
think that it would be very useful to have a function that does
something like "select login()" and gives back to the date and time of
login, or that we can retrieve that info from the system catalogs.
Regards,
Juan P. Espino
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-06-18 19:33:43 | pgsql: Add a time-of-preparation column to the pg_prepared_xacts view, |
| Previous Message | Josh Berkus | 2005-06-18 19:31:06 | Checkpointing problem with new buffer mgr. |