> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
