We have been running PostgreSQL for six months. In that time we have had
several problems. We keep getting blank entries in the database with no
data, just nulls. To solve this problem we have had to go in and delete the
blank entries.
We keep also keep getting errors such as the following:
ERROR: No one parent tuple was found
vacuumdb: database vacuum failed on emoldb.
This causes us to have to restore the database and loose data. Our question
is what are we doing wrong? I have heard of many examples of larger
databases that are hit harder that ours. The database is 40 megs and we
process 20 queries/min. We are running PostgreSQL 6.5.3 on RedHat Linux
version 6.1
E-mol Development
Team
http://www.e-mol.com
