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
==============================================================================
