From owner-freebsd-questions@FreeBSD.ORG Mon Apr 7 02:29:09 2003 Return-Path: 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 5BB8937B401 for ; Mon, 7 Apr 2003 02:29:09 -0700 (PDT) Received: from smtp.mailbox.co.uk (smtp.mailbox.co.uk [195.82.125.32]) by mx1.FreeBSD.org (Postfix) with ESMTP id CC5D643F93 for ; Mon, 7 Apr 2003 02:29:08 -0700 (PDT) (envelope-from wayne.pascoe@penguinpowered.org.uk) Received: from [212.18.244.168] (helo=marvin.penguinpowered.org.uk) by smtp.mailbox.co.uk with esmtp (Exim 3.36 #1) id 192Sw8-0002H5-00 for freebsd-questions@freebsd.org; Mon, 07 Apr 2003 10:29:08 +0100 Received: from waynep by marvin.penguinpowered.org.uk with local (Exim 3.33 #1) id 192T63-0001Ek-00 for freebsd-questions@freebsd.org; Mon, 07 Apr 2003 10:39:23 +0100 Date: Mon, 7 Apr 2003 10:39:23 +0100 From: Wayne Pascoe To: freebsd-questions@freebsd.org Message-ID: <20030407093923.GB604@marvin.penguinpowered.org.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4i X-System: FreeBSD i386 with kernel 4.8-STABLE Sender: User Waynep Subject: Postgres + MD5 Auth X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 07 Apr 2003 09:29:09 -0000 Hi all, Sorry to bug twice on one day, but does anyone know what I have to change in the startup scripts for PostgreSQL (010.pgsql.sh) to make it work with password authentication? I've setup pg_hba.conf to use encrypted passwords (md5), but then starting Postgres prompts for a password. This is not great for when the machine reboots and no-one is around to enter this. Is there any way of passing pgsql's password to the script ? Thanks, -- Wayne Pascoe