X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E19189DC820 for ; Thu, 19 Jan 2006 16:11:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89649-07 for ; Thu, 19 Jan 2006 16:11:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web33506.mail.mud.yahoo.com (web33506.mail.mud.yahoo.com [68.142.206.155]) by postgresql.org (Postfix) with SMTP id 0840C9DC81D for ; Thu, 19 Jan 2006 16:11:26 -0400 (AST) Received: (qmail 16731 invoked by uid 60001); 19 Jan 2006 20:11:27 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.ca; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=qg2lzN5DxLLn2HCbrHt+PIwc9XpFQHRYGYjoqVgRdRUooROyxo9GvvWEUt/SA5o3mUuaZ02AoBqtKgYsr1qHjH0nJZEp7y3YfCjtKI0kJuKHsRTrv+dq2yms/H6H+Gy8c5bCIFNS7pF4g9mQw4JF+mTXqdve+Gtvpygq8YDIozY= ; Message-ID: <20060119201127.16729.qmail@web33506.mail.mud.yahoo.com> Received: from [24.42.230.5] by web33506.mail.mud.yahoo.com via HTTP; Thu, 19 Jan 2006 15:11:27 EST Date: Thu, 19 Jan 2006 15:11:27 -0500 (EST) From: Sean G Subject: Why psql.exe does not work? To: pgsql-admin@postgresql.org In-Reply-To: <17319.1137690111@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.239 required=5 tests=[AWL=0.239] X-Spam-Score: 0.239 X-Spam-Level: X-Archive-Number: 200601/220 X-Sequence-Number: 20308 Hello, I have done a silent installation, the installation worked eventually, and I can use pgAdmin interface to connect to it. However I have problem using psql.exe to connect to the database. I need to create a database called delphie from command line. It should be a part of the installation I'm working on. I used the follwing commands psql.exe -U root but it keeps giving me: psql: FATAL: password authentication failed for user "root" root is the supper user and the password is also root, but not only the program does not prompt for password but also there is no way that I can supply a password through the command line. The ultimate goal is I need to create a database automatically without user interacation. I have a sql script that I need to run to create the tables. I have used Oracle without problems before but not sure how to approach with Postgres. Any help/tip is greatly appreciaged. Sean