From: | Frank Bax <fbax(at)execulink(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Jerry Tangren <tangren(at)wsu(dot)edu> |
Subject: | Re: OpenBSD startup - no logfile? |
Date: | 2000-10-19 18:37:39 |
Message-ID: | 3.0.6.32.20001019143739.0178f270@execulink.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)wsu(dot)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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michelle Murrain | 2000-10-19 18:46:11 | Re: MySQL -> pgsql |
Previous Message | Yohans Mendoza | 2000-10-19 18:19:34 | to_char |