Tom,
I only see this in pg_clog:
[root@steel data]# ls pg_clog/
0000
No, I had not been running Vacuum on a regular interval. :( I just
added "vacuumdb --all" to my daily cron, though...
On Feb 22, 2004, at 6:04 PM, Tom Lane wrote:
> "Bethany A.Benzur" <bethany@rawkawn.com> writes:
>> Argg... I guess I won't be rebuilding template1 from template0 seeing
>> as I have no template0!! :(
>
>> template1=> UPDATE pg_database SET datallowconn = TRUE
>> template1-> WHERE datname = 'template0';
>> UPDATE 0
>
> Hm. I'm beginning to think you've got a transaction counter wraparound
> issue. What filenames do you have in $PGDATA/pg_clog/ ? How long has
> this database been running, and have you been doing full-database
> VACUUMs at regular intervals? (See the "routine maintenance" section
> of
> the Admin Guide for background.)
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>