On 9/24/07, Daniel B. Thurman <dant at cdkkt.com> wrote:
>
> >Daniel B. Thurman a =E9crit :
> >> I am having problems trying to get the slon service to run
> >with password:
> >>
> >> <snip>
> >>
> >> Thanks!
> >> Dan
> >>
> >>
> >Hi,
> >
> >It seems to me there's a mess between master and slave, either in
> >configuration file or on the command line.
> >
> >Could you tell us how you launched the slon daemons ?
> >
> >Regards,
> >SAS
> >
>
> I found the problem.  I was using pgAdminIII v8.0-beta-5 to configure
> the slons for the master and the slaves, and apparently it adds the
> connection strings in certain places but with missing keywords such as
> user=3D password=3D port=3D and so on.  I was able to repair this by going
> directly into the _Cluster tables and to correct them there.  I was
> able to get the slons and replication to work at this time.
>


That's one way to do it. A better way is to use .pgpass files. See the
postgresql documentation on this.

Andrew
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070924/=
27d5caa0/attachment.htm