From: | Philip <silvermaple(at)usermail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump error |
Date: | 2004-05-23 19:32:33 |
Message-ID: | 20040523143233.16a78099.silvermaple@usermail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm rather new to database stuff. I've been using postgresql for a
couple years, but that doesn't mean I understand what I'm doing. I have
simply followed the "HOW-TOs". But now I think I'm about to learn a bit
more about the inner workings...
Last week my cron-triggered system-backup began reporting odd errors.
They were block device and limited to just the one partition so I ran
fsck.
Oh, this is a Pentium-Pro based computer running Debian with a 2.4
kernel, SQL-Ledger 2.2.6 as my frontend, postgresql 7.2.
So on with the story. fsck found a number of problems and I let it fix
them all. No, I don't remember what the problems were. *grimace* The
system backup is no longer yelling at me - but now my pg_dump is!
It says:
pg_dump: NOTICE: RelationBuildDesc: can't open pga_images: No such file or directory
pg_dump: SQL command to dump the contents of table "pga_images" failed
pg_dump: Error message from server: ERROR: cannot open pga_images: No such file or directory
pg_dump: The command was: COPY "pga_images" TO stdout;
Also, the Debian do.maintainence script is reporting:
NOTICE: RelationBuildDesc: can't open pga_images: No such file or directory
ERROR: _mdfd_getrelnfd: cannot open relation pga_images: No such file or directory
So I tried:
$ /usr/lib/postgresql/bin/vacuumdb -z -d mydata
NOTICE: RelationBuildDesc: can't open pga_images: No such file or directory
ERROR: _mdfd_getrelnfd: cannot open relation pga_images: No such file or directory
vacuumdb: vacuum mydata failed
Okay, now I'm stumped! Since I don't even know what "pga_images" is for
I don't no how much trouble I'm in! Should I worry? Am I doomed? Can it
be repaired? Will my computer explode and infect my neighborhood? (Have
I used too many question-marks?) Nothing else seem to be broken, just the error messages about pga_images..
Philip,
a bit worry about my database...
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-05-23 20:47:38 | Re: how many record versions |
Previous Message | Özgür Çetiner | 2004-05-23 18:58:15 | MySQL Conversion |