Re: [ADMIN] how to REINDEX pg_database on

2009-07-20 Thread Joshua Daniel Franklin
On Mon, Jul 20, 2009 at 11:00 AM, Alvaro Herrera wrote: > Joshua Daniel Franklin escribió: > >> xbrain_queries=# \d >> No relations found. > > Hmmm, seems your Xid counter wrapped around.  Have you vacuumed the > system catalogs in that database?  Particularly p

Re: [ADMIN] how to REINDEX pg_database on

2009-07-20 Thread Joshua Daniel Franklin
On Mon, Jul 20, 2009 at 8:39 AM, Alvaro Herrera wrote: > Joshua Daniel Franklin escribió: >> > postgres -P -D /usr/local/databases/pgsql/data pg_database >> > FATAL: database "pg_database" does not exist >> >> So... does that 'FATAL: database &q

Re: [ADMIN] how to REINDEX pg_database on

2009-07-20 Thread Joshua Daniel Franklin
On Thu, Jul 16, 2009 at 12:18 PM, Joshua Daniel Franklin wrote: > I'm having a problem with Postgres 7.4 on RHEL  4 (Nahant Update 8). > It seems that pg_database disappeared some time ago (I think before > my oldest backups, unfortunately). > > I searched and found some mentio

[ADMIN] how to REINDEX pg_database on

2009-07-16 Thread Joshua Daniel Franklin
I'm having a problem with Postgres 7.4 on RHEL 4 (Nahant Update 8). It seems that pg_database disappeared some time ago (I think before my oldest backups, unfortunately). I searched and found some mention of REINDEX but I'm not sure if I am using it correctly since this is a system catalog. I tri