From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Oleg Samoylov <olleg(at)jane(dot)telecom(dot)mipt(dot)ru> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Logging for psql only |
Date: | 2003-03-06 03:10:39 |
Message-ID: | 200303060310.h263Adx04272@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
If you want to log everything via psql, you can use "SET log_statement
TO on" inside .psqlrc and that will show all psql commands in the server
logs, or you can use per-user settings using ALTER USER, all in 7.3.
---------------------------------------------------------------------------
Oleg Samoylov wrote:
> Al Sutton wrote:
> > Does anyone have a solution to the following situation;
> >
> > I have an application which uses postgresql as its database, I also have te=
> > chnicians who need to made occasional data changes using psql, is there any=
> > way to log the changes made by the technicians without logging the SQL sta=
> > tements from the application?
> >
> > Al.
>
> At http://gborg.postgresql.org you can find one or two data change
> logging function working per user.
>
> --
> Olleg Samoylov
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-03-06 04:34:37 | Re: uppercase = lowercase |
Previous Message | gborges | 2003-03-06 02:02:25 | Miss of global directory |