Re: Replication for R/W offline use

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: surrano(at)gmail(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication for R/W offline use
Date: 2009-08-13 20:28:33
Message-ID: e01b5cecb46acd4fc30eb1c4f83ae433@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

> First of all, I need Windows clients for offline use -- maybe cygwin will do.

Perhaps. Keep in mind the Bucardo daemon(s) can live anywhere, doesn't have
to be on the Windows boxes themselves.

> Second, I don't exactly know what is the effect of disabling triggers
> and rules: will it affect transactions running in parallel (a real
> problem), or will triggers be disabled for that transaction only
> (sounds like trouble)?

No, it will not affect anything outside of that transaction, and thus
cause no trouble.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 200908131627
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkqEd1QACgkQvJuQZxSWSshQwQCg4MhCPyzx0zmNFN3uCY6C/YRB
6OcAoNss20HkPudynjm1jt/TNS+NSour
=O0hG
-----END PGP SIGNATURE-----

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message chris.jurado 2009-08-14 05:03:07 Preventing OS administrator/root account access to data
Previous Message Kevin Grittner 2009-08-13 18:11:50 Re: Space usage