On 8/29/07, Jeff Amiel <becauseimjeff@xxxxxxxxx> wrote:
> A couple of years back (2005) we were setting up replication for the first time (using slony) from
> our production database server to a stand-by box sitting next to it and a remote box in a DR
> site. We were running FreeBSD 5.X/6.X on all systems on Dell servers and postgres 7.4.X and then
> 8.0.X
>
> Replication appeared to crash our production database...a lot. After looking at the core
> dumps/stack traces at the time, we determined that we were crashing in the ssl layers....so we
> disabled SSL (via pg_hba.conf and the slony conn settings) and haven't had an issue for the last
> couple of years.
Interesting. Is it possible that either you've got 2 versions of
openssl? Maybe slony is being compiled against one, then using the
other lib, etc.?
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
