Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id E82AD64FCDE
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 20 Dec 2008 04:26:52 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 45677-03 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 20 Dec 2008 04:26:50 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.kickstone.com (smtp.kickstone.com [87.194.183.70])
	by mail.postgresql.org (Postfix) with ESMTP id 3766D64FC9C
	for <pgsql-admin@postgresql.org>; Sat, 20 Dec 2008 04:26:50 -0400 (AST)
Received: from madras2.square-pi.com ([192.168.2.131] helo=MADRAS2)
	by mail.kickstone.com with esmtpa (Exim 4.69)
	(envelope-from <john.lister-ps@kickstone.com>) id 1LDxAc-0003fn-Vb
	for pgsql-admin@postgresql.org; Sat, 20 Dec 2008 08:26:47 +0000
Message-ID: <E68310A7222D4261AE7E96703FA775F7@squarepi.com>
From: "John Lister" <john.lister-ps@kickstone.com>
To: <pgsql-admin@postgresql.org>
References: <93f118f0812181248s122a93d3vaa09831d64d9e6ae@mail.gmail.com>
	<93f118f0812181534w1f78f0a5tda3a21a7074b04e6@mail.gmail.com>
Subject: Re: Incomplete Startup Packet on startup and when pg_maintenance
	--analyze runs in cron
Date: Sat, 20 Dec 2008 08:26:46 -0000
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=STOX_REPLY_TYPE=0.001
X-Spam-Level: 
X-Archive-Number: 200812/168
X-Sequence-Number: 31001

>Looks like /etc/cron.d/postgresql-common
># Run VACUUM ANALYSE on all databases every 5 hours if pg_autovacuum is not
># running
>2 0,5,10,15,20 * * 1-6 root if [ -x /usr/sbin/pg_maintenance ]; then 
>/usr/sbin/pg_maintenance --analyze >/dev/null; fi
>Is deprecated for postgresql versions 8.1 and higher and needs to be 
>commented out by default in those packages.


The pg_maintenance scripts check the state of the autovacuuum flag in the 
postgres config files. If it is enabled they simply quit and don't do 
anything. Disabling autovacuum causes them to run... So you can leave them 
uncommented...

Although why it causes the "Incomplete start-up packet" messages is a 
mystery...