Re: Win32 Postgresql Command Line Password

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "John Jensen" <JRJ(at)ft(dot)fo>, <klodoma(at)ar-sd(dot)net>, <iain(at)mst(dot)co(dot)jp>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Win32 Postgresql Command Line Password
Date: 2005-02-08 11:36:14
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE4767F7@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> 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.
It applies to win32 as well, only the file is called "pgpass.conf", see
http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html

> 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 ...

No permissions checks are done on the file in win32. The default
permissions on the directory is very restrictive, but if you change it
then you'reo n your own.

//Magnus

Browse pgsql-admin by date

  From Date Subject
Next Message John DeSoi 2005-02-08 13:38:42 Re: Win32 Postgresql Command Line Password Specification
Previous Message Iain 2005-02-08 10:09:49 Re: Win32 Postgresql Command Line Password