I have 50 slaves. Now My client has permission to connect in master with pgsql and modify DB (example: create table and others commands). I need to limit access, I try to use GRANT but slony show me error.
First step: In /etc/postgresql/pg_hba.conf I already give permission to IP´s of the slaves connect, and I am correct in this step.
Segund step: First I User REVOKE ALL in BD, after I give permissions with GRANT but I am not correct in this step.
Could someone help me with the second step?
2006/9/12, Scott Marlowe <[EMAIL PROTECTED]>:
pgpool II just came out, and I think it can handle > 2 servers...
On Tue, 2006-09-12 at 17:18, Manuel Vázquez Acosta wrote:
> Andrew,
>
> Though limited to 2 servers, you should check pgpool.
>
> It can integrates with slony and load balance your queries in a way
> that select queries are issued to both the master and slave; but
> transactions and queries that can potentially (generally) modify the
> DB are sent to the master (and slony makes the replica).
>
> Google for pgpool and you'll find more info. If you have more than 2
> servers, then pgpool is not your answer.
>
> Best regards,
> Manuel.
>
> On 9/12/06, Andrew And <[EMAIL PROTECTED]> wrote:
> >
> >
> > I am using Slony but I can not that users in slaves computers access my
> > master, and I want that the users commands can not alter my master. How
> > can I limit access of the users in slaves computers in Master db?
> >
> > _______________________________________________
> > Slony1-general mailing list
> > [email protected]
> > http://gborg.postgresql.org/mailman/listinfo/slony1-general
> >
> >
> >
> _______________________________________________
> Slony1-general mailing list
> [email protected]
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
