Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 20E2F9FB1CE for ; Wed, 20 Dec 2006 04:48:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 88018-06 for ; Wed, 20 Dec 2006 04:48:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 5CF9B9F939F for ; Wed, 20 Dec 2006 04:48:45 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from swarthymail-a6.dreamhost.com (sd-green-bigip-202.dreamhost.com [208.97.132.202]) by svr4.postgresql.org (Postfix) with ESMTP id 9B2305AF973 for ; Wed, 20 Dec 2006 08:48:43 +0000 (GMT) Received: from [192.168.2.44] (u25-56.dsl.vianetworks.de [212.168.164.56]) by swarthymail-a6.dreamhost.com (Postfix) with ESMTP id AC3B1107B39; Wed, 20 Dec 2006 00:48:18 -0800 (PST) Subject: Re: Embedding postgresql in my application From: Murray Cumming To: Alvaro Herrera Cc: "Jeroen T. Vermeulen" , pgsql-interfaces In-Reply-To: <20061219154654.GA3036@alvh.no-ip.org> References: <1166225144.12609.2.camel@localhost.localdomain> <20058.125.24.243.222.1166249768.squirrel@webmail.xs4all.nl> <1166542613.20613.19.camel@localhost.localdomain> <20061219154654.GA3036@alvh.no-ip.org> Content-Type: text/plain Date: Wed, 20 Dec 2006 09:47:57 +0100 Message-Id: <1166604477.5754.2.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200612/19 X-Sequence-Number: 6353 On Tue, 2006-12-19 at 12:46 -0300, Alvaro Herrera wrote: > Murray Cumming wrote: > > createuser asks for a password on stdin. Do you know of any way to > > specifify an initial superuser and password for a new database cluster > > without doing it via stdin? That doesn't seem like a stable API that I > > should rely on. > > Sure, initdb accepts the -U parameter to specify the user and you can > put the password in a temp file and give it to initdb with --pwfile. Thanks. That works well. -- Murray Cumming murrayc@murrayc.com www.murrayc.com www.openismus.com