Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7KEJQP33133 for ; Mon, 20 Aug 2001 10:19:26 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from gabuzo.dyn.cheapnet.net (r138m13.cybercable.tm.fr [195.132.138.13]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7H8MlP76580 for ; Fri, 17 Aug 2001 04:22:48 -0400 (EDT) (envelope-from christophe@labouisse.org) Received: by gabuzo.dyn.cheapnet.net (Postfix, from userid 501) id 52F80700D0; Fri, 17 Aug 2001 10:22:44 +0200 (CEST) To: pgsql-sql@postgresql.org Subject: pg_ctl start hangs From: Christophe Labouisse Date: 17 Aug 2001 10:22:44 +0200 Message-ID: Lines: 18 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Academic Rigor) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200108/240 X-Sequence-Number: 4472 When restarting postgres this morning I notice the pg_ctl start hangs forever while the database seems to be up and working. Eventually I found out that the start process involves a "psql -l" which waits for me to enter a password since I have "local all password" in my pg_hba.conf. I change back to trust but since I have users with shell access on the server I'd would like to switch back to "password". I used the following command to start the database: /usr/local/bin/pg_ctl start -s -w -l /usr/local/pgsql/errlog -o "-i" My configuration: FreeBSD 4.3, Postgresql 7.1.2 -- Le cinéma en Lumière : http://www.lumiere.org/ Fingerprint : 4721 651D D309 B302 93E4 5D73 CC52 DF3A E7C7 86CF