PostgreSQL 8.1.0 catalog corruption

From: Bob Ippolito <bob(at)redivi(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: PostgreSQL 8.1.0 catalog corruption
Date: 2005-11-21 19:31:04
Message-ID: 302143A2-FA7C-4A01-B2B6-50AB1E7CB885@redivi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I've been running 8.1.0 on a test box since the FreeBSD port has been
available, and it appears that the catalog has become corrupted.
There's plenty of free space on all volumes, so it hasn't run out of
space or anything.

$ uname -a
FreeBSD shi.mochibot.com 6.0-RELEASE FreeBSD 6.0-RELEASE #2: Mon Nov
7 14:34:52 PST 2005 root(at)shi(dot)mochibot(dot)com:/usr/obj/usr/src/sys/
CUSTOM i386

$ psql mochi
Welcome to psql 8.1.0, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

mochi=# drop table ping_1132387200;
ERROR: table "ping_1132387200" does not exist
mochi=# create table ping_1132387200();
ERROR: type "ping_1132387200" already exists

I'm not sure what to do about this..

-bob

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-21 19:38:11 Re: OS X 7.4 failure
Previous Message Marc Munro 2005-11-21 19:19:59 Re: [pgsql-hackers] Daily digest v1.5568 (24 messages)