Logs for PostgreSQL

[jacinthe0020]

Hello..

I need help on logs.. im still working on my system and finally i already have a functional system.. however i have an issue on systems logs, where i record every action the user takes...

Actually, i created a new table for logs and inserted data into it after every user's action.. but when i checked on the table's rows.. there are about 22000 results. is that a bad or good thing? is there any way i can reduce it? any suggestion for recording logs in postgresql?? will it affect the database's maximum storage or capacity..

thank in advance...

[NeoPa]

I found this thread languishing in Feedback, so I moved it over for you guys to look at, and bumped it.

[rski]

Well if you log every insert, the log table is as big as many inserts have been made.
1) You can backup the log table with pg_dump tools and clear the table when backup done.
2) Why don't you log inserts with postgres loggin daemon? It is enough to set some parameters in postgresql.conf file and all sql statements would be put into the file.