Skip site navigation (1) Skip section navigation (2)

log results

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 (view raw or flat)
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

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-10-08 23:13:10
Subject: Re: log results
Previous:From: Evan RempelDate: 2008-10-08 22:02:12
Subject: LDAP authentication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group