Well, I took Thomas' advice and upgraded to 7.0.2 from source.tar.gz.
For some reason, I cannot create the following index:
db_geocrawler=# DROP INDEX idx_mail_archive_list_subject;
ERROR: index "idx_mail_archive_list_subject" nonexistent
db_geocrawler=# CREATE INDEX "idx_mail_archive_list_subject" on
"tbl_mail_archive" using btree ( "fld_mail_
list" "int4_ops", "fld_mail_subject" "text_ops" );
ERROR: cannot create idx_mail_archive_list_subject
[root@geocrawler db_geocrawler]# rm -f idx_mail_archive_list_subject
That removes the physical file on disk, so I can then try to create it
again. If I then issue the SQL command, postgres accepts it and it runs
forever, never creating more than an 8192 byte file.
If you watch your process list:
[root@geocrawler db_geocrawler]# ps ax PID TTY STAT TIME COMMAND 457 ? SW 0:00 [postmaster]1419 ?
R 1:34 [postmaster]
Eventually, the psql connection disappears from the process list and I
get strange postmaster processes running (see above).
After that, I get this error from psql:
ERROR: btree: index item size 2820 exceeds maximum 2717
Any way to tell where that item is at?
From the pgserver.log file:
DEBUG: Data Base System is starting up at Tue Jul 11 16:59:33 2000
DEBUG: Data Base System was interrupted being in production at Tue Jul
11 15:47:04 2000
DEBUG: Data Base System is in production state at Tue Jul 11 16:59:33
2000
...Doesn't give me much to go on.
I'm really at wits end - I've spent over two days trying to rebuild
Geocrawler.
Next step is reformatting the hard disk and reinstalling postgres 6.4.2.
Tim
--
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723