It would be interesting to find out if this works well enough.
One piece of simplistic advice though, from someone who has been there
with another distributed RADIUS system - make sure your master server
is used only for updates and maintenance queries - do NOT EVER use
it for "customer facing" queries. This will save you many sleepless
night.
You will also need to be in a position to verify the consistency of
the multiple slaves with the master.
Hey, that gives me a "idea" :) Is there an "easy" way to implement a
checksum on a table/relation ? Ignoring OID's I suspect ? Being able
to generate an MD5/SHA1/etc. digest on a relation, assuming that it is
primarily used for reading and not updated often, would be immensly
usefule for consistency checking.
On Thu, Jun 10, 1999 at 01:09:20PM +0100, John Reynolds wrote:
> Uggh,
>
> A bit of speculation on my behalf,
>
> You could run the master database postmaster with a -d option with the output
> redirected to a file, here's mine from my rc.x file (linux)
>
> su database -c '/usr/pgsql/bin/postmaster -i -D /usr/pgsql/data -d 2 >&
> /tmp/database.log &'
>
> I use to check what my servlets are looking up.
>
> You could write a perl script to strip the insert/update/delete from the
> output file and use the copy command to do the updates in the replicated
> databases (replicated by pg_dump of course).
>
> Of course I have never done this myself (I have no need yet)
>
> John
>
>
> Simon Rainey wrote:
>
> > Hi,
> >
> > I have an application that requires a database to be replicated on a number
> > of remote servers. Only the "master" database is ever modified, but I would
> > like the modifications to propagate within 10 minutes. The databases will
> > be used for user authentication (RADIUS, POP3 mail, FTP access etc.) with a
> > server at each dialup point of presence. I've seen similar questions asked
> > in the past but I can't find a clear answer.
> >
> > Thanks in advance.
> >
> > Simon.
>
> --
> ==============================================================================
> "There are no kernel hackers in Ireland. They spend all their time in the pub"
> Alan Cox
> ==============================================================================
>
>
>
>
--
Peter Galbavy
Knowledge Matters Ltd
http://www.knowledge.com/
