Re: OpenBSD startup - no logfile?
От | Frank Bax |
---|---|
Тема | Re: OpenBSD startup - no logfile? |
Дата | |
Msg-id | 3.0.6.32.20001019143739.0178f270@execulink.com обсуждение исходный текст |
Ответ на | OpenBSD startup - logfile? (Frank Bax <fbax@execulink.com>) |
Список | 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@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 > > >
В списке pgsql-general по дате отправления: