agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Johann Spies <jhspies@adept.co.za>
To: pgsql-sql@postgresql.org
Subject: Re: pg_dump error
Date: Tue, 16 Jan 2001 10:21:18 +0200
Message-ID: <20010116102118.A759@adept.co.za> (raw)
In-Reply-To: <29546.979609006@sss.pgh.pa.us>
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>
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
view thread (12+ messages) latest in thread
Message-ID: <20010116102118.A759@adept.co.za>
Permalink: ../20010116102118.A759@adept.co.za/
Also on: postgresql.org/message-id/20010116102118.A759@adept.co.za
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jhspies@adept.co.za
Subject: Re: pg_dump error
In-Reply-To: <20010116102118.A759@adept.co.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox