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 A1B6A8B9EAB for ; Tue, 8 Feb 2005 09:36:59 +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 94110-02 for ; Tue, 8 Feb 2005 09:36:48 +0000 (GMT) Received: from fs3.ft.fo (mail-gw.ft.fo [212.55.40.2]) by svr1.postgresql.org (Postfix) with ESMTP id 00DAD8B9E6C for ; Tue, 8 Feb 2005 09:36:48 +0000 (GMT) Received: from FT_DOM-MTA by fs3.ft.fo with Novell_GroupWise; Tue, 08 Feb 2005 09:36:46 +0000 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.1 Date: Tue, 08 Feb 2005 09:36:15 +0000 From: "John Jensen" To: , , Subject: Re: Win32 Postgresql Command Line Password Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/63 X-Sequence-Number: 16231 This might not apply to the win32 version. But in the Unix version you can put this information in a .pgpass file. This enables you to keep passwords on all user accounts and still be able to automate tasks. There is a number of permission/ownership requirements on this file in the Unix version. These might not be compatible with win32 so use at your own perril ;-). And check the manual ... I currently use this approach on a Linux box for automating the maintenance tasks through cron jobs. Cheers, John >>> "Iain" 08-02-2005 08:37:54 >>> I think that's the best way to do it. Rather than leave passwords lying around in script files, it might be best to trust a specific (specially created) user when running from a specific location on the specific database. Then you just have to keep that user account secure. I can imagine how it would work wth linux, but am not sure what problems youmay face under windows. The only other alternative I can imagine is to use another program to type the password in automatically. I've never done it but I'm sure such a beast must exist. The long and the short of it is (at least upto 7.4.6 - I don't know about later versions) thereis no way to specify the password on the commandline. Regards Iain ----- Original Message ----- From: Andrei Bintintan To: pgsql-admin@postgresql.org Sent: Tuesday, February 08, 2005 5:11 PM Subject: [ADMIN] Win32 Postgresql Command Line Password Specification Hi, I have to run some command line commands that I have to run on a windows machine. Like pgsql, dropdb, createdb etc. All these commands are runned from a php scripts. 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. for example: dropdb database1 -U postgres -W.... always ask a password in the command line. 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. Andy.