Hi,
Marc G. Fournier wrote:
> For instance, if we had a read-only database on a mirror site,
> replicated from the main database using something like Slony ... how
> hard would it be t have 'write operations' sent to the main web site to
> happen, with all read operations being local?
What's the point? You can't realistically expect permanent high-speed
connectivity between master and slaves, thus replication will be *extremely*
asynchronous.
The only obviuos benefit I see is reduced traffic.
> ie. posting news events would happen at http://www.postgresql.org, but
> reading news events would be @ http://www.xx.postgresql.org, but both
> could/would be dynamic?
It works this way even now.