Received: from svr4.applink.net (svr4.applink.net [216.91.192.4]) by hub.org (8.10.1/8.10.1) with ESMTP id e7U0dpC08526; Tue, 29 Aug 2000 20:39:51 -0400 (EDT) Received: from riemann.ashavan.org (56k-01-77.applink.net [216.91.196.77]) by svr4.applink.net (8.10.1/8.10.1) with SMTP id e7U0cik25667; Tue, 29 Aug 2000 19:38:48 -0500 Subject: =?US-ASCII?Q?HELP pg=5Fproc is corrupted!?= From: Timothy Covell Reply-To: Timothy Covell Message-ID: <0003700605e5b312_mailit@smtp.applink.net> References: <20000826221523.15597.qmail@kahuna.versions.com> <12490.967471440@sss.pgh.pa.us> <39AA7EEA.8D4E2FA7@tivoli.com> Date: Tue, 29 Aug 2000 19:41:41 -0500 X-Mailer: BeatWare Mail-It 3.0 X-BeOS-Platform: Intel or clone To: pgsql-sql@postgresql.org Cc: sql@postgresql.org, dirac@applink.net Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-Archive-Number: 200008/353 OK, I before any starts on my about backups...I have one a week old, but I want to fix this the right way! (and I want this past week's worth of data. What happened: o downloaded ip and macaddr type programs written by Paul Vixie et al., scrapped the ip stuff, and compiled the macaddr stuff. Ran the included sql script to load the "mac.so" file, create the custom macaddr type in and out functions, etc. At this point everything is good. o downloaded latest copy of IEEE MAC Address to Vendor list. Updated the mac.h file and recompiled the module. o Dropped all the functions and the types. o Re-ran the SQL script to create the handler, type, functions, etc after putting the new mac.so module in the proper path. o All hell breaks loose: o use functions are missing from pgaccess o pg_dump dies with invalid OID number(s) o multiple instances of macaddr definitions in pg_proc... o Tried to fix this with a reindex, but I was told that I had to drop the DB into single user mode, I tried this but the directions don't jive with pg_ctl nor with postmaster. I can't figure how to get to single mode.... Questions: 1. How do I to get the DB into single user mode? 2. How can I fix this problem? TIA. tim dirac@applink.net