Date: Tue, 16 Jan 2001 10:21:18 +0200
From: Johann Spies <jhspies@adept.co.za>
To: pgsql-sql@postgresql.org
Subject: Re: pg_dump error
Message-ID: <20010116102118.A759@adept.co.za>
Mail-Followup-To: Johann Spies <jhspies@adept.co.za>, pgsql-sql@postgresql.org
References: <20010115221325.A18814@adept.co.za>
	<3.0.5.32.20010116120349.02e707d0@mail.rhyme.com.au>
	<20010116101929G.t-ishii@sra.co.jp> <29546.979609006@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <29546.979609006@sss.pgh.pa.us>;
	from tgl@sss.pgh.pa.us on Mon, Jan 15, 2001 at 08:36:46PM -0500

On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote:
> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> >>>> Can not create pgdump_oid table.  Explanation from backend: 'ERROR:
> >>>> cannot create pgdump_oid
> >>>> 
> >>>> Is there a way to repair this?
> 
> I would guess that this means there is a file named "pgdump_oid" hanging
> around in the database directory, no doubt leftover from some previous
> pg_dump cycle.  Manually removing the file should get you up and running
> again.  However, that just begs the question of why the file is there...
> 

I found the file "pgdump_oid" and removed it.  Running the dump script
after that resulted in:
------------------------
"$Can not drop pgdump_oid table.  Explanation from backend:
'pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
'."
------------------------
Running the same script 
(pg_dump js -o -c -f /home/js/psql/jhspiesdb.out)

a second time:
-------------------------
'Can not create pgdump_oid table.  Explanation from backend: 'ERROR:
cannot create pgdump_oid
'.
----------------------------------
Trying after that to "drop table pgdump_oid" resulted in:
------------------------
js=> drop table pgdump_oid;
QUERY: drop table pgdump_oid;
ERROR:  Relation 'pgdump_oid' does not exist
ERROR:  Relation 'pgdump_oid' does not exist
------------------------

Also doing \dt in psql resulted in an seemingly endless loop with no
output produced.  I had to kill psql.

However, my other applications using postgresql is still working.

I also tried reinstalling postgresql.  The process also resulted in
errors (one was a message about not being able to find a file with the
name "can_i_run") and when the installation script (Debian) tried to
dump the data it also failed. In the end I had postgresql running
again but the same pg_dump problem remains.

Regards.

Johann
-- 
J.H. Spies - Tel. 082 782 0336 
     "Jesus said unto her, I am the resurrection, and the 
      life; he that believeth in me, though he were dead, 
      yet shall he live"                John 11:25