pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Timothy Covell <dirac@applink.net>
To: pgsql-sql@postgresql.org
Cc: sql@postgresql.org
Cc: dirac@applink.net
Subject: HELP pg_proc is corrupted!
Date: Tue, 29 Aug 2000 19:41:41 -0500
Message-ID: <0003700605e5b312_mailit@smtp.applink.net> (raw)
References: <20000826221523.15597.qmail@kahuna.versions.com>
	<12490.967471440@sss.pgh.pa.us>
	<39AA7EEA.8D4E2FA7@tivoli.com>



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




Message-ID: <0003700605e5b312_mailit@smtp.applink.net>
Permalink:  ../0003700605e5b312_mailit@smtp.applink.net/
Also on:    postgresql.org/message-id/0003700605e5b312_mailit@smtp.applink.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: dirac@applink.net, sql@postgresql.org
  Subject: Re: HELP pg_proc is corrupted!
  In-Reply-To: <0003700605e5b312_mailit@smtp.applink.net>
  References: <20000826221523.15597.qmail@kahuna.versions.com> <12490.967471440@sss.pgh.pa.us> <39AA7EEA.8D4E2FA7@tivoli.com> <0003700605e5b312_mailit@smtp.applink.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox