WARNING: Some databases have not been vacuumed in over 2 billion transactions.
You may have already suffered transaction-wraparound data loss.while doing a routine vacuum. Tom Lane answered but did not have an answer right away.
I got the same message from my redhat installed postgresql-server-7.3.2-3. I tried a vacuum after this message and did not get any warnings.
This is my pg_database.
template1=# select * from pg_database;
datname | datdba | encoding | datistemplate | datallowconn | datlastsysoid | datvacuumxid | datfrozenxid | datpath | datconfig | datacl -----------+--------+----------+---------------+--------------+---------------+--------------+--------------+---------+-----------+-----------------
clime | 100 | 0 | f | t | 16974 | 3226 | 3221228699 | | |
template1 | 1 | 0 | t | t | 16974 | 3449 | 3221228922 | | | {=,postgres=CT}
template0 | 1 | 0 | t | f | 16974 | 427 | 427 | | | {=,postgres=CT}
(3 rows)
Regards,
Ari
**
-- Ari Jolma, [EMAIL PROTECTED], Professor of Geoinformatics Cartography and Geoinformatics, Helsinki University of Technology POBox 1200, 02015 TKK, Finland http://www.hut.fi/Units/Cartography
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
