Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 24 May 2006 11:36:50 +0200
From:      =?ISO-8859-2?Q?Nagy_L=E1szl=F3_Zsolt?= <nagylzs@freemail.hu>
To:        Nick Withers <nick@nickwithers.com>,  freebsd-questions@freebsd.org
Subject:   Re: Postgresql Autovacuum how?
Message-ID:  <44742932.4030008@freemail.hu>
In-Reply-To: <20060524175020.9f54dfae.nick@nickwithers.com>
References:  <44740DBD.1090303@messias.qhigh.com> <20060524175020.9f54dfae.nick@nickwithers.com>

next in thread | previous in thread | raw e-mail | index | archive | help

> 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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44742932.4030008>