In my scene I have 50 slaves in different locals that it has different
admins, then if has a admin (hacker) He could access my master and modify
something.
 I only want limit access of the hakers admin.



2006/9/13, Manuel V?zquez Acosta <mva.led at gmail.com>:
>
> As far as I know, Slony-I will not replicate schema changes like
> create table. I'm not sure if the same applies to GRANT and REVOKE.
>
> On 9/13/06, Andrew And <andcop2006 at gmail.com> wrote:
> >
> >
> >  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 <smarlowe at g2switchworks.com>:
> > > 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 <andcop2006 at gmail.com> 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
> > > > > Slony1-general at gborg.postgresql.org
> > > > >
> > http://gborg.postgresql.org/mailman/listinfo/slony1-general
> > > > >
> > > > >
> > > > >
> > > > _______________________________________________
> > > > Slony1-general mailing list
> > > > Slony1-general at gborg.postgresql.org
> > > >
> > http://gborg.postgresql.org/mailman/listinfo/slony1-general
> > >
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060913/e979f124/attachment-0001.html