Sebastian K?hner wrote:

>Hello,
>
>I created a cluster successfully now.
>
>On starting slone I get the error:
>
>2005-09-07 14:55:02 ART ERROR  slon_connectdb: PQconnectdb("dbname=contact
>host=localhost user=postgres") failed - fe_sendauth: no password supplied
>
>I have password protection on my postgresql servers (I use a web-interface
>to connect to the database, so it's necesary to evite that everyone can
>login with localhost). Is there any way to setup the password with slony?
>
>Thanks!
>
>Sebastian
>
>  
>
Slony-I is a "plain, ordinary" libpq-linked application, so you can use
.pgpass to manage the passwords.

Here's the .pgpass documentation:
<http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html>

"Best practice" is indeed to use .pgpass; that means the passwords stay
in one place rather than being strewn across all kinds of scripts
everywhere in the environment.