Re: Win32 Postgresql Command Line Password - Mailing list pgsql-admin

From Magnus Hagander
Subject Re: Win32 Postgresql Command Line Password
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE4767F7@algol.sollentuna.se
Whole thread Raw
List 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

pgsql-admin by date:

Previous
From: "Iain"
Date:
Subject: Re: Win32 Postgresql Command Line Password
Next
From: John DeSoi
Date:
Subject: Re: Win32 Postgresql Command Line Password Specification