| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Please HELP - URGENT - transaction wraparound error |
| Date: | 2005-10-30 17:54:52 |
| Message-ID: | 12531.1130694892@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
John Sidney-Woollett <johnsw(at)wardbrook(dot)com> writes:
> OK, I restored the pgsql/data to another server and started up postgres
> and this is what I got:
> SELECT datname, age(datfrozenxid) FROM pg_database;
> datname | age
> --------------+-------------
> mail_lxtreme | -2074187459
> bp_live | 1079895636
> template1 | 1076578064
> template0 | -2074187459
> (4 rows)
> mail_lxtreme is a test mail db and I don't care about it. So it could
> have been deleted without any worries...
> Which databases are a problem? Is it template0 or bp_live and template1?
mail_lxtreme is exactly the problem. You weren't vacuuming it...
(template0 is a special case and can be ignored.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikolay Samokhvalov | 2005-10-30 18:24:52 | Oracle 10g Express - any danger for Postgres? |
| Previous Message | John Sidney-Woollett | 2005-10-30 16:51:44 | Re: Please HELP - URGENT - transaction wraparound error |