X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 55C825290F for ; Tue, 2 Aug 2005 22:01:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63568-02 for ; Wed, 3 Aug 2005 01:01:21 +0000 (GMT) Received: from syslog1.bresnan.net (syslog1.bresnan.net [69.145.232.10]) by svr1.postgresql.org (Postfix) with ESMTP id 0C669528CC for ; Tue, 2 Aug 2005 22:01:20 -0300 (ADT) Received: from [69.145.248.18] (HELO cluster1.bresnan.net) by syslog1.bresnan.net (CommuniGate Pro SMTP 4.3.6) with ESMTP id 1831976 for pgsql-admin@postgresql.org; Tue, 02 Aug 2005 19:01:23 -0600 Received: from [69.145.71.97] (HELO [192.168.0.115]) by fe-3.cluster1.bresnan.net (CommuniGate Pro SMTP 4.2.10) with ESMTP id 54527884 for pgsql-admin@postgresql.org; Tue, 02 Aug 2005 19:01:24 -0600 Message-ID: <42F0091F.6000508@cotcomsol.com> Date: Tue, 02 Aug 2005 18:00:31 -0600 From: Brock Williams User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050730) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-admin@postgresql.org Subject: Re: FATAL: cache lookup failed for access method 6881280 References: <42F008F2.60509@cotcomsol.com> <42F011D0.50401@travelamericas.com> In-Reply-To: <42F011D0.50401@travelamericas.com> X-Enigmail-Version: 0.92.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.122 tagged_above=0 required=5 tests=SUBJ_HAS_UNIQ_ID X-Spam-Level: * X-Archive-Number: 200508/23 X-Sequence-Number: 18342 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Yep. I tried starting and stopping a couple of times. I also tried stopping postmaster and starting a single-user mode postgres process. Same result. Brock Chris Travers wrote: > Have you tried restarting the Postmaster? > > Best Wishes, > Chris Travers > Metatron Technology Consulting > > Brock Williams wrote: > > I'm getting this message when I try to access one of the databases in > my cluster: > > FATAL: cache lookup failed for access method 6881280 > > I get the message any way I try to access it: remotely via TCP, > locally on the db server, as well as with a single-user mode postgres > command. > > Any ideas what could be the cause, or what I could do to fix it? All > the other (30+) databases in the cluster appear to be perfectly fine. > > Thanks, > > Brock >> - ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings >> >> >> > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (FreeBSD) iD8DBQFC8AkegMCVEEcrWuIRApjZAJ9qvkzqIvVHKkgKyOfEl/Z3xr0JbACgtc0U 5CsANX2XfrkEkBoXRSPv298= =3uBS -----END PGP SIGNATURE-----