Re: Postgres db corrupted ? - Mailing list pgsql-admin

On Tue, Jul 29, 2003 at 10:38:50AM -0400, Tom Lane mentioned:
> A quick-and-dirty nostrum that sometimes helps for this sort of thing
> is "vacuum full pg_database".  (The idea is to get rid of dead tuples
> that a new backend might be accidentally picking instead of the live
> ones --- it has to read pg_database before it's joined the PROC array,
> which among other things means it can't tell 100% accurately which rows
> are really committed.)

 Ah, OK. That's the sort of help I was hoping to get. Alas, for very
different reasons (I'd run out of ideas), I'd run that myself, with no
gain.

> If no go, could we see the output of "select * from pg_database"?

 Yep, no worries...

postgres=# select * from pg_database;
     datname     | datdba | encoding | datistemplate | datallowconn | datlastsysoid | datvacuumxid | datfrozenxid |
datpath

-----------------+--------+----------+---------------+--------------+---------------+--------------+--------------+---------
 pguser          |        |        0 | f             | t            |         16554 |       611746 |   3221837219 |
 phpuser-654937  |        |        0 | f             | t            |         16554 |       611746 |   3221837219 |
 gestr-654937    |        |        0 | f             | t            |         16554 |       611746 |   3221837219 |
 template0       |      1 |        0 | t             | f            |         16554 |           49 |           49 |
 postgres        |      1 |        0 | f             | t            |         16554 |       658793 |       658793 |
 rob-654937      |        |        0 | f             | t            |         16554 |       611746 |   3221837219 |
 template1       |      1 |        0 | t             | t            |         16554 |       611746 |   3221837219 |
 testtest        |     28 |        0 | f             | t            |         16554 |           49 |           49 |
 dsitestogo      |     33 |        0 | f             | t            |         16554 |           49 |           49 |
 bb1             |     36 |        0 | f             | t            |         16554 |           49 |           49 |
 carlstest       |     37 |        0 | f             | t            |         16554 |           49 |           49 |
 pgdbase         |     38 |        0 | f             | t            |         16554 |           49 |           49 |
 novadance       |     41 |        0 | f             | t            |         16554 |           49 |           49 |
 MyPgSQLTest     |     43 |        0 | f             | t            |         16554 |           49 |           49 |
 forum           |     45 |        0 | f             | t            |         16554 |           49 |           49 |
 ct2             |     48 |        0 | f             | t            |         16554 |           49 |           49 |
 directory       |     49 |        0 | f             | t            |         16554 |           49 |           49 |
 faqsection      |     50 |        0 | f             | t            |         16554 |           49 |           49 |
 demo            |     51 |        0 | f             | t            |         16554 |           49 |           49 |
 planetepochdb   |     53 |        0 | f             | t            |         16554 |           49 |           49 |
 bbadmin         |        |        0 | f             | t            |         16554 |           49 |           49 |
 shanecody       |        |        0 | f             | t            |         16554 |           49 |           49 |
 dmduffy-654937  |        |        0 | f             | t            |         16554 |           49 |           49 |
 zozallen-665478 |        |        0 | f             | t            |         16554 |           49 |           49 |
 zozhugh-665478  |        |        0 | f             | t            |         16554 |           49 |           49 |
 zozea           |     41 |        0 | f             | t            |         16554 |           49 |           49 |
(26 rows)

John