Re: Segmentation Fault

2012/6/11 Benson Jin <benson(dot)jin(at)troo(dot)com>:
> Hi All,
>
> We are having a problem with our streaming replication read only node. It
> has crashed a few times with a couple of different reasons, mostly
> "segmentation fault". The latest log are listed below:
>
> 2012-05-30 23:56:37.385 UTC::: LOG:  server process (PID 19476) was
> terminated by signal 11: Segmentation fault
> 2012-05-30 23:56:37.385 UTC::: LOG:  terminating any other active server
> processes
> 2012-05-30 23:56:37.385 UTC:10.43.6.61:webmaster:panorama WARNING:
>  terminating connection because of crash of another server process

[... cut ...]

> Our setup:
> 2x physical server - Dell PE R815, 64GB ECC RAM, 2 CPUs (12 cores each),
>  storing pgsql data on SAN backed volumes.
> CentOS 5.6
> PostgreSQL 9.0.8, compiled *without* int64 datetime.
> Both servers are identically configured (or at least as much as we could
> ensure)

Did you compiled it from scratch e.g. make clean && make && make install?

[]s
--
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br