Thanks! vacuum did get rid of those messages. The last time
import/rebuild worked it took over 2hrs, now it's down to 30min!
But the original problem ...
I'm finally starting to get some log entries, but they are in
/var/pgsql/log instead of /var/pgsql/postmaster.log - any ideas? probably
an OpenBSd thing with pgwrap - I'll try an OpenBSD newsgroup.
Frank
At 08:48 AM 10/19/00 -0700, Jerry Tangren wrote:
>Frank, I was also encountering those errors until
>I began to regularly issue the vacuum on the database.
>Haven't had any problems since.
>
>--Jerry <tangren@wsu.edu>
>
>At 09:37 AM 10/19/2000 -0400, you wrote:
>>Here's my pgsql startup command (OpenBSD 2.6):
>>
>>/usr/local/bin/pgwrap -o /var/pgsql/log postmaster -i -o -F >>
>>/var/pgsql/postmaster.log 2>&1 &
>>
>>When I run my PHP routine, I get this:
>>
>>Warning: PostgresSQL query failed: pqReadData() -- backend closed the
>>channel unexpectedly. This probably means the backend terminated
>>abnormally before or while processing the request. in db_pgsql.inc on
>>line 52
>>Database error: Invalid SQL: INSERT INTO gedcom_grp
>>(grpkey1,grpseq,grpkey2) VALUES('I0000016','1','F0000067')
>>PostgreSQL Error: 1 (pqReadData() -- backend closed the channel
>>unexpectedly. This probably means the backend terminated abnormally
>>before or while processing the request. )
>>Session halted.
>>
>>The program is trying to do an initial load of three tables. It starts by
>>deleting all rows in these three tables, then manages to add 13 rows to
>>gedcom_grp before the above error.
>>
>>But both log files mentioned in the startup command are empty?
>>
>>Frank
>
>
>