Re: pg_autovacuum

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Adam Kavan <akavan(at)cox(dot)net>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_autovacuum
Date: 2003-09-04 18:25:43
Message-ID: 3F5783A7.4090103@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adam Kavan wrote:

> At 10:48 AM 9/4/03 -0400, Matthew T. O'Connor wrote:
>>On Thu, 2003-09-04 at 09:01, Jan Wieck wrote:
>> > Do the stats_* options appear twice in the config file? If that isn't
>> > the case, the only possible problem left I can think of is that you're
>> > running on a platform where no AF_UNIX sockets are available, like under
>> > Windows?
>>
>>Nope he is running under RH9 (I don't know if it's stock, or highly
>>modified, but RH9 none the less) Also, the config file is mostly just
>>default values with the appropriate stat settings uncommented and set to
>>true. (also pg_autovacuum will fail to run if it detects improper stat
>>system settings, so that isn't the problem.)
>
> Its a stock system, no changes fresh off the ftp. The only change I have
> made is installing postgres.

Hmmmm ... would need to take a look at the code ... but a wild guess
would be the communication between the backends and the collector
daemon. I'm not sure if the UDP crap^H^H^H^Hstuff I used in there is
IPV6 safe. What version of PostgreSQL was that?

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Derrick Betts 2003-09-04 18:31:53 SQL Error: pqReadData() -- read() failed: errno=0 No error
Previous Message Richard Huxton 2003-09-04 18:21:38 Re: automatic update