| From: | Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | log results |
| Date: | 2008-10-08 23:04:17 |
| Message-ID: | B0D7C0A3F35FE144A70312D086CBCA9BF76D27AF@ExchMailbox2.univ.dir.wwu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I just started logging postgresql. In the log are these entries:
478 LOG: transaction ID wrap limit is 1110972072, limited by database "cswe2"
479 LOG: transaction ID wrap limit is 1110972072, limited by database "cswe2"
480 NOTICE: number of page slots needed (27072) exceeds max_fsm_pages (20000)
481 HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 27072.
Can someone explain what it is and what I need to do to fix it?
I searched online and found references to performing a vacuum on the databases. That is already being done on a nightly basis prior to the backup.
thanks
Marc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-10-08 23:13:10 | Re: log results |
| Previous Message | Evan Rempel | 2008-10-08 22:02:12 | LDAP authentication |