From owner-freebsd-questions@FreeBSD.ORG Wed May 24 08:12:14 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5A2EB16A587 for ; Wed, 24 May 2006 08:12:14 +0000 (UTC) (envelope-from nagylzs@freemail.hu) Received: from smtp.enternet.hu (smtp.enternet.hu [62.112.192.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id BB46343D5C for ; Wed, 24 May 2006 08:12:12 +0000 (GMT) (envelope-from nagylzs@freemail.hu) Received: from [62.112.200.65] (helo=[172.16.0.43]) by smtp.enternet.hu with esmtpa (Exim 4) id 1FioTR-0008Eq-Aw; Wed, 24 May 2006 10:12:09 +0200 Message-ID: <44741582.4010404@freemail.hu> Date: Wed, 24 May 2006 10:12:50 +0200 From: =?ISO-8859-2?Q?Nagy_L=E1szl=F3_Zsolt?= User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: Nick Withers , freebsd-questions@freebsd.org References: <44740DBD.1090303@messias.qhigh.com> <20060524175020.9f54dfae.nick@nickwithers.com> In-Reply-To: <20060524175020.9f54dfae.nick@nickwithers.com> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit Cc: Subject: Re: Postgresql Autovacuum how? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 24 May 2006 08:12:14 -0000 Nick Withers írta: > I've created a .pgpass file in /root (which is read only by > root) containing the password for the pgsql user. A quick > Google on "pgpass" turned up this content from > http://pgsqld.active-venture.com/libpq-files.html: > This is a broken link (for me at least). > _____ > > (...) > > This file should have the format: > > hostname:port:database:username:password > > Any of these may be a literal name, or *, which matches > anything. The first match will be used so put more specific > entries first. Entries with : or \ should be escaped with \. > > The permissions on .pgpass must disallow any access to world or > group; achieve this by the command chmod 0600 .pgaccess. If the > permissions are less strict than this, the file will be > ignored. > Thank you, I'll try this. > _____ > > >> This is my pg_hba.conf file: >> >> # TYPE DATABASE USER CIDR-ADDRESS METHOD >> # "local" is for Unix domain socket connections only >> local all all ident sameuser >> host all all 127.0.0.1/32 md5 >> hostssl all all 0.0.0.0 0.0.0.0 md5 >> >> The autovacuum script was packaged for FreeBSD, so I assume this is a >> FreeBSD specific thing. My question is: why ident/sameuser not working >> here? How can I enable auto vacuums without storing the password in the >> periodic/daily/502.pgsql script? >> > > I'm not familiar with the "sameuser" directive, presumably this > prohibits a system user from logging in as a user in the > database with a different name? Ident sameuser means that the user will be identified with the IDENT protocol. Then if the unix user name matches a postgresql user name, the user can connect without providing the password. Without giving 'sameuser', the unix and postgresql user names will be matched through pg_ident.conf. (I think I'm offtopic here, sorry) Best, Laci