Re: How to secure pgpass file from unauthorized reading of passwords ? (WIndows)

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to secure pgpass file from unauthorized reading of passwords ? (WIndows)
Date: 2005-10-12 13:27:35
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE6C7AB3@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Hello.
>
> It seems that for all automated tasks (backup, autovacuum
> etc.) passwords should be provided by pgpass file.
> But, anyone can read pgpass file....
>
> How can I make it secure that nobody can read it, except
> programs for backup and autovacuum ?

Set filesystem permissions on the file.

The default is to allow only the user who owns the directory to read it (plus administrators of course). I'm not sure where you get the "anyone can read pgpass" from.

//Magnus

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2005-10-12 13:30:50 Re: Row level locking
Previous Message TJ O'Donnell 2005-10-12 13:21:15 Re: problem with bit(n) type