X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9F7163A3ADB for ; Fri, 29 Oct 2004 16:54:48 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75641-06 for ; Fri, 29 Oct 2004 15:54:43 +0000 (GMT) Received: from dobber.bastun.net (dobber.bastun.net [213.222.51.199]) by svr1.postgresql.org (Postfix) with ESMTP id AEB513A3AD2 for ; Fri, 29 Oct 2004 16:54:42 +0100 (BST) Received: from dobber.bastun.net (dobber@localhost [127.0.0.1]) by dobber.bastun.net (8.13.1/8.13.1/Debian-15) with ESMTP id i9TFsq9Z022989 for ; Fri, 29 Oct 2004 18:54:52 +0300 Received: from localhost (localhost [[UNIX: localhost]]) by dobber.bastun.net (8.13.1/8.13.1/Submit) id i9TFsqY9022986 for pgsql-admin@postgresql.org; Fri, 29 Oct 2004 18:54:52 +0300 X-Authentication-Warning: dobber.bastun.net: dobber set sender to dobber@bastun.net using -f From: Ivan Dimitrov Reply-To: dobber@bastun.net To: pgsql-admin@postgresql.org Subject: Re: pg_autovacuum is not working Date: Fri, 29 Oct 2004 18:54:45 +0300 User-Agent: KMail/1.7 References: <200410291304.42472.dobber@bastun.net> <16332.1099063232@sss.pgh.pa.us> In-Reply-To: <16332.1099063232@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart4299925.4jIjHpGncI"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200410291854.51807.dobber@bastun.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/378 X-Sequence-Number: 15371 --nextPart4299925.4jIjHpGncI Content-Type: text/plain; charset="windows-1251" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline The problem was in my resolve.conf, the nameserver I've set is my datacente= r=20 provider who have localhost.provider.net point to 127.0.0.1 and postmaster= =20 couldn't bind to that host. For whatever reason. It does not check /etc/hos= ts=20 too so I'll play with it on Mondey. =CD=E0 29.10.2004 18:20 =E2=E8=E5 =ED=E0=EF=E8=F1=E0=F5=F2=E5: > Ivan Dimitrov writes: > > autovacuum.log > > [2004-10-29 12:41:20 PM] Error: GUC variable stats_row_level must be > > enabled. [2004-10-29 12:41:20 PM] Please fix the problems and try > > again. > > > > What could be the reason for this. > > I'd say autovacuum is being perfectly clear what it's not happy about. > > Are you sure you are editing the right copy of postgresql.conf? I seem > to recall that the Debian distribution patches the PG code to look for > that file in (what we consider) a nonstandard place. > > regards, tom lane =2D-=20 Hi! I'm your friendly neighbourhood signature virus. Copy me to your signature file and help me spread! --nextPart4299925.4jIjHpGncI Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQBBgmfLKBhoPewcguwRAvurAJ461ZNr0jxVo0OjRIZWC80hnKcA5QCfWtEV R9aEeQsmablIbUBzsRpFy8A= =Dihc -----END PGP SIGNATURE----- --nextPart4299925.4jIjHpGncI--