Postgresql Autovacuum how?

Nagy László Zsolt nagylzs at freemail.hu
Wed May 24 02:36:53 PDT 2006


> I've created a .pgpass file in /root (which is read only by
> root) containing the password for the pgsql user. A quick
> Google on "pgpass" turned up this content from
> http://pgsqld.active-venture.com/libpq-files.html:
>   
That link is broken, but here is a good one:

http://www.postgresql.org/docs/8.1/interactive/libpq-pgpass.html

I had to put in into ~pgsql/.pgpass.

However, for other users, it works for me ONLY if the database name and 
the user name are the same.
Otherwise it prompts for a password. But that is antoher problem.

Thanks,

  Laci



More information about the freebsd-questions mailing list