Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D9AD66332E5 for ; Sat, 13 Jun 2009 17:55:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 09232-08 for ; Sat, 13 Jun 2009 17:55:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f197.google.com (mail-px0-f197.google.com [209.85.216.197]) by mail.postgresql.org (Postfix) with ESMTP id 60CD9632BEA for ; Sat, 13 Jun 2009 17:55:11 -0300 (ADT) Received: by pxi35 with SMTP id 35so1988297pxi.15 for ; Sat, 13 Jun 2009 13:55:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:date:from:to:cc:subject :message-id:references:mime-version:content-type:content-disposition :in-reply-to:user-agent; bh=U7dkZVmajSMO93CAHO7MsRaRk5pHTTQWwHfXt7A5kB0=; b=DPNnmX3Y2o9QP6gSf+YP6nY2+D0PiOzTPx3uFo1rAQ6+o08K0A0Bopt6I/GX1lv5sZ DTFFuBdtShx7yd1lfnTSewr56RSgyP0D4Ytbobtk+3jlKPbAxePBWYFE3Ac4UevRkO/0 EIcK1LEn88EBxgUEf2fjudswPc2NMgxOKwq8U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=date:from:to:cc:subject:message-id:references:mime-version :content-type:content-disposition:in-reply-to:user-agent; b=b3cswlYkeQeZWYUzT4o9fNnfU22iVftu2VZVBVeYT2vfmyGu1tGqkadQa3C78x0yMi 6XJyZWhw2leDZUTHnZ+wFTJVAaw1CMQCn31IPaMMWjBci8Hzx2bU7CqP9CQFMK/XDlMF P80/7XBFZzuSFmlzpD2ns1dYe9UM6icneKr64= Received: by 10.143.7.5 with SMTP id k5mr2099461wfi.176.1244926509984; Sat, 13 Jun 2009 13:55:09 -0700 (PDT) Received: from eddie (c-67-182-227-82.hsd1.ut.comcast.net [67.182.227.82]) by mx.google.com with ESMTPS id 22sm1798756wfd.19.2009.06.13.13.55.08 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sat, 13 Jun 2009 13:55:09 -0700 (PDT) Date: Sat, 13 Jun 2009 14:55:01 -0600 From: Joshua Tolley To: Mark Fenbers Cc: PostgreSQL - SQL Subject: Re: drop PW Message-ID: <20090613205501.GQ12253@eddie> References: <4A341148.3040102@noaa.gov> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="WZLuFERxa6Y0cbOt" Content-Disposition: inline In-Reply-To: <4A341148.3040102@noaa.gov> User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=AWL=0.000 X-Spam-Level: X-Archive-Number: 200906/69 X-Sequence-Number: 32674 --WZLuFERxa6Y0cbOt Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sat, Jun 13, 2009 at 04:51:20PM -0400, Mark Fenbers wrote: > So how do I turn off being prompted for a password for george. (I am =20 > aware of the security risks...) Create a .pgpass file[1], or modify pg_hba.conf[2] - Josh / eggyknap [1] http://www.postgresql.org/docs/8.3/interactive/libpq-pgpass.html [2] http://www.postgresql.org/docs/8.3/interactive/client-authentication.ht= ml --WZLuFERxa6Y0cbOt Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAko0EiUACgkQRiRfCGf1UMM/vACfVG/0ie9PzIQCeqO45Uu6SWX5 nX4An0cFlOkMTnlFd0ZPHnoql0V19n0M =D0Hf -----END PGP SIGNATURE----- --WZLuFERxa6Y0cbOt--