pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
transaction ID wrap limit is 1073878048
3+ messages / 3 participants
[nested] [flat]

* transaction ID wrap limit is 1073878048
@ 2006-07-28 18:12  Abu Mushayeed <amushayeed@hotmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Abu Mushayeed @ 2006-07-28 18:12 UTC (permalink / raw)
  To: pgsql-admin; +Cc: tgl@sss.pgh.pa.us

Hello,

We just migrated our database to 8.1.3 from 7.4.12. I am noticing messages 
like

2006-07-16 03:30:22 PDTpostgrescansasLOG:  transaction ID wrap limit is 
1073878048, limited by database "webcalendar".

When we migrated, we had done a full vacuum of each database.

What is the cause of the problem. How can I fix this?


Thank you
Abu





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: transaction ID wrap limit is 1073878048
@ 2006-07-28 18:25  Tomeh, Husam <htomeh@firstam.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Tomeh, Husam @ 2006-07-28 18:25 UTC (permalink / raw)
  To: Abu Mushayeed <amushayeed@hotmail.com>; pgsql-admin; +Cc: tgl@sss.pgh.pa.us


This is normal with postgresql 8.1 and above. With autovacuum turned on
in 8.1 (default), this reminder that you get every time you start up
your postgres server becomes merely informative, and no need to be of
concern. If your autovacuum is turned off, you need either to turn it on
(mostly recommended) or schedule a job to vacuum regularly to avoid
hitting the transaction wrap limit issue later on.


--
  Husam 
  http://firstdba.googlepages.com


-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Abu Mushayeed
Sent: Friday, July 28, 2006 11:12 AM
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us
Subject: [ADMIN] transaction ID wrap limit is 1073878048

Hello,

We just migrated our database to 8.1.3 from 7.4.12. I am noticing
messages 
like

2006-07-16 03:30:22 PDTpostgrescansasLOG:  transaction ID wrap limit is 
1073878048, limited by database "webcalendar".

When we migrated, we had done a full vacuum of each database.

What is the cause of the problem. How can I fix this?


Thank you
Abu



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged.  If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited.  If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

                                   FADLD Tag
**********************************************************************




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: transaction ID wrap limit is 1073878048
@ 2006-07-28 18:38  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Abu Mushayeed <amushayeed@hotmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2006-07-28 18:38 UTC (permalink / raw)
  To: Abu Mushayeed <amushayeed@hotmail.com>; +Cc: pgsql-admin

"Abu Mushayeed" <amushayeed@hotmail.com> writes:
> 2006-07-16 03:30:22 PDTpostgrescansasLOG:  transaction ID wrap limit is 
> 1073878048, limited by database "webcalendar".

These are just for debug purposes.  At some point we might downgrade
them from LOG to DEBUGsomething, but probably not before autovacuum
becomes the universal practice ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-07-28 18:38 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-28 18:12 transaction ID wrap limit is 1073878048 Abu Mushayeed <amushayeed@hotmail.com>
2006-07-28 18:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-07-28 18:25 Re: transaction ID wrap limit is 1073878048 Tomeh, Husam <htomeh@firstam.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox