|
hello, i found this ERROR msg at our postgresql log
file at one of my client.
what i did is i
1) kill -9 (postmaster process id).
2) remove the postmaster.pid file under
/usr/local/pgsql/data/
3) restart the postmaster process.
then no more error msg in the postgresql log
file.
problem come back few day later cause when i check
the log file this morning, i saw the msg again.
the error msg will come out when we try to read
record from the temporary table that created before.
so, i suspect the relid is refer to temporary
table.(relation id), right?
what i did just restart the postmaster process
should not be enough to solve the problem.. can
someone give some advise on how to solve this problem?
Client Server Configuration
Postgresql 7.4.5 version.
Red Hat enterprise server 3.0
version
RAM 512MB
Dell PowerEdge 1800.
Regards
Beh
|
