> Hi, > > Another question : > The command "ps aux" displays the passord of my database user "slony" : > > slony 25628 0.0 2.1 14984 1356 pts/0 S+ 13:48 0:00 slon > slony_example dbname=pgbench user=slony password=*my_password* > > Is there a mean to prevent this ?! > With this information, any local user is able to connect to as a > postgresql superuser ! Very bad...
This has been documented for quite a long time in the FAQ... http://linuxfinances.info/info/faq.html#AEN41927 That recommends using $HOME/.pgpass to store authentication information. The alternative is to store the password in a slon config file, and have slon use the "-f" option to read that config file. I'd bias to using .pgpass; that's useful for more than just Slony-I... _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
