Help me about pgSQL

jsalbert

Dear all,

I use Linux(RH) and postgres as my batabase engine.
I have to add about 40 records per 15 sec. 2 month ago, my database was locked and crashed. It showed


 "cannot find attribute 3 of relation pg_am"

I did not know how to solve. I then delete the database and recreate one. I think maybe that is just a system mistake and it won't happen again. It happened yesterday. I could not bare it again. Because tons of my data is inside, about 2 million records.

Do anybody ever see this problem???

I want to save my data back!! Help me!

p.s. Does PGSQL have the record number limitation under 5 million??

thank you!

albert:rolleyes: :rolleyes:

[deleted]

Which version of pgSQL are you running?

And why panic, you do have daily backups don't you?

"Does PGSQL have the record number limitation under 5 million?? "

Ofcourse not 🙂

jsalbert

Originally posted by vincente
Which version of pgSQL are you running?

And why panic, you do have daily backups don't you?

"Does PGSQL have the record number limitation under 5 million?? "

Ofcourse not 🙂

Thank you for your reply.
I am running postgreSQL 7.1.2

Now, only 1 database cannot be accessed, the others are running.
no matter I use ZDE or php engine. It shows the same error message which I posted.
Does anyone know how to access the data??
If I could get the data from the locked database, I would reinstall all the things.

thank you very much

[deleted]

Firstly, it may be a good idea to upgrade to a mre recent version of postgresql, because there have been many improvements from 7.1 to 7.2

!!! NOTE: Upgrading means you must rebuild all databases !!!

As near as I can tell, the error you get is related to the pg_am table, which holds information about the indexes used in the various tables. Perhaps you have a problem with the number of indexes, or the way you create/use indexes?

About the backups, you create them daily, or twice-daily if required. The point is that if your datyabase 'crashes' and you cannot repair it, you just drop it completely and refert to the backup. That way you lose some data, but at least you can continue. A locked table is just as useless as a lost table.