Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
postgresql: transaction wrap limit
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
pactoo
Guru
Guru


Joined: 18 Jul 2004
Posts: 553

PostPosted: Tue Jun 27, 2006 1:38 pm    Post subject: postgresql: transaction wrap limit Reply with quote

The log of my usually quite bored postgresql rdbms has tons of log entries as follows:

Code:

transaction ID wrap limit is 1075588879, limited by database >>postgres<<


This message appears for every database. I am just wondering wether this is normal or is an indication for some kind of problem. Activating autovacuum did not change anything, but the database is way too small anyway to even come remotely close to a transaction ID wraparound.

So anything to worry about?
Back to top
View user's profile Send private message
Beefrum
Apprentice
Apprentice


Joined: 23 May 2006
Posts: 234

PostPosted: Tue Jun 27, 2006 2:16 pm    Post subject: Reply with quote

How would I know :roll:

Me thinks, they want you to alter this value so you aware of this setting. {Weirdest number I've seen.}
Once you reach this number your transaction ID's will start with the old values.

So NO ROLLBACK NO MORE. If you catch my meaning :!:
_________________
:? Give adaptive answers to unknown problems!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum