| Ccmga1-YDxpq3io04c@public.gmane.org 2005-08-10, 7:25 am |
| >> I have 2 nodes, node 1 master, node 2 slave. Replication works fine
[color=darkred]
>Is it the slonik script that fails? Or is it slon that fails? That's
>not clear here...
It's the slonik script.
>In any case, the "Best Practices" handling of passwords is to store them
>in $HOME/.pgpass
That's what I do.
>Slony-I doesn't do anything at all special with the handling of
>authentication; it uses libpq, and hence if you are having connection
>problems, you should try using the same configuration to connect using
>psql. If psql asks for a password, that would be a hint that you need
>to stuff a password into $HOME/.pgpass
I tried the same failover/subscribe process after exchanging the 2 servers,
and I have the same problem.
but actually it think there is a config problem on one of the 2 servers as I
found that the standard php pg_connect function fails with host=localhost
and succeed with host='' (empty). very strange.
|