Mikko Partio mpartio at gmail.com
Wed Jul 18 21:58:35 PDT 2007
Hello all,

I have to set up a replica of our production database to a possibly insecure
location (DMZ). I have been using slony in other projects and the log
shipping mode would seem to fit this purpose perfectly, but, alas, it
requires that another slave is configured besides the origin node. This is
not very practical for us since the replicated database is large and we
don't have the hardware to support yet another slave. So, my question is
that is there any way to configure log shipping with just the origin and the
log shipping slave?

On a side note, I saw recently some discussion about the privileges of the
replication user, namely that the superuser mode is only required at the
initial subscription. Can I just ALTER USER x NOSUPERUSER when in "normal"
replication mode?

Regards

MP
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070719/=
4a64f017/attachment.htm


More information about the Slony1-general mailing list