By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,757 Members | 1,990 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,757 IT Pros & Developers. It's quick & easy.

Logs for PostgreSQL

P: 2

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...
Feb 20 '09 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,470
I found this thread languishing in Feedback, so I moved it over for you guys to look at, and bumped it.
Feb 20 '09 #2

Expert 100+
P: 700
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.
Feb 22 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.