X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 101AF8B9E6C for ; Tue, 8 Feb 2005 08:11:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81644-03 for ; Tue, 8 Feb 2005 08:11:22 +0000 (GMT) Received: from ar-sd.net (unknown [82.77.155.72]) by svr1.postgresql.org (Postfix) with ESMTP id DA0328B9E04 for ; Tue, 8 Feb 2005 08:11:22 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id 7B8231EC7D for ; Tue, 8 Feb 2005 10:05:17 +0200 (EET) Received: from ar-sd.net ([127.0.0.1]) by localhost (linz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13788-02 for ; Tue, 8 Feb 2005 10:05:16 +0200 (EET) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id 430821EBF0 for ; Tue, 8 Feb 2005 10:05:16 +0200 (EET) Message-ID: <007501c50db5$c6e204f0$0b00a8c0@forge> From: "Andrei Bintintan" To: Subject: Win32 Postgresql Command Line Password Specification Date: Tue, 8 Feb 2005 10:11:20 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0072_01C50DC6.892DC110" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at ar-sd.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.059 tagged_above=0 required=5 tests=AWL, HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200502/60 X-Sequence-Number: 16228 This is a multi-part message in MIME format. ------=_NextPart_000_0072_01C50DC6.892DC110 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,=20 I have to run some command line commands that I have to run on a windows = machine. Like pgsql, dropdb, createdb etc.=20 All these commands are runned from a php scripts.=20 Now, my question is how can I specify a User and Password to postgresql = database system. I found out how can I say the user, but the password is = always asked in the command line. I need this also to be specified in = the command.=20 for example: dropdb database1 -U postgres -W.... always ask a password = in the command line.=20 I want to specify in the command line the pass. The only solution that I found for this problem is to put the postgre = user autentication to trust and to skip the password.=20 Andy. ------=_NextPart_000_0072_01C50DC6.892DC110 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I have to run some command line = commands that I=20 have to run on a windows machine. Like pgsql, dropdb, createdb etc.=20
All these commands are runned from a = php scripts.=20
 
Now, my question is how can I specify a = User and=20 Password to postgresql database system. I found out how can I say the = user, but=20 the password is always asked in the command line. I need this also to be = specified in the command.
 
for example: dropdb database1 -U = postgres -W....=20 always ask a password in the command line.
I want to specify in the command line = the=20 pass.
 
The only solution that I found for this = problem is=20 to put the postgre user autentication to trust and to skip the password. =
 
Andy.
------=_NextPart_000_0072_01C50DC6.892DC110--