Thread: Logging for psql only

Logging for psql only

From
"Al Sutton"
Date:
Hi,

Does anyone have a solution to the following situation;
 
I have an application which uses postgresql as its database, I also have technicians 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 statements from the application?
 
Al.

Re: Logging for psql only

From
Oleg Samoylov
Date:
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


Re: Logging for psql only

From
Bruce Momjian
Date:
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@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073